I have an Operations Dashboard that shows crime data. I want to be able to compare one time frame to the previous time frame based on a filter condition selected by the user.
For example, if the user selects "One Week" as the time frame they want to see the indicator will show if crime is up or down from the previous week. If they choose "One Month" it'll show compared to the previous month.... etc.
I'm trying to figure out how I could set up my conditional formatting to have this variable time frame comparison.
Has anyone else worked on something similar?