Hello,
I am building an app that reports on data with varying time lengths. So a user may want to see their boards either quarterly, half -yearly or yearly.
Quarter, half year and yearly are all dimensions within our Pigment Datahub, and they have defined relationships between them i.e. Month → Quarter → Half year → Year are all connected to each other.
Currently all three dimensions are used as selectors on my boards:
But I want a user to be able to land on a “Time Period Selector” board and:
- Choose either the Quarterly, Half Yearly or Yearly reporting frequency
- The chosen dimension (conditional on what the user has selected) is then the only available selector throughout all the other boards in the report, rather than having all three dimensions available as selectors
I have mocked up a “Period Selector” board to show what I am looking for. It uses a dummy dimension called “Time View” which has the list items Quarterly, Half-Yearly and Annually, it is not currently connected to the Quarterly, Half Yearly or Yearly dimensions as I can’t see how:
If quarterly was selected then the board would then only show Quarterly as a selector, rather than all three (Quarterly, Half Yearly or Yearly).
Is this possible to do? I have only ever seen selectors on boards that reference dimension items, rather than dimensions themselves.
Thank you
