Can you change axis variables with a filter?

hamza_123
hamza_123 Contributor
in Charting

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

  • Godiepi
    Godiepi Coach
    Answer ✓

    @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'

Answers

  • TDaily
    TDaily Contributor

    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
  • Godiepi
    Godiepi Coach
    Answer ✓

    @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'
  • hamza_123
    hamza_123 Contributor

    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

  • Godiepi
    Godiepi Coach

    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'
  • hamza_123
    hamza_123 Contributor

    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

This discussion has been closed.

Categories