Can you change axis variables with a filter?

Reply
Highlighted
Orange Belt

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. 


Accepted Solutions
Black Belt

Re: Can you change axis variables with a filter?

@hamza_123 

 

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'

View solution in original post


All Replies
Orange Belt

Re: Can you change axis variables with a filter?

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
TDaily
Black Belt

Re: Can you change axis variables with a filter?

@hamza_123 

 

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'

View solution in original post

Orange Belt

Re: Can you change axis variables with a filter?

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

Black Belt

Re: Can you change axis variables with a filter?

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

Screen Shot 11-07-19 at 11.32 AM.PNG

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'
Orange Belt

Re: Can you change axis variables with a filter?

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

Announcements
Check out these great solution videos! The new iSolveditWithDomoboard is live, share yours and earn higher rankings in Dojo click here!