count in selectedfield

[adambrian]

Hi,

i want to count people by id where when i select department A.

Count({<department=getfieldselections>} id)

and i want count people not in department A when i select department A.

Count({<department=getNotfieldselections>} id)

anyone help me to solve this one.

Thanks,
Adam

[adambrian]

i tried this but not function..

if(GetFieldSelections(department),department,

if(GetFieldSelections(unit),unit, 'others'))

[vinieme12]

it should be

=if(Getselectedcount(Department)>0, YourExpression for department

     ,if(Getselectedcount(Unit)>0 , YourExpression for Unit))

[adambrian]

Hi Pratyush,

i tried this one but has error. can you help me this one?

count people by id where when i select department A.

Count({<department ={'$(=GetFieldSelections(department ))'}>}id)

[prat1507]

Hi adam

This will only work for Single selections, not for multiple selections. You've to use Vineeth's expression for multiple selections. Please let me know what you need exactly.

Regards

Pratyush

[prat1507]

Hi Adam

If you want to see your selections, you can use =GetCurrentSelections().

Regards
Pratyush

[adambrian]

Hi,

Sorry, I have a few question again, can you help me

I want to calculate and show in pie chart, if i select any UNIT and need to compare same UNIT=OLD_UNIT.

For example i select unit1 in department A:

1) show GROUP count by STAFF_ID where if i select an@y unit getfieldselections(UNIT) and if UNIT=OLD_UNIT

2) show DEPARTMENT count by STAFF_ID where count all STAFF_ID except unit1 in department A.

getNotfieldselections(UNIT) and if UNIT=OLD_UNIT

And what should i put in Dimensions and Measure field?

@vinieme12 @prat1507

[vinieme12]

can you post an excel file and also confirm expected outputs?