Filter for x-axis values
Is it possible to filter for the values that are used for the x-axis on a bar graph?
For example, have a chart that is currently showing volume by month. I'd like to have a filter that will allow the user to switch the x-axis values between month and week. Is it possible to do?
I want to allow the users to switch between these two views by selecting the value in a filter:MonthlyWeekly
Best Answer
-
You could use a drill path to have the user click on the month they want to explore and have the underlying view aggregate at the week level.
Also, would having them use the "Graph By" option work for you?
“There is a superhero in all of us, we just need the courage to put on the cape.” -Superman0
Answers
-
I'm unaware of a way to have a filter disaggregate a card configured on one dimension and have it aggregate on another dimension. I dont' believe the underlying query engine is set up that way.
What you could do is provide a sumo card that users can edit on the fly, without making permanent changes to the card. They can alter the date grain by clicking on the date column header and choosing either option of week or month.
Aaron
MajorDomo @ Merit Medical
**Say "Thanks" by clicking the heart in the post that helped you.
**Please mark the post that solves your problem by clicking on "Accept as Solution"0 -
You could use a drill path to have the user click on the month they want to explore and have the underlying view aggregate at the week level.
Also, would having them use the "Graph By" option work for you?
“There is a superhero in all of us, we just need the courage to put on the cape.” -Superman0 -
thank you...I think I'll go with this option.
0
Categories
- All Categories
- 1.7K Product Ideas
- 1.7K Ideas Exchange
- 1.5K Connect
- 1.2K Connectors
- 295 Workbench
- 6 Cloud Amplifier
- 8 Federated
- 2.8K Transform
- 97 SQL DataFlows
- 608 Datasets
- 2.1K Magic ETL
- 3.8K Visualize
- 2.4K Charting
- 709 Beast Mode
- 49 App Studio
- 39 Variables
- 667 Automate
- 170 Apps
- 446 APIs & Domo Developer
- 44 Workflows
- 7 DomoAI
- 33 Predict
- 13 Jupyter Workspaces
- 20 R & Python Tiles
- 391 Distribute
- 111 Domo Everywhere
- 274 Scheduled Reports
- 6 Software Integrations
- 115 Manage
- 112 Governance & Security
- Domo Community Gallery
- 31 Product Releases
- 9 Domo University
- 5.3K Community Forums
- 40 Getting Started
- 30 Community Member Introductions
- 103 Community Announcements
- 4.8K Archive