running average per day, with a twist

[Deep750]

Hi,
I have a report, with DMR-package as a source.
I'm supposed to make a running average but only display the running average-value for saturdays in the report. Any suggestions on how to do this?

Example
I have this table, where the first row is the measure, the second is the rolling average. And I need to only display the rolling average which are bold, which are saturdays.

Time	20190101	20190102	20190103	20190104	20190105	20190106	20190107	20190108	20190109	20190110	20190111	20190112
Measure	164 330	163 117	162 798	164 253	165 877	165 647	164 967	165 575	165 798	166 776	166 849	167 798
Running average	164 330	163 723,5	163 415	163 624,5	164 075	164 337	164 427	164 570,5	164 706,9	164 913,8	165 089,7	165 315,4

I have made a time series with only saturdays

Code Select Expand

generate(
               [Dimensional view - ATP7].[Time].[By Calendar Week].[Week],
               item(
                              descendants(
                                             currentMember([Dimensional view - ATP7].[Time].[By Calendar Week]),
                                             [Dimensional view - ATP7].[Time].[By Calendar Week].[Day]
                              ),
                              5)
)

But how to make the running average, based in each day, but only display the saturdays?
This doesn't display any data, suspect it to be DMR-issue. But even if it had worked, i assume the rolling average would have been for the saturdays, not each day ?

Code Select Expand

average(
         [Dimensional view - ATP7].[ATP7].[IsAvailable for Salesorg]
         within set
         periodsToDate(
                         [Dimensional view - ATP7].[Time].[By Fiscal Year/Period 4-4-5].[Year],
                         currentMember(
                                         [Dimensional view - ATP7].[Time].[By Fiscal Year/Period 4-4-5]
                         )
         )
)


Would appreciate any input on how to solve this. If it is easier using a relational source, please give examples on how to do that as well.

/Deep

[CognosPaul]

Can you add a day of week property to the day level?

[Deep750]

Hi Paul,
Yes, I can add day of week property. Any suggestions?

[CognosPaul]

add the property to the node (in the properties list there's a row called properties), and use a render variable on the text item inside the cell.