Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hello,
I have a graph that is plotting data from a aggregation I have defined.
Currently the graphe shows all the data available in the source, no matter what the selections are.
However, I would like the data of the graph the be related to the week & year selected above, so that if the user choses weeknumber 3 and year 2020, the graph would show all the data UNTIL week number 3 of 2020, and not the data after.
What do I need to change in my formula to take the week & year concatenation in my selection ?
Attached is how my graph looks like currently and below is my data formula :
sum({<[DimDate.WeekNumberOfYear]=,[DimDate.PublicationYear]=>}
aggr(
((sum({<[DimDate.WeekNumberOfYear]=,[DimDate.PublicationYear]=>}[#Measure1] + [#Measure2] - [#Measure3])
+
sum({<[DimDate.WeekNumberOfYear]=,[DimDate.PublicationYear]=>} [#Measure4]))
)
,[DimTable1.Column1],Column1,Column2,Column3,[DimTable1.Column2],Column4,Column5,[DimTable2.Column1],[DimDate.WeekNumberOfYear],[DimDate.PublicationYear],Column6
)
)/count({<[DimTable3.Column1] -= {1},[DimDate.WeekNumberOfYear]=,[DimDate.PublicationYear]=>}Distinct Column6)