Column Headers To display Year/Month/Quarter they point to when used with Previous Year or Period offset Dataview Functions
Scenario
Time entity is used on column axis and multiple Cube blocks are added to dataview. Some of them refer to previous or future periods. Often, dataview Functions are used to refer to other time periods for a block.
Problem
Headers of Blocks with offset Function showing Current time period selected on the screen, rather than the period they are pointed to through a Function.
Idea
To dynamically display the time period the Cube blocks point to, rather than current time period.
Perspective benefits
- No need of PY, PPY, PPPY, PP or other similar abbreviations on the report headers.
- Better end user experience reading dataviews in Board.
- Improved developer experience as period block relates to will be displayed on the column header rather than in the dataview only.
Other solutions
- Label has been placed on top of the header but the dataview configuration with slide bottom bar is preventing that.
- Having a trigger procedure with apply selection on the layout is not updating the column header.
Current State
Suggested State (Photoshopped)
