Can anyone help me to display the total showing on top of a bar chart in two lines?

[durgabhavani]

Hi All,

my only one expression in barchart contains two parts, one part showing the count, one  part showing sum. but it is lengthy on bar.

So can anyone help me to display the value on barchart in two lines?

Thanks,

Durga

[jonathandienst]

Not sure I understand. Do you mean the legend text is too lengthy, or the dimension text?

[ashwanin]

Use Chr (10) between your expressions. exp1  & Chr(10) & exp 2

[Kushal_Chawda]

try below expression

=dual(SUM({$<%_CDD_STAT_CDE5*={'Complete','Cancelled'}>} ACTV_DURATION)&' Days, '&COUNT({$<%_CDD_STAT_CDE5*={'Complete','Cancelled'}>} DISTINCT %_PRFL_CTXT_ID)&'Reviews',

\SUM({$<%_CDD_STAT_CDE5*={'Complete','Cancelled'}>} ACTV_DURATION)/ COUNT({$<%_CDD_STAT_CDE5*={'Complete','Cancelled'}>} DISTINCT %_PRFL_CTXT_ID))

[durgabhavani]

Hi Kush,

it is showing error in expression.

[jonathandienst]

The expression looks OK, except for the backslash which you should remove. Looks like a typo.

[MayilVahanan · Accepted solution]

Hi

Try like this

Expression1:

= DaysExpression

Check bar Checkbox and unCheck the Value on Data Points Checkbox

Expression2:

=DaysExpression & 'Days'& Chr(10) & ReviewExpression &'Reviews'

UnCheck bar Checkbox and Check the Value on Data Points Checkbox

Hope it helps

[durgabhavani]

Thanks for responses.

its working. when i keep two expressions in line by line in one expression.