2023.01

2023.01

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

›Advanced features

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

CrossTab (deprecated)

The CrossTab view is deprecated. Please use Pivot 2.0 instead. Pivot 2.0 incorporates the capabilities of CrossTab view.

The CrossTab view is a data visualization mode in Pivot that gives you a pivot table-like view of your data.

CrossTab makes data easier to analyze and understand by allowing you to aggregate data on multiple dimensions, such as Wikipedia edit data by Country Name and City Name in the following figure.

CrossTab view

Further, by adding dimensions as columns, you can view measure data by individual dimension values.

To use CrossTab view:

  1. Enable CrossTab from the Feature flags tab in Settings. See Feature Flags for more information.

  2. In the data cube, choose CrossTab from data view options menu:

    CrossTab view

You can then drag and drop dimensions to Rows and Columns.

To exit CrossTab view, choose Data Cube Classic from the data view options menu.

Last updated on 10/20/2021
← ExplainPivot server config →
2023.01
Key links
Try ImplyApache Druid siteImply GitHub
Get help
Stack OverflowSupportContact us
Learn more
Apache Druid forumsBlog
Copyright © 2023 Imply Data, Inc