I have a stacked bar chart with two dimensions. First, week formatted as an integer YYYYWW and then a category as string. I want to show only the latest week in the loaded data. (Not last week since the data from last week might not be loaded yet.)
How would I do that?
Use Set Analysis in your chart expression/ measure, for example =Sum({<WeekYear = {"$(=Max(WeekYear ))"}>} Sales)
Use Set Analysis in your chart expression/ measure, for example =Sum({<WeekYear = {"$(=Max(WeekYear ))"}>} Sales)
Perfect!