-
1. Re: Different colours for Bar chart ,same dimension based on order
Mavis LiuJun 19, 2018 1:26 AM (in response to keerthana kumar)
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
-
2. Re: Different colours for Bar chart ,same dimension based on order
keerthana kumar Jun 19, 2018 3:45 AM (in response to Mavis Liu)Thanks Mavis,
That was quick easy fix . Thank you so much for the solution
Can please let me know if i can change this into clustered bar graph
.
-
3. Re: Different colours for Bar chart ,same dimension based on order
Mavis LiuJun 19, 2018 4:01 AM (in response to keerthana kumar)
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
-
4. Re: Different colours for Bar chart ,same dimension based on order
keerthana kumar Jun 19, 2018 10:10 PM (in response to Mavis Liu)Something like the 2nd graph, without space between the graph.
1 Easy Trick to get Clustered Bar Charts | VizPainter
I was not getting it right because of different LOAD DATE for a particular MONTH.
-
5. Re: Different colours for Bar chart ,same dimension based on order
Mavis LiuJun 20, 2018 12:00 AM (in response to keerthana kumar)
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