Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hello,
Can anyone spell some ideas on creating the chart attached?
The dates are weekly dates and each bar represents a dimension based on status
Any ideas would be a huge help
Thanks
Kalyan
Kalyan,
There is attribute expression bar offset, this is what you need.
Regards,
Michael
Michael,
The Bar Offset in the expression would help me acheive the waterfall kind of chart, however i need to have a dimension that basically gives first bar -total as of first day of the week, second bar - total of newly created in that week , and so on...and my ending bar would be what we ended up with as of last day of that week.
Hope this is clear
thanks
Kalyan
For me it looks like a bar chart without dimensions, nine expressions.
1. Aggregation for the 1st day of the week. Use set analysis, e.g. sum({<Date={"$(=date(weekstart(Date)))"}>} Amount)
2. Aggregation for the newly cretae within the week, probably using set analysis of if(InWeek(Date))
...
9. Aggreagtion for the last day of the week, similar to the 1st one.
After that, apply offsets.
I hope it well help.
Regards,
Michael
Hi Michael,
That's a very good idea let me try to implement that and see how it works.
Thanks
Kalyan