Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hello.
I have a database that has the sales of the stores by hour every day for the years 2012 and 2013.
How can i have in a chart a current sale date or a period with the previous sale date in the same weekday with set analysis.
For example i have the sales of the date 23/10/2013 which is wednesday how can i bring in a chart the sales of 24/10/2012
which is also wednesday. Also how can i compare the month and the week and the year to date in a chart by selection.
Thank you in advance.
Try this
Atual state => Sum(Sales)
Previous state => Sum({<Year={'$(=(Year - 1))'}>} Sales)
Marco i want by selecting the 23/10/2013 automatically to bring me the 24/10/2012 and the sales of that day in a chart.
I don't know if i can convert the date to 20131023 and 201201024 and subtract 345 days and compare the weekdays.
But what can i do when the selection is the month or the week.
Is any set analysis that automatically give me the result of the previous sales by selecting only the current date or the month or the month and the week ?
Ok!
Use the AddYears(DATE, -1)
Previous state => Sum({<DATE={'$(=AddYears(DATE, - 1))'}>} Sales)
If you attach a sample file, I can better understand what you need.