Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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
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 ?
You can include as many you want
Count({<types=-{'Miscellaneous','Others','No Description'}>} distinct manif.K_ACTION)
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.
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)
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.
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
jphfavrei think JoeSimmons is right. You missed the bracket ')' of match
working
now in the result ....
how do i do to use this "regroup" action .....
Hi jphfavre ,
Use Fnac (which you have created in script) as dimension