Tableau like parameter functionality
Hi all. I am trying to build a chart (bar/line) where I am displaying NPS. I'd like to be able to breakdown the chart by different categories (i.e. Region, Segment, etc.) I've found that I can use the Trellis functionality to breakdown the chart by a specific segment. Now I'd like to be able to replace that category field with another one and give the user the control to do so. E.G. Show NPS by Region or by Segment in the same card.
Comments
-
Hi @user003454
You'd need to format your data differently to get something like this to work such that a single column would have your categories for Region and Segment combines along with another column denoting the type of category label it is ('Region' or 'Segment').
You could pull only the Region data first and then pull the segment data into two separate views / dataset and then use a Data Fusion to append them together so they're stacked on top of each other like this:
Date Value Category Category Type 2020-01-01 100 A Region 2020-01-01 200 B Region
2020-02-01 125 A Region 2020-01-01 500 One Segment 2020-01-01 800 Two Segment 2020-01-01 750 One Segment You can then plot your data and add a quick filter and force it to be a radio button type selection to allow only a single category type to be selected. Your user could then use the quick filter to toggle which type of categorization they want with the quick filter (Region or Segment) and then the data would be filtered.
You wouldn't necessarily be able to change the chart properties like the axis labels dynamically but you can use this to change the graph dynamically.
**Was this post helpful? Click Agree or Like below**
**Did this solve your problem? Accept it as a solution!**3 -
@GrantSmith this is so clever! i love it.
but also, @user003454 this will make your data dangerous in untrained hands.
maybe consider using drill through to show the chart by region and then when a user clicks it navigates to a chart that shows the data by segment.
when you structure the data the way Grant is proposing if users accidentally don't choose a 'Category Type' the chart gives nonsensical numbers.
Jae Wilson
Check out my 🎥 Domo Training YouTube Channel 👨💻
**Say "Thanks" by clicking the ❤️ in the post that helped you.
**Please mark the post that solves your problem by clicking on "Accept as Solution"0
Categories
- All Categories
- 1.8K Product Ideas
- 1.8K Ideas Exchange
- 1.5K Connect
- 1.2K Connectors
- 298 Workbench
- 6 Cloud Amplifier
- 8 Federated
- 2.9K Transform
- 100 SQL DataFlows
- 616 Datasets
- 2.2K Magic ETL
- 3.8K Visualize
- 2.5K Charting
- 729 Beast Mode
- 54 App Studio
- 40 Variables
- 678 Automate
- 173 Apps
- 451 APIs & Domo Developer
- 46 Workflows
- 8 DomoAI
- 34 Predict
- 14 Jupyter Workspaces
- 20 R & Python Tiles
- 394 Distribute
- 113 Domo Everywhere
- 275 Scheduled Reports
- 6 Software Integrations
- 121 Manage
- 118 Governance & Security
- Domo Community Gallery
- 32 Product Releases
- 10 Domo University
- 5.4K Community Forums
- 40 Getting Started
- 30 Community Member Introductions
- 108 Community Announcements
- 4.8K Archive