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:Monthly
Weekly
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.” -Superman
______________________________________________________________________________________________0
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 -
thank you...I think I'll go with this option.
0
Categories
- 7.7K All Categories
- 2 Connect
- 918 Connectors
- 244 Workbench
- 477 Transform
- 1.8K Magic ETL
- 60 SQL DataFlows
- 446 Datasets
- 35 Visualize
- 198 Beast Mode
- 2K Charting
- 8 Variables
- 1 Automate
- 348 APIs & Domo Developer
- 82 Apps
- Workflows
- 14 Predict
- 3 Jupyter Workspaces
- 11 R & Python Tiles
- 241 Distribute
- 59 Domo Everywhere
- 241 Scheduled Reports
- 15 Manage
- 36 Governance & Security
- 26 Product Ideas
- 1.1K Ideas Exchange
- Community Forums
- 15 Getting Started
- 1 Community Member Introductions
- 49 Community News
- 18 Event Recordings
- 579 日本支部