Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi,
after using dollar sign in number tab and fixing decimals as well as fixing axis i am getting dollar sign as well as point values
on both mouse over values as well as on y axis
As per requirement i need to show dollar sign after each step on y axis and should not have any decimals
but on mouse over value should be up to 2 decimals and should not have dollar
sign.
i need to plot line chart also in this manner.But in line chart it is showing values for both expression .
thanks
Expression->show data points(Enable check box)
PLEASE ENABLE CHECK BOX FOR "VALUES ON DATA POINT"
Hi,
Try to change your expression like the below
before the Avg expression add num format. num(YourExpression, '$#,##0')
=if(isnull(Avg({<INDICATOR_NAME={'% of Non-Bank Private Debt to Nominal GDP'},FRQ_TYPE={'A'}>}INDICATOR_VALUE)) or
num(Avg({<INDICATOR_NAME={'% of Non-Bank Private Debt to Nominal GDP'},FRQ_TYPE={'A'}>}INDICATOR_VALUE),'$#,##0')=0,
num(Avg({<INDICATOR_NAME={'% of Non-Bank Private Debt to Nominal GDP'},FRQ_TYPE={'Q'},QUARTER={'Q4'}>}INDICATOR_VALUE),'$#,##0'),
num(Avg({<INDICATOR_NAME={'% of Non-Bank Private Debt to Nominal GDP'},FRQ_TYPE={'A'},QUARTER={'Q4'}>}INDICATOR_VALUE),'$#,##0')
)
I think, one expression is fine for this chart.
And, in the Number's Tab -> Set Expression Default.
And, Axis Tab -> Static Min = 0
Static Max=250
Static Step = 50
you can change the value based on your requirement.
find the attached for further reference.