Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi All,
I'm trying to develop a set analysis expression where a user clicks on a specific week in a list box in date format, and then a text box automatically calculates a Week Over Week analysis based on the selected week vs the previous week.
Example : User clicks on 8/18/2014. A text box would show the percentage difference between the selected week and the previous week in regards to sales.
Is this possible? Is Set Analysis the best to use in this case?
yes it should be possible with set analysis
something like (for this week)
=sum({<date={">=$(=WeekStart(max(date)))<=$(=WeekEnd(max(date)))"}>} sales )
Take a look on the attached file.
In this case you will need to create a new dimension with the week.
Regards,
Gabriel
Thank You! I simply added a -1 to your expression and it worked perfectly! I really need to engage and understand Set Analysis more