Chart clustering by month

[Anonymous]

Hi Guys,

Is there any way to cluster the bar chart by month ? I want to make the jan 2015 & jan 2016 side by side.

Then, between jan 2016 & feb 2015, there should be gap as it is different month. Kindly help. Thanks.

[Anonymous]

!Hi Ahmad,

If you generate a field with MonthYear together and put it as dimension to your barchart then it will work (of course sorting by monthyear). Use the atteched file.

HIH

Elena

[gferran]

Hi Ahmad,

a simple way to do this is creating two measures:

- Sum({$<Year={2014}>}Value)

- Sum({$<Year={2015}>}Value)

with a unique dimension: month

I have used the Elena's file to apply the modifications.