Before Selection and After Selection value Changes

[#1]

Hi All,

i have a prob, when calculating summations the values changes reason why i don't know, as i request help:

before selection:

Teachers	Students	Visit
Teacher A	Student A	2
Teacher A	Student B	1

after selection

Output:

Teachers	Students	Visit
Teacher A	Student A	0
Teacher A	Student B	1

How can i resolve this on Student A?

Regards.

[tresesco]

Without knowing your app, it would be wild guess. Try to share your sample app.

[sushil353]

Hi,

Say you are calculating some expression Sum(Value)

then try like this = sum({<Teachers=, students=>}Value)

HTH

sushil

[richard_chilvers]

Its hard to say without seeing your model. My suggestion is to look carefully at how your data has been constructed in the script. This may lead to unexpected results when you make selections (depending on the field you're selecting).

Regards

[Anonymous]

you can use 2 solution

refer to super set if you dont at all want any selection to change this chart numbers 

you can add set analysis to your aggregate function

=count( {1} visitid)

and if you want just want particular field selection should not change the chart numbers then

you can use as follows

=count( {<Field1=,Field2=>} visitid)

[#6]

Hi Bhagirath,

Here is my code it dosen't seem to work:

=sum(aggr(count(DISTINCT SalesDate),CustomerCode))

Regards.

[Anonymous]

=sum(aggr(count({1}DISTINCT SalesDate),CustomerCode))

you can refer to the community link below for more details on Aggr functuion

Aggr() function

regards,

Bhagirath

[awhitfield]

What exactly do you mean by 'before selection' and 'after selection? What are you selecting?

Andy

[#9]

Hi Andrew,

when trying to select on a Teacher.

the value on my Visits Changes as shown.

[awhitfield]

Can you post your app please?

Andy