Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi,
I would like to create a stacked bar chart with dynamic groups.
Currently I have created 4 expressions. I would like to load dynamically. Please help.
you can use Primary Add PrimaryPriority in dimension and
use below expression
Count ( {$<[TicketTypeId]={'1'}>}TicketNumber)
Thanks
BKC
Can you expand on what you mean by dynamic dimensions?
It appears you have four in play, two showing in the chart.
do you mean using a cyclic group ?
What I mean dynamic is, right now i have created 4 expressions like sev1, sev2, sev3, sev4 like below,
=Count ( {$<[TicketTypeId]={'1'}, PrimaryPriority={'sev1'}>}TicketNumber)
=Count ( {$<[TicketTypeId]={'1'}, PrimaryPriority={'sev2'}>}TicketNumber)
=Count ( {$<[TicketTypeId]={'1'}, PrimaryPriority={'sev3'}>}TicketNumber)
=Count ( {$<[TicketTypeId]={'1'}, PrimaryPriority={'sev4'}>}TicketNumber)
So i am getting 4 groups in stacked bar chart. Now Incase if one more severity gets added i may have to come back to the expression and add another. I would like to load theses stacked groups dynamically.
you can use Primary Add PrimaryPriority in dimension and
use below expression
Count ( {$<[TicketTypeId]={'1'}>}TicketNumber)
Thanks
BKC
find example
Try some thing like this
Dimensions: date and PrimaryPriority
Expression : Count ( {$<[TicketTypeId]={'1'}>}TicketNumber)
In presentation tab enable the 'stacked' option
Thanks Pradeep and balkumar. That really works. Now I am trying to show a line in the same chart to show the total no of tickets. But if i add one more expression am getting the total for all severity.
am trying to achieve something like this,
Please help.
in a Bar chart/Line chart/Combo chart, 2 dimensions with 2 expressions is not possible
Is there any other workaround to achieve my requirement?