Query Syntax
Presight supports a syntax that allows you to type out what you want to ask in a fast and much more human-friendly format, instead of having to select data fields in existing BI tools.
The syntax for query data on Presight (following /chart or /records table commands) is:
[Metric Name] by [Dimension Name] [Dimension Value] [Time Period]
Example:
Sales by Region North America this month
Customer Count by Product All quarter over quarter
For every component, Presight will prompt you a choice menu through which you can complete the query quickly to generate the data you want.
Metric Prompt
All the metrics you have access to will be presented to you in the prompt following the trigger syntax /chart or /records table. You only have to type it out and select the matching result.
Dimension Prompt
All the dimensions available to the selected metric will be listed next. Choose the dimension you'd like to see the metric broken down by, or select None if you don't need it dissected.
Dimension Value Prompt
Sometimes you have a specific question, like "What is the current sales for Region Europe?" - rather than a need to see Sales broken down by all regions. For that, you can navigate to the specific values and select them when the Dimension Value prompt appears, else, you can proceed with All.
Time Period
The last component of the query is to select the time period of which you want the chart to show the data from. You can either ask Presight in a regular style like this month, this year or ask it to compare the data period over period (month over month, year over year, etc)
The purpose of the query is to quickly get the relevant data out in front of your eyes, so you can have a feel of it, or start playing around. You can always quickly adjust the chart to better fit your reiterated questions, using the menu options available on the widgets.
Last updated
