Show the greatest value of a day for every week

Milton_Hernandez1977 · 2023-09-15T04:03:27+00:00

There was an error rendering this rich post.

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

Find more posts tagged with

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

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

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.

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))

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