1 of 1 people found this helpful
By creating a calculated field similar to the following and placing it on the filter shelf will allow you to get the desired outcome:
if window_min(sum(price))=window_max(sum(price)) then 'filter out' else 'keep' end
I hope this helps!
Thank you, that was very helpful but it was not exactly the solution to my problem. The real worksheet has a lot of complex data which I thought I was able to simplify correctly in my sample but I missed something. It could be that the same customer can and often does by different products and different prices.
When I applied your formula as a filter I still had a lot of data points where the price never changed during the time period but there were different prices for the same customer buying different products. I am not concerned about the dashboard showing these values, only when the price is different for the same customer and product.
When I changed your solution to compare the window_min(ATTR(price)) to the window max it looks like it solves my problem but I have more research to do tomorrow to see if only the correct data points are being filtered.
Thank you again,