Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Heyy,
I want to create the date buckets, I have used the class function for that but i am facing some problem. I have explain it in the document attached.
Please help me its urgent..
Thanx in Advance.
Regards,
Nilesh Gangurde
Hi Nilesh,
I don't think I'd use a calculated dimension like you have done. Instead, just have Customer as the dimension and use a set analysis expression to decide which sales to sum. I have created 2 new variables (vDateFrom and vDateTo) which give the range of your selected date plus the width. Then, the expression is:
=Sum({<Date={">$(vDateFrom)"},Date={"<$(vDateTo)"}>} Sales)
See attached - NEW CHART
Hope this helps,
Jason