Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi All,
I am trying to use percentage calculation in my visualization as a dimension.
((Curr_Value-Pre_Value)/Prev_Value)*100
How can I do it?
Thanks
I tried using
aggr((($(vDiff_value)/$(Prev_Value))*100),Percentage_change) as dimension but it shows no data generated for any of the measure. But If I check null values, it shows 143 as null value and I am trying to implement it in bar chart.
Do it in the script if it work?
This may work if you have Curr_Value and Prev_Value in your table already...
((Curr_Value-Pre_Value)/Prev_Value)*100 as Calculated_Dim
Use Calculated_Dim in frontend
Do I need to add If condition? and also I have variables defined for the difference in value and previous value also
This may also work, if you do not have access to the script:
num((sum(Curr_Value)-(sum(Pre_Value)))/sum(total Prev_Value), '#,##0%')
I am using vCurr as the Diiference and vPrev for the previous value.
I am using variables vCurr and vPrev for the difference and previous value simultaneously and I have access to script
Chris does not work as I have to use this as dimension
The OP said you wanted to use it as a measure?
Sorry , I changed it to dimension.