I have a viz where I would like to show the mark values for the most recent data point. In my example, the view is by weeks. I think my problem lies in the fact that I have multiple measure values that I would like to display the mark value.
Ive tried equations such as:
If week = datepart('week',today()) then [delta] else NULL end
I get the error message regarding not being able to compare aggregate and non-aggregate data.
Ive tried using parameters but i cant get that to work either.