Pie chart for previous week

[Anonymous]

Hi,

I have a requirement to create a pie chart showing the total user count according to the POD name week wise.

I have closing dates of the user count.

The week ending should be Friday and the total user count for the week from sat-Fri should be displayed in the chart.

It has to dynamically change next week.

please give solution for this.

[woshua5550]

Not sure but hope this could help you

if I misunderstood you plz let me know

[calexandru · Accepted solution]

Hi Dhivya,

This is far from the most elegant approach but you could you set analysis to solve your issue, something along the lines of:

Count(DISTINCT {$<DateField={">=$(=WeekStart(Today()-7))<=$(=Date(Weekstart(Today() - 7)+4))"}>}Users)

With regards,

Alex

[Anonymous]

Thank you...

It worked well:)

[Anonymous]

Thank you for  ur reply:)

But I wanted the data for the previous week to be loaded in the pie chart dynamically:)