Show latest extract per period

[joshua1990]

Hi all!

I have a simple bar visual that has on rows

• Year
• Month
• Week
• Day
• Time

It shows the sum of our sales for the specific period.

Now I would like to allow the viewers to expand those levels but with 1 limitation.

I would like to display just the last extract for the specific period.

So if I aggretate from Time to Day, I would like to see just the last extract for that date, not the sum of all of them.

If I aggegrate again from Day to Week, I would like to display the Sunday extract with the last extract for that day.

How would you do that ?

[joshua1990]

Any ideas?