topic Re: Set Analysis with Max(Week) in App Development

Set Analysis with Max(Week)

charlie03 — Mon, 06 Mar 2023 13:02:36 GMT

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 — Mon, 06 Mar 2023 13:42:41 GMT

Apply Date() to the result...

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

charlie03 — Mon, 06 Mar 2023 15:33:37 GMT

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

charlie03 — Tue, 07 Mar 2023 08:42:55 GMT

Hi,

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

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