Analysis Workspace - Dynamic "Previous Date Range"
Description - (I am sure this has been asked many times, so I just wanted to revive the idea)
We need an automatic "Previous Period" date range component that automatically creates a dynamic lookback window relative to the selected date range on the panel.
Why is this feature important to you
It is basically not practicable to have fixed previous date range components in place that only work until one changes the panel date range.
Example
- Freeform table using the last 7 full days (Panel date range) vs the previous 7 days (custom date range in the workspace project).
- Now, someone decides to change the date range on the panel to "last 30 full days"
- Result
- the custom date range still displays only 7 days, the rest is 0
- the comparability between panel date range and freeform table is completely useless
- this becomes even more obvious / erroneous if you are applying a summary change visualization on the two columns, not taking the same number of data points into consideration
How would you like the feature to work
- The "Previous Period" date range automatically calculates the previous x days / weeks / months before the currently selected date range, based upon that value.
- Should I change the panel date range, this will automatically update the data that has been filtered by this date range e.g., in a "Summary change" visualization
Current Behaviour
- once you change the panel date range, your data is messed up, becoming unusable
- this is extremely annoying for all levels of analytics consultants. I don't know how many times I have explained this to clients or had the same issues myself
- other analytics tools like Looker Studio do not seem to have that problem, see https://support.google.com/looker-studio/answer/9272806?hl=en
For an analytics solution as mature as Analysis Workspace, this should be a standard feature.
Related Conversations
