Time compare

It is often useful to be able to see the current trend of data as compared to data from a previous period.

In Pivot, you can select a reference time period to compare against, and all of your measures will be augmented with delta indicators visualizing their change. In the image above, the light gray line is the historical, which provides useful context to the blue line, which is the time period being analyzed.

The comparison is activated by selecting Compare from the measure dropdown.

Compare line chart

The time compare augmented visualizations can be composed into dashboards, allowing you to get a quick overview of your relative performance.

Compare dashboard

Furthermore, it is possible to sort on the data by the delta change column which, in one click, would bring the biggest movers in a given measure to the top of the view, allowing you to see which values changed the most.

Compare table





Manage Data

Query Data



Special UI Features