Ideas on creating Offset Bar chart

[nadkalyan]

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

[Anonymous]

Kalyan,

There is attribute expression bar offset, this is what you need.

Regards,

Michael

[nadkalyan]

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

[Anonymous]

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

[nadkalyan]

Hi Michael,

That's a very good idea let me try to implement that and see how it works.

Thanks

Kalyan