Limit graph data in function of date filter selection

anmartin — Thu, 06 Feb 2020 09:02:11 GMT

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)

topic Limit graph data in function of date filter selection in App Development

Limit graph data in function of date filter selection