custom axes on a bar chart

[ali_hijazi]

hello

working on a bar chart with stacked as style

the expression is showing by month the percentage of closed and open tickets

so far so good

but the Y-axis is showing the %

what I want to show on the Y-axis is the total number of tickets

my dimensions is Month

I have 2 expressions

count({<condition of closed>} ticketId )/count(ticketID)

count({<condition of opened>} ticketID)/count(ticketID)

please advise

[Anonymous]

try adding another expression cound(ticketID) to the list of expressions and promote it to the top. in axes tab, you may want to set count(ticketID) as axis Position to Left (Bottom) and the other two expressions with axis Position to Right (Top) and you could decide if you want to hide the axis on right.

[ali_hijazi]

but I don't want to show the bar of the total per month

[Anonymous]

turn that to invisible. there is a check mark below the Comment field.

[SunilChauhan]

go to chart properties--->number ----> select express one by one and untick  show in % at the bottom

hope this helps

[ChiragPradhan]

Hi Ali

I have attached a sample I created. The other option is to use a combo chart and display the percentages on a line chart, make the line invisible and display the totals on the Bar chart.

Hope it helps !

Regards

[ali_hijazi]

this is very helpful

but can we simply plot the percentages inside the other bars?

[kji · Accepted solution]

like this?

[ChiragPradhan]

Dual is the answer !