Create custom period over period

#1

hi to all,
i need to create a metric set that shows this measures of comparing periods

  1. invoices total this year (from 1/1/2020 to 30/11/2020)
  2. invoice total last year to the same day of today (exampe if today is 30/11/2020 i need to show invoice values from 1/1/2019 to 30/11/2019
  3. invoices this month (1/11/2020 - 30/11/2020)
  4. invoice this month last year (1/11/2019 -30/11/2019)

thank you

#2

@gianbattista.schieppati hi, it’s a matter of using multiple filters with offsets. For example:

  1. add a filter/view parameter from 1/1/2020 to 30/11/2020 and link it to first measure.

  2. add an offset backwards 1 year based on first measure.

  3. you’ll need to create a copy of the measure since you need to filter this differently. You can do this easily by using a calculated element, for example return $measure$; would just return a copy of the same measure. For more information:
    https://www.dundas.com/Support/learning/documentation/cleanse-consolidate-modify-data/transforms/common/calculated-element

  4. add a one year backward offset based on the measure mentioned in #3.

Regards,
Jay

#3

Thank you. i was trying to make it in metric set. Is it possible?