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.
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
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
- 10.5K All Categories
- 6 Connect
- 916 Connectors
- 250 Workbench
- 463 Transform
- 1.7K Magic ETL
- 69 SQL DataFlows
- 476 Datasets
- 189 Visualize
- 252 Beast Mode
- 2.1K Charting
- 11 Variables
- 78 Cards, Dashboards, Stories
- 17 Automate
- 354 APIs & Domo Developer
- 89 Apps
- 3 Workflows
- 20 Predict
- 5 Jupyter Workspaces
- 15 R & Python Tiles
- 246 Distribute
- 62 Domo Everywhere
- 243 Scheduled Reports
- 21 Manage
- 42 Governance & Security
- 172 Product Ideas
- 1.2K Ideas Exchange
- 11 Community Forums
- 27 Getting Started
- 14 Community Member Introductions
- 55 Community News
- 4.5K Archive