Skip to main content

 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? 

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
Select year metric
Boolean metric for Year
boolean metric for month



 

Pivot view for table: Hide the 2 metrics

 

 

Apply the filter in the table

 

 

Lastly, publish the input Year selection metric on the dashboard .

 

Example: If FY 23 is selected, it shows only those months and year of FY 2023 in the table.


Hope it helps!

Ask your question here!

Terms & ConditionsCookie settingsAccessibility statement