Show the greatest value of a day for every week

Milton_Hernandez1977

Hey community .

I need to show a graph(week by week) showing only the day with the greatest value of sold items for each week,

I have been trying partitions, but it seems it's not getting the correct data

MichelleH

@Milton_Hernandez1977 Can you please share what you've tried so far?

MarkSnodgrass

I would look at use case #3 in this article as a way to solve your problem

https://domo-support.domo.com/s/article/4408174643607?language=en_US

sbutterbrodt

If you want this as a fixed calculation within the ETL, you could also consider the Rank & Window tile and then using this field for filtering in the card.

https://domo-support.domo.com/s/article/360044876094?language=en_US#3.

GrantSmith

Also, how is your data structured? Do you have your data aggregated for each day or is it each transaction?

You can get the week max by doing something like:

MAX(SUM(random_number)) OVER (PARTITION BY dt - DAYOFWEEK(dt))

Milton_Hernandez1977

hey @MichelleH

I have tried this

The only missing part it's that for each week I only want to show the day with the greatest value

thanks in advanced