Slack Integration as a User

Knowi's slack integration combines our powerful search-based analytics capabilities with Slack's intuitive messaging user interface. This enables users to ask questions of their data, receive answers, and visualize those answers within Slack.

There are two steps in the process of setting up Knowi's slack integration. The first step is installing the Knowi bot, which must be done by a Slack admin, which your admin should have already taken care of. If your admin has not installed the Knowi bot, you will see an error message, in which case you must refer them to this this page.


Sections

  • Manage Queries and Notifications
    • Dashboards and Widgets
    • Dashboard & Widgets Results
  • Create Your Own Question
    • Question Results
    • Favorite Queries
  • Example Questions


Manage Queries and Notifications

Once Slack integration is set up, enter /knowi in any channel to bring up the Manage Queries and Notifications menu. 


Dashboards and Widgets

From Slack, you can interact directly with dashboards and widgets in your connected Knowi account. Select the dashboard or widget from the dropdown to Get, Ask, or Explore it. 


Get

Retrieves a PDF report of the dashboard/widget sent directly to the Slack channel.

Ask

Ask allows you to filter the results of the dashboard/widget report based on a value(s) you enter. For example, if you have a dashboard/widget with data for several employees and you want to filter for just one, simply enter the employee name when prompted:

When the PDF report is returned, it will only show data for "Justina Burdi":


Explore

Explore will automatically redirect you to the dashboard/widget in the Knowi app. Note: It will prompt you to enter login credentials if you are not already logged into the account the dashboard/widget resides.


Dashboard & Widgets Results

Once results are returned from a Get or Ask operation on a dashboard/widget, you have the option to Share, Rerun, Ask, or Explore the results.


Share

Share the dashboard/widget report to another channel or conversation in your Slack workspace with an optional message.


Rerun

To re-run the Get or Ask operation on a dashboard/widget.

Ask 

Similar to the Ask operation above, you can also use Ask to further filter the dashboard/widget report returned. 

Explore

Similar to the Explore operation above, you can also use Explore to be redirected to the dashboard/widget from the report returned. 

Create Your Own Question

To create your won question from scratch:

  1. Enter /knowi followed by your question:
    • /knowi <your_question>
  2. In a few moments, your answer will be returned in the form of a visualization


Select a Dataset 

This allows you to select the dataset you want to query by adding -d at the end:

  1. Enter the command:
    • /knowi <your_question> -d
  2. The Knowi Search Analytics window will pop-up, with a drop down to select a dataset and a text box with the query string of your question
  3. Use the dropdown to select the dataset you want to query (by default, it chooses the best match)
  4. Click Submit
  5. In a few moments, your answer will be returned in the form of a visualization

You can also specify the dataset name upfront: 

  1. Enter the command:
    • <your_question> -d <dataset name>
  2. The Knowi Search Analytics window will pop-up and the dataset name you entered will be pre-selected in the dropdown
  3. Click Submit
  4. In a few moments, your answer will be returned in the form of a visualization

Example:


Question Results

Once the results of your question is returned, you have the option to Download, Explore/Validate, save as Favorite, Share, or Schedule the results.

Download Data

Select to Download Data to export your results to CSV.

Explore/Validate

Selecting Explore/Validate will automatically redirect you to the Visualization settings of your results where you can edit the visualization type and settings.

In the Data tab, you can validate and edit the results, ask a new questions in the search-based analytics bar, or download and reset the results. 


Share

Allows you to share the question you asked to another channel or conversation in your Slack workspace with an optional message.


Schedule

Allows you to schedule your question/query to run at a chosen interval. Once you click on "Schedule", you'll see the following settings:

  • Query String - The query syntax of your question (this can edited)
  • Alert Frequency - Enter how frequently you want the alert to run
  • Alert Frequency Type - Select the alert interval (minutes, hours, days, month)
  • Schedule report to a Conversation - Select the Slack channel or conversation the query results will be sent to
  • Starting At (optional) - Select the start date for the alert


Favorite Queries

Adding a question/query to Favorite allows you to save and reuse your questions and organize them in categories. Very useful for commonly asked questions.

To set up Favorite Queries:

  1. Enter your question preceded by /knowi (i.e. /knowi
  2. Once the results are returned, click Favorite
  3. Click Create new category and give it a name
  4. Click Save
  5. The next time you enter the command /knowi, the Category you created and the query you saved will appear as a drop down option under Favorite Queries
  6. Under Favorite Queries, you can run the pre-configured query, modify, or delete it


Example Questions

Below are some commonly used question/query formats to get you started. Note that your actual question will vary based on your dataset and use case. 


"All Details" Command

A handy query for getting detailed results for a string value (i.e. customer, product, sales associate,  etc.) in your dataset. This will return all records in the dataset that match the value. 

Format:

/knowi <"all details for"> <string value> -d

Example:

/knowi all details for Wells Fargo -d


Rolling Date Range

Format:

/knowi <"all details for"> <string value> since <time frame>

Example:

/knowi all details for Wells Fargo since yesterday
"Where" Statement

Format:

/knowi <"all details for"> <string value 1> where <column name> is <string value 2>

Example:

/knowi all details for Wells Fargo where message type is Marketing