topic Re: Shading bars in Combochart in App Development

Shading bars in Combochart

mallikarjunautr — Wed, 25 Sep 2024 03:21:38 GMT

As shown in the above chart, i have few bars in the graph. I need to shade the past 3 months with lines. can anyone help me how to do it,

Re: Shading bars in Combochart

MatheusC — Wed, 25 Sep 2024 14:56:54 GMT

Hi, @mallikarjunautr
Try it in your bar expression:

if(FieldMonthName>= max(total FieldMonthName,3),'color1','color2')

*remember to change the example fields to your real fields*

- Matheus

Re: Shading bars in Combochart

mallikarjunautr — Thu, 26 Sep 2024 07:41:11 GMT

Hi @MatheusC , thanks for your response

I tried this logic but I'm loosing Legends due to expression in color, I want to keep same color for all the months but need to differentiate with lines are any other shades

Re: Shading bars in Combochart

MatheusC — Thu, 26 Sep 2024 13:36:28 GMT

This is not possible natively.

Maybe you can look for an extension that gives you this, if it's really necessary.

- Matheus

Re: Shading bars in Combochart

mallikarjunautr — Fri, 27 Sep 2024 02:28:27 GMT

Hi @MatheusC , thank you. any idea which extension will provide this feature. we are using Vizlib

Re: Shading bars in Combochart

Kushal_Chawda — Fri, 27 Sep 2024 09:54:42 GMT

@mallikarjunautr As mentioned earlier it is not possible natively, instead you can colour those bars with different colour.

You can use the color by expression as below

Use below expression. Make sure that your MonthYear Field is Numeric format

if( floor(MonthYear) >= monthstart(addmonths(Today(),-3)) and
floor(MonthYear) < monthstart(Today()), red(),green())

You can change the colour accordingly

Re: Shading bars in Combochart

mallikarjunautr — Thu, 03 Oct 2024 06:39:30 GMT

Hi @Kushal_Chawda , thanks for your reply, by applying this expression I'm loosing legend, I want to keep legend.