3 Replies Latest reply on Dec 7, 2018 3:20 PM by Mavis Liu

    Filter Functionality in Dashboard?

    peeyush.pathak

      I have a dashboard with 5 sheets. I have a Quarter filter(coming from sql code) which has values as All,Q1,Q2,Q3 and Q4 and this filter applies to all the 5 Sheets.My requirement is as below-

      Month
      Quarter FilterAll value selection in Quarter filter
      Jan

      X is a measure

      Q1-Value displayed should be 'X/3'

      Value displayed should be 'X/3'
      FebQ1-Value displayed should be '2X/3'Value displayed should be '2X/3'
      MarQ1-Value displayed should be '3X/3', which would be XValue displayed should be '3X/3', which would be X
      AprQ2-Value displayed should be 'X/3'Value displayed should be '3X/3', which would be X
      MayQ2-Value displayed should be '2X/3'Value displayed should be '3X/3', which would be X

      and so on for another quarter and rest of the month. I can achieve this by parameter and then calculated field, but Quarter filter is applicable to all the 5 sheets and through parameter I dont think it can be achieved. Any suggestion please