topic Re: Custom Coloring 'Others' category in a vizlib combo chart. in App Development

Custom Coloring 'Others' category in a vizlib combo chart.

premacharya0903 — Thu, 09 Jan 2025 10:25:38 GMT

I have a combo bar chart with 3 measures (2 bar , 1 line) and 1 dimension . Measures are color coded - lets say green for 1st bar and red for 2nd bar.

The chart would display top 5 dimensions and rest all clubbed into others. By default others are colored as grey .

Is there any workaround to color code both the bars for Others.It should also be color coded same as above for the measures.(green for 1st bar and red for 2nd bar. )

The others would be dynamic based on filter selection , hence no static or hard coding 'others' category in script.

#Bar

Re: Custom Coloring 'Others' category in a vizlib combo chart.

JandreKillianRIC — Tue, 14 Jan 2025 13:22:08 GMT

Hi @premacharya0903

I tried doing this using css. But in the end I cant get this to work. However, You can get this to work by applying this in a theme. If you head over to https://sensetheme.com/ you can create a custom theme. There is a section for the "otherColor".

Regards

Re: Custom Coloring 'Others' category in a vizlib combo chart.

JandreKillianRIC — Tue, 14 Jan 2025 13:34:03 GMT

Hi @premacharya0903

Another solution might be to use an Aggr and Rank as Dimension.

Then you can use this for the colors as well.

Dimension

=IF(

Aggr(

Rank(Sum(Value)), [Year-Month])<=3,

[Year-Month],

'New Others Field')

Color Expression

=IF(

Aggr(

Rank(Sum(Value)), [Year-Month])<=3,

Green(),

Blue())

Might need a bit more work to get multiple colors but this is the idea.

Regards

Re: Custom Coloring 'Others' category in a vizlib combo chart.

premacharya0903 — Thu, 23 Jan 2025 10:56:38 GMT

Hi @JandreKillianRIC ,

Thanks for your suggestion.

Tried CSS, it worked a single bar , but since i had 2 measures same color code was applied to both the measures .

Explored using chart scripting , i was able to update the 'others' as an exclusive dimension value , however customization was limited (or maybe i am still to explore ) .

Unfortunately had to rely back on using aggr+rank for dimension , since this was a vizlib chart i am lucky to have the option to color the measure individually .

However ,with the calculated dimension , dynamic viztips is out of question for now (but that is a problem for another day ) .