2023.01

2023.01

  • Imply
  • Ingest
  • Query
  • Visualize
  • Administer
  • Deploy

›Data cubes

Overview

  • Pivot overview
  • Datasources
  • SQL

Data cubes

  • About data cubes
  • Managing data cubes
  • Visualizations
  • Dimensions
  • Measures
  • Custom dimensions and measures
  • Time compare
  • Filter by measure
  • Annotations
  • Data export

Dashboards

  • Viewing dashboards
  • Creating dashboards
  • Managing dashboards

Alerts & Reports

  • Alerts
  • Scheduled reports

User access

  • Access control
  • User management in Pivot
  • Manage users with LDAP
  • Manage users with OIDC

Advanced features

  • Feature Flags
  • Customizing the Pivot UI
  • Generating links into Pivot
  • Monitor queries
  • Explain
  • CrossTab
  • Pivot server config
  • Plywood Expressions
  • Query parameters reference

Pivot API

  • Pivot API overview
  • Pivot users API
  • Pivot UserAuth API
  • Pivot user statuses API
  • Pivot roles API
  • Pivot connections API
  • Pivot data cubes API
  • Pivot dashboards API
  • Pivot alerts API
  • Pivot reports API

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

Last updated on 10/3/2020
← Custom dimensions and measuresFilter by measure →
2023.01
Key links
Try ImplyApache Druid siteImply GitHub
Get help
Stack OverflowSupportContact us
Learn more
Apache Druid forumsBlog
Copyright © 2023 Imply Data, Inc