Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi All,
i am facing one issue that error in calculated dimension.
the expression is
Num(Num(Count({<nps_value = {'Promoter'}>}nps_value)/(Count(nps_value)),'#.#0%')
- Num(Count({<nps_value = {'Detractors'}>}nps_value)/(Count(nps_value)),'#.#0%'),'#.#0%')
i have seen in community that need to use Aggr function but no luck.
can any one suggest please.
Thanks
Rajesh
Over which dimension are you calculating the Count of nps_value?
May be this
Aggr(Num(((Count({<nps_value = {'Promoter'}>} nps_value)/Count(nps_value)) - (Count({<nps_value = {'Detractors'}>} nps_value)/Count(nps_value))), '#.#0%'), Dimension/s)
Over which dimension are you calculating the Count of nps_value?
May be this
Aggr(Num(((Count({<nps_value = {'Promoter'}>} nps_value)/Count(nps_value)) - (Count({<nps_value = {'Detractors'}>} nps_value)/Count(nps_value))), '#.#0%'), Dimension/s)
Thanks Sunny,
its working as expected,but have one thing to in it Pivot table
i would like to move NPS dim right to Promoter and hide the empty space nps_value.
Thanks
Rajesh
What is NPS dimension? Would you be able to share a sample?
Hi Sunny,
NPS dimension data is like nps_value(String value)
I am not 100% sure I understand your requirement.... do you mind elaborating a little bit?
Hi Sunny,
I have 3 dimensions 1.instance questions,2.nps_value(Detractors,Promoter etc), NPS(Calculated Cloumn)
Expression is Count(actual_value)
as u can see above screen shot i would like to dispaly NPS calculated to be moved to right side of Promoter and hide the nps_value column.
Please see below screen shot for u r reference. i hope u understand the requirement.