how to create a stack bar chart + with value on each of the stack.

[jim_chan]

Hi guys,

i want to create a stack bar chart that have "High, Medium. Low' and show value in each of the bar. As per this screenshot,

I have a expression as below, but it didnt work. I have attached my example as well.

count({<gr_impact={'High'}>} gr_impact) +

count({<gr_impact={'Medium'}>} gr_impact)+

count({<gr_impact={'Low'}>} gr_impact)

Rgds,

Jim

[Anil_Babu_Samineni]

How your dimension? Meantime, can I know expected output

[jim_chan]

in the sample i have attached, i used "risk_no" as my dimension. expected result as the image i have attached.

[adamdavi3s]

Hi Jim,

I am not clear on what output you expect here...

Each risk appears to only have one gr_impact assigned to it, so having risk as the x axis is never going to give you a stacked chart.

I've amended your example slightly, is this what you wanted?

Please remember to mark this as helpful or the correct answer if I have helped you or answered your question.

[jim_chan]

Hello Adam,

You're right. My mistake. So, how can I display numbers in each of the stack?

Rgds

Jim

[adamdavi3s · Accepted solution]

Hi Jim,

My apologies I missed that part of the requirement...

On 'Presentation' tab, enable the ;Values on Data Points' option and that should work for you:

Please remember to mark this as helpful or the correct answer if I have helped you or answered your question.

[jim_chan]

thank you