Set Analysis with Max(Week)

[charlie03]

Hi,

I have a dataset with dates, from which i derive the year-week out of it via the data editor, with the following formula:

Weekname(date#(date(Date),'MM/DD/YYYY')) AS week

With this new field, I want to create a calculated field in the front end, depending on the selected week. 

So far, I have the following formula:

Sum({<week={"$(=Max(week))"}>} count_request)

The set expression does not work, as I get the following calculation (see attachment), due to the formatting.

any idea on how to change the formatting?

Thanks!

[Or]

Apply Date() to the result...

week={"$(=Date(Max(week)))"}

[charlie03]

Hi

Thanks, i had tried that already but still, it doesn't work 😕

[charlie03 · Accepted solution]

Hi,

I figured it out myself, with the following formula, by adding the weekname

Sum({<week={"$(=Weekname(Date(Max(week))))"}>} count_request)