Show the greatest value of a day for every week

Milton_Hernandez1977 · September 2023

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 · September 2023

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

MarkSnodgrass · September 2023

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

sbutterbrodt · September 2023

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 · September 2023

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 · September 2023

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

Answers