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?
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 -
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?
0 -
thank you...I think I'll go with this option.
0
Categories
- All Categories
- 2K Product Ideas
- 2K Ideas Exchange
- 1.6K Connect
- 1.3K Connectors
- 311 Workbench
- 6 Cloud Amplifier
- 9 Federated
- 3.8K Transform
- 659 Datasets
- 116 SQL DataFlows
- 2.2K Magic ETL
- 816 Beast Mode
- 3.3K Visualize
- 2.5K Charting
- 82 App Studio
- 45 Variables
- 776 Automate
- 190 Apps
- 481 APIs & Domo Developer
- 82 Workflows
- 23 Code Engine
- 41 AI and Machine Learning
- 20 AI Chat
- 1 AI Playground
- 2 AI Projects and Models
- 18 Jupyter Workspaces
- 411 Distribute
- 120 Domo Everywhere
- 280 Scheduled Reports
- 11 Software Integrations
- 144 Manage
- 140 Governance & Security
- 8 Domo Community Gallery
- 48 Product Releases
- 12 Domo University
- 5.4K Community Forums
- 41 Getting Started
- 31 Community Member Introductions
- 115 Community Announcements
- 4.8K Archive