MOM metrics

[abacon]

Hi @liya101

If I understand your requirement, then you can try the following:

1. Create a new “datetime” parameter “pEndMonthDate” and add an associated datepicker control “cEndMonthDate” which sets the relative date from which the filter will apply
2. Create a new “integer” parameter “pFilterMonthCount” and add an associated slider control
3. Create the Date Hider filter as follows:
   a. Relative dates filter type
   b. Period: Months
   c. Range: Last N Months
   d. Check the “Use Parameters” box
   e. Select the pFilterMonthCount parameter
   f. Set Dates relative to: Date and time from a parameter
   g. Select the pEndMonthDate parameter

The filter should look like this

This should then give you a configurable date for which to display bars for the previous N months, something like this:

Let me know if this helps and mark my reply as a solution if so.

Many Thanks,
Andrew