Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
I have a bubble chart for top customers with Profit and Sales as X & Y axis and Profit% as size of bubble.
I want a slider to filter customers with sales value e.g. customer with sales more than 10,000 only.
I tried by creating a variable as vTest and defined it as 1. Then I changed the measure 'Sales ' as sum(Sales)*vTest but it is not working properly when I am sliding the slider. The sales values are changing from thousand to millions and customers are not not reducing as per their sales
I am using qsVariable extension. Please let me know how to make this correct
Thanks
Try to change ur measure as follow:
sum({<Customer={"=sum({<Customer>}Sales)>'$(vTest)'"}>}Sales)
Try to change ur measure as follow:
sum({<Customer={"=sum({<Customer>}Sales)>'$(vTest)'"}>}Sales)