Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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
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
Not sure I understand. Do you mean the legend text is too lengthy, or the dimension text?
Use Chr (10) between your expressions. exp1 & Chr(10) & exp 2
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))
Hi Kush,
it is showing error in expression.
The expression looks OK, except for the backslash which you should remove. Looks like a typo.
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
Thanks for responses.
its working. when i keep two expressions in line by line in one expression.