I have a metric which is by Year Dimension, and I have another metric which is by Month in the same table, i would like to have a year selection on the Page that will filter both metrics at the same time, does anyone have a solution or workaround?
Solved
Year Selection
+1- Apprentice Author
- 1 reply
Best answer by Chahat
Hi @fabrice,
I think, the default native functionality might not work here as expected.
As a work-around, here’s the solution:
- Create a metric with datatype Year and No dimensionality | ‘Select Year’
- Create a boolean metric with dimensionality: Year
- Create a boolean metric with dimensionality: Month
- Add above 2 boolean metrics in the same table which already has your 2 metrics
- Apply the filter in the Table to show the months/year based on selection
Lastly, publish the input Year selection metric on the dashboard .
Hope it helps!
+14- Master Helper
- 83 replies
- Answer
Hi @fabrice,
I think, the default native functionality might not work here as expected.
As a work-around, here’s the solution:
- Create a metric with datatype Year and No dimensionality | ‘Select Year’
- Create a boolean metric with dimensionality: Year
- Create a boolean metric with dimensionality: Month
- Add above 2 boolean metrics in the same table which already has your 2 metrics
- Apply the filter in the Table to show the months/year based on selection
Lastly, publish the input Year selection metric on the dashboard .
Hope it helps!
Enter your E-mail address. We'll send you an e-mail with instructions to reset your password.