Forum Discussion

orana's avatar
orana
Helper I
4 years ago

Filter on visual

Hello,

 

Below is an example of my data set. I have a visual that shows "Sales This Year" for customers who use Mack based on their Delta (%). I use the page filter to vary the Delta (%) depending on what I'm interested in seeing (e.g.,>100%, <50%, etc.). 

 

I'm looking to see if there is a way to create another visual that allows me to use the above filter but shows if these same customers have purchased through distributor "other". For example, if I have the delta (%) filter = 50%, I would see the "sales this year" information in a bar chart for row 1. But in another chart, I would like to see that customer A also purchased $100 from the distributor "Other".

 

Currently, I have the visual set-up such that if I set the delta(%) to 50%, I will see row 1 in my bar chart, but the other visual will show me info from row 4

DistributorCustomerSales This YearSales Last YearDelta (%)Product 
MackA10050100%AA
OtherA1001000%BB
MackB2000200%AA
MackC10050100%AA
Need Help

2 Replies

  • parry2k's avatar
    parry2k
    Super User
    4 years ago

    orana it will be easier if you post some raw data and the measure you are using, and what the final expected output is?

     

    ✨ Follow us on LinkedIn and  to our YouTube channel

    I would ❤ Kudos if my solution helped. 👉 If you can spend time posting the question, you can also make effort to give Kudos to whoever helped to solve your problem. It is a token of appreciation!