Preset Feature Feedback
Add a new idea Subscribe
Status Gathering Feedback
Categories New feature
Created by Scott Hildebrand
Created on Oct 17, 2022

RELATED IDEAS

Allow Mixed-Time-Series Chart to Use 2 Different Datasets

Why Useful: Reduces time and skill needed to bring data into a single chart to view disparate data sources comparing results in single chart. (Allows business users to self service)

Examples:

  1. Sale Table vs. Inventory Table

  2. Customer Visits Table vs Sales Table

  3. Staffing Table vs. Call Center SLA Table

Who Benefits: Business Analysts performing initial data discovery, business users who want a single chart with multiple data sources.


How: For a Mixed-Time-Series Chart, in Query B, the user could decide to use the same dataset as Query A or Choose a different dataset. The data should display in the chart with both having a date x-axis, the Primary Y Axis aligning to Query A, and the Secondary Y Axis aligning to Query B.

Future would be to add n additional queries to the chart (Query C, Query D, etc.)

  • Attach files
  • Scott Hildebrand
    Reply
    |     Nov 8, 2022

    Could also allow publicly available data to be layered with business data.
    i.e. Average Monthly Gas Prices (Dataset 1) && Average Monthly Value/transaction (Dataset 2)
    (https://data.bls.gov/timeseries/APU000074714 - data would need added to data warehouse)


    Both using the same x Axis with different Y axis price ranges which could then use Primary vs secondary axis - or better yet, auto-detect the Y axis range per dataset using MIN and MAX to fit the data into the chart window.