0 Replies Latest reply on Nov 8, 2018 10:59 AM by susheela.hegde

    Averages Calculation with the Parameter Selection along the Date Aggregation

    susheela.hegde

      Hi All,

       

      In Average Calc Work sheet,

      I am trying to calculate Averages for 3 months, 6 months, 12 months etc. as I change my Parameter respectively( here it is period Parameter) . so, When user clicks Time Period Selection to any month, and Average Selection should be related to it.

       

      For example, If User Selects Month May and Period Parameter 3 Months,  Average should be based on past 3 months for May. If user selects Parameter 6 months then Average should be based on past 6 months of May.

      I can show this without any filters but with the time Selection filter i cannot show past average filters.

       

      Can anyone help me with this?