Transfer value from one quarter to another without values moving when changing switchover dates

Hi Thierry,

what is the structure of your source metric ?

ps: I don’t think you need to have both FILTER AND SELECT. SELECT does the filter.

Hello,

The metric is a number metric with 4 dimensions and the source metric is the same with the same dimensions. I have tried to delete FILTER but the data is incorrect when I do so.

Thank you for your help !

My point:

• if you are doing this on actuals, then switchover shouldn’t matter
• if you are doing this on a forecast version, then you want the number to go away if in actuals it did not happen

Hi, we are doing it on forecast and we want the numbers that we moved from Q → Q+1 to stay in Q+1 when the switchover date changes to Q+2, do you see that possible?

Thanks!

of course !

what you lack is that your shift should be done on the Actuals version, not the forecast. that’s why I asked you the structure: one of this dimension is the version ?

[filter: 'Actuals & Dimensions (Datahub)'::Quarter.'Quarter -1']
[Select: 'Actuals & Dimensions (Datahub)'::Quarter-1]
[select:Versions.”Actuals”])))