You can now create visualizations of your data’s Key Performance Indicators (KPIs). Using this feature, you can track the changes in important KPIs in your data. When you configure the KPI chart to suit your business use case, you can save it as an answer, add it to a Liveboard to increase visibility, or create alerts to receive notifications on the changes in the KPI using the Monitor feature.
When you search a single measure, such as Sales, ThoughtSpot automatically creates a KPI chart displaying the topmost value of that column. If you search multiple terms, you can configure the column visualized in your KPI chart. To tailor the KPI visualization to your business use case, you can add time comparison keywords such as “weekly” or “monthly” to change the aggregation of your KPI, use the chart configuration menu to decide how much information to display, or apply conditional formatting.
You can visualize an attribute (string, date, boolean value) as a KPI chart. This feature allows you to create KPIs for values such as "Date" or "Product".
To create an attribute KPI, follow these steps:
Search for the attribute in the Search bar.
A table displaying all values of the attribute appears. To view the KPI chart, choose one option:
Select the table to chart toggle above your answer and click the chart icon.
Click the chart icon to the right of your answer and select the KPI chart option.
If your search contains multiple columns, select the chart configuration icon to the right of your answer. Drag and drop the attribute column into the visualized section to visualize it in the KPI chart.
Please note that if your query returns more than one row of results, the KPI chart displays the topmost value from the result table.
If you search multiple measures or attributes, the KPI chart automatically displays only the first search term. To create a KPI chart based on another measure or attribute from your search, click the chart configuration icon and drag and drop the currently visualized column to the Not visualized section. Select the new measure or attribute from the Not visualized section and drag and drop it into the Visualized section.
If you include time column (columns of type Date, Datetime, Timestamp and Time) or time period keyword (Hourly, Daily, Weekly, etc.) in your search, the keyword appears in the Time axis section.
If you search a measure or attribute with a keyword comparing across time periods, such as
Sales weekly, your KPI visualization displays data corresponding to the most recent date bucket associated with your search. For a measure KPI, the percent increase or decrease in that data from the previous data point appears.
In the following example, the total sales for the week of 02/21/2022 was 3.21M. This measure increased 0.2% compared to the total sales for the previous week, 3.2M. Here, “WoW” signifies that the percent change is calculated week-over-week. You can also search a measure by day (DoD), month (MoM), quarter (QoQ), or year (YoY).
To create a KPI chart that displays the change between two specific date buckets, define the time periods for comparison in the search bar. For example, to compare the change in sales between this quarter and the previous quarter, search for
sales quarterly this quarter last quarter.
|You can only create KPI charts with data arranged in ascending, or chronological, order. You cannot create a KPI chart from any search using “date descending” as a filter.|
For more information on using time period keywords in search, see Time series analysis
When you search for a measure with a time-series keyword, for example
Sales monthly, your KPI chart automatically displays a sparkline visualization of all the data points defined in your query. For ease of comparison, the two most recent data points are highlighted in the sparkline visualization. When the date bucket defined by your query is in progress (for example, a
sales weekly KPI you consult on a Wednesday), your sparkline visualization shows a dotted line between the last data point and the accumulated value by the latest date.
To see the exact value of the metric and corresponding date for each data point, hover over the sparkline visualization .
When you create a KPI chart with a time period keyword, you can change the display options before saving as an answer or pinning to a Liveboard.
Click the chart configuration icon and select Settings to make the following display changes:
Show Date Label to display or hide the date label.
Show Sparkline to display or hide the time-series visualization.
Show Comparison to display or hide the percentage change since the last period selected.
Positive change color to change the color of the percentage increase label.
Negative change color to change the color of the percentage decrease label.
You can add visual cues for KPIs or threshold metrics to easily show where you are falling short or exceeding targets. These visual cues are called conditional formatting, which applies color and font formatting to your search result. Add conditional formatting to show the threshold(s) you defined, and the data that falls within them will be shown using the same color.
|Conditional formatting affects the text of a KPI visualization, it does not appear in sparkline visualizations.|
To apply conditional formatting to your KPI, follow these steps:
Select the Edit chart icon to the right of your KPI.
Click the measure tile under the Visualized section, for example, “Total Sales”.
Under the Conditional formatting dropdown, select +Add rule.
Define the values of your range and set the formatting options. In the example below, the KPI text turns red and bold when its value satisfies the condition, “between 180,000 and 200,000.”
You can view the conditional formatting rule(s) applied to a KPI by clicking on the information icon that appears to the right of the measure.
While ThoughtSpot supports SpotIQ analysis for KPI charts, change analysis, or analysis run between two points selected on a chart, is not currently supported for KPI sparklines.
When you pin a KPI visualization to a Liveboard or save it as an answer, you can create alert notifications for yourself and others. You must have view access to the KPI’s data source to schedule notifications for yourself. You must have edit access to the underlying data source to schedule notifications for teammates regardless of whether they have access.
For more information on the Monitor feature, see Monitor Key Performance Indicators in your data.