Skip to main content
Announcements
MAINTENANCE ALERT: Search experience upgrade - Feb 6: 4 - 8:30AM CET. Downtime expected. READ MORE
cancel
Showing results for 
Search instead for 
Did you mean: 
awp2020
Contributor III
Contributor III

Display a curve of a rolling12-month

Hello,

I have a table which contains a period field in the form (day / month / year) where the period is always brought back to the first of the month, like this: 01/02/2020 for the first February 2020.
And digital data fields.


I would like to display the value of each month (12 months rolling ) on a graph of the curve when I select a given period.
Can someone help me?
Thank you

1 Reply
awp2020
Contributor III
Contributor III
Author

I found !

 

avg({1<PERIODE = {">=$(=MonthStart(Max(PERIODE), -11))<=$(=MonthEnd(Max(PERIODE)))"}>}VALUE)

With PERIODE in Dimension and  this in measure expression : avg({1<PERIODE = {">=$(=MonthStart(Max(PERIODE), -11))<=$(=MonthEnd(Max(PERIODE)))"}>}VALUE)