Error in Calculated dimension

[Rajesh]

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

[sunny_talwar · Accepted solution]

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)

[Rajesh]

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

[sunny_talwar]

What is NPS dimension? Would you be able to share a sample?

[Rajesh]

Hi Sunny,

NPS dimension data is like nps_value(String value)

[sunny_talwar]

I am not 100% sure I understand your requirement.... do you mind elaborating a little bit?

[Rajesh]

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.