Can you change axis variables with a filter?
Can I make a bar chart which changes axis values based on a filter.
For instance I have a filter with two values: Product and Salesperson.
I want to show a bar chart which shows Revenue per Product, or Revenue per Sales Person, depending on what I choose in the filter.
(P.S I do not want a secondary axis). I want to see either Product or Salesperson on the X-Axis, and Revenue on the Y-axis.
Best Answer
-
in theory you can do it but it will involved some data manipulation.
run a flow that aggregates revenue by product and call the column holding the product "X-axis"
then run another table aggregation of revenue by Sales Person and call the column holding the Sales person "X-Axis"
append the 2 aggregations and create and output
building the card use the "X-axis" column that holds both Product and Sales Person as you card x-axis and as a quick filter setting by defult only 1 of the 2 (otherwise you'll have duplicate revenue) ..... then with the quick filter you'll able to toggle between product and sales person
I hope this makes sense
Domo Arigato!
**Say 'Thanks' by clicking the thumbs up in the post that helped you.
**Please mark the post that solves your problem as 'Accepted Solution'1
Answers
-
This is not something can be done right now but this is a great idea I have been wanting for a while. I thought this was on the idea exchange but could not find it. You should add it and I will vote for it and get others to vote for it as well.
Thank you
TDaily1 -
in theory you can do it but it will involved some data manipulation.
run a flow that aggregates revenue by product and call the column holding the product "X-axis"
then run another table aggregation of revenue by Sales Person and call the column holding the Sales person "X-Axis"
append the 2 aggregations and create and output
building the card use the "X-axis" column that holds both Product and Sales Person as you card x-axis and as a quick filter setting by defult only 1 of the 2 (otherwise you'll have duplicate revenue) ..... then with the quick filter you'll able to toggle between product and sales person
I hope this makes sense
Domo Arigato!
**Say 'Thanks' by clicking the thumbs up in the post that helped you.
**Please mark the post that solves your problem as 'Accepted Solution'1 -
That's a great way to go about it. The only problem comes in the default filter. If I set a filter at the card level, then changing the page level filter does not change the values in the card (or brings them to 0), since at the card level only one value is selected.
But I like the idea anyways. Thanks
0 -
add the "X-axis" column as a quick filter but on edit mode leave only 1 selected but on the quick filter area to the right of the chart not on the filter area (left upper corner)
Update: here an example image
Domo Arigato!
**Say 'Thanks' by clicking the thumbs up in the post that helped you.
**Please mark the post that solves your problem as 'Accepted Solution'0 -
I've also shared the idea on the Ideas Exchange forum. Please like the post.
https://dojo.domo.com/t5/Ideas-Exchange/Change-values-on-x-axis-of-Charts-Cards/idi-p/45241#M7577
1
Categories
- All Categories
- 1.7K Product Ideas
- 1.7K Ideas Exchange
- 1.5K Connect
- 1.2K Connectors
- 292 Workbench
- 4 Cloud Amplifier
- 8 Federated
- 2.8K Transform
- 95 SQL DataFlows
- 602 Datasets
- 2.1K Magic ETL
- 3.7K Visualize
- 2.4K Charting
- 695 Beast Mode
- 43 App Studio
- 39 Variables
- 658 Automate
- 170 Apps
- 441 APIs & Domo Developer
- 42 Workflows
- 5 DomoAI
- 32 Predict
- 12 Jupyter Workspaces
- 20 R & Python Tiles
- 386 Distribute
- 111 Domo Everywhere
- 269 Scheduled Reports
- 6 Software Integrations
- 113 Manage
- 110 Governance & Security
- 8 Domo University
- 30 Product Releases
- Community Forums
- 39 Getting Started
- 29 Community Member Introductions
- 98 Community Announcements
- Domo Community Gallery
- 4.8K Archive