Query Syntax
Last updated
Last updated
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.
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.
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.
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.
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)
