Forum Discussion
Solved
Finding repeated values over consecutive dates
I hope I can describe this correctly. I am building a report, and I need to be able to create a column or measure that essentially says "Alert" or "Okay" if a certain condition is met. I ha...
Thank you so much - this works, but too well.
We have been selling items for 90 days. Unfortunately, the data we download is done in 365 day groupings. As a result, we have 275 days of items that are 0 sales, so every item comes up with an alert.
I thought that a visual level filter might fix it, but I'm guessing that due to the index and group columns, we are able to calculate past the last 90 days.
Is there a way to limit my view to 90 days since a visual level filter isn't cutting it?
(Also - I need to reiterate - I'm VERY grateful for your help and patience).