Hi Keerthana,

I'm not sure if this is what you're looking for, but this is what I have done:

1) I created an adhoc calculation and created an index():

2) I made sure that this calculation was running in the right scope and direction so I ticked on Data type and Load Date:

Right click on this field and turn it into diiscrete. Then drag this into colour on the marks card:

So now the order of the bars can be coloured. If you want Data type to be a secondary colour, drag that field into detail and click on the detail button right next to the field and change it to colour:

So now you can colour it based on a unique combination of order and data type:

Thanks and please see attached workbook.

Mavis

Hi Keerthana,

Apologies but it might be a terminology or naming difference, but what is a clustered chart? Is this a stacked bar chart?

To do this remove date data type from the columns and change the index calculation to this:

Then you get this view:

You sill have multiple bars at the bottom because it's split by load date. Please see attached.

Thanks,

Mavis

HI Keerthana,

I believe the example in the url is different to yours. In his example, his colour is customers and it's also on the columns shelf:

Whereas with yours, you have both Data Type and the index based on colour, and load date on the columns shelf.

So I believe that you cannot get quite the same view as the example because your situation is different to the example.

The best you can do is add an index based on data type:

Thanks,

Mavis