Summarize data for the Week

[Anonymous]

Hi All,

I have a situation where I have to represent data date wise ( Last day of the week ) and I have some count against those days but when I'm using my flag for the Last_day_of_the_week I want my data to get summarized and show the complete week data on the last day of the week.

Currently when I use my filter condition IS_LAST_DAY_OF_THE_WEEK it gives me data for the last days only. I want to have the complete data for that week summarized on the last day.

Any help how to process this?

P.S: Last day of the week in my dataset is Saturday.

[Rambo92 · Accepted solution]

I didn't notice saturday is your weekend.

Add this calculated column.

This gives the Saturday Weekend Dates. Insert that column in matrix and the value column.

Guess this one works. Check once

[Anonymous]

Thanks for the help. 

It worked !!!

[Rambo92]

Hi Himanshu,

Go to Transform Data, And Add column as below from date and select weekend date in new column. Then you can select.

Then try adding the end of week date in the matrix and try. It will show desired output as below.

Let me know if this works.

[Anonymous]

Just one other help required here.

Is there a way I can create WoW% using this?

I tried by using the below formula but it is not working: