Set analysis, how to exclude data

[#1]

Hello

I am working on a graph to show different actions, but i want to EXCLUDE the ones with the types called "Miscellaneous".

i have been this expression but i have an error message like Error in set modifier Ad hoc element list....any clue ????

=Count({<types=-{'Miscellaneous'>} distinct manif.K_ACTION)

thanks

JP

[#2]

Now if i want to regroup 3 types Under 1 ...for exemple, i want to regroup under "Other"  : others, no description, miscellaneous.

what would you recommend ?

[Kushal_Chawda]

You can include as many you want

Count({<types=-{'Miscellaneous','Others','No Description'}>} distinct manif.K_ACTION)

[#4]

it is more "regroup" than include....

let s say i have data A, B and C and i would like to regroup them Under D.

[Kushal_Chawda]

in script do something like below

if(match(Type,'Miscellaneous','Others','No Description', 'Regroup',Type) as Type_new

Now you can do like

Count({<types=-{'Regroup'}>} distinct manif.K_ACTION)

[#6]

here is my case..in the script

LOAD title,
types,
Name_company,
if(match(Name_company,'Fnac Rive','Fnac Balexert','Billeterie fnac', 'Regroup',Name_company)) as Fnac, 
manif_in,
Year(manif_in) as Year,
Month(manif_in) as Month,

but NOT working , he does not like the line IF when i am doing the reload.

[#7]

you've misplaced the closing bracket

if(match(Name_company,'Fnac Rive','Fnac Balexert','Billeterie fnac'), 'Regroup',Name_company) as Fnac, 

give that a try

Joe

[Kushal_Chawda]

jphfavre‌i think JoeSimmons is right. You missed the bracket ')' of match

[#9]

working

[#10]

now in the result ....

how do i do to use this "regroup" action .....

[Kushal_Chawda]

Hi jphfavre ,

Use Fnac (which you have created in script) as dimension