Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
I want to exclude two definitions of 'COUNT'. Probably not so complicated, but I do not get it done. One exclusion works fine, a second exclusion unfortunately not.
What I would like to exclude: << choose from list >> and '...'
The expression I use:
Count ({$ <[Type or funtion] - = {"<< >> choose from list"}>} {$ <[Type of funtion] - = {"..."}>} [Type of funtion]) /
Count (TOTAL <Corporatie> {$ <[Type of funtion] - = {"<< >> choose from list"}>} {$ <[Type of funtion] - = {"..."}>} [Type of funtion])
Or: how to select only predefined textstrings in 'COUNT'
The tips given work, thanks... but on second thoughts I find it more convenient to configure the load script. After some research:
The dimension that you want to exclude of certain values:
[dimension]
FROM '$ (SOURCE) "(OOXML, embedded labels, table is [NAME TABLE]
Where [dimension] <> 'value to exclude' AND [dimension] <> 'value to exclude';
Try this
aggr(Count ({$ <[Type or funtion] - = {'<< >> choose from list','...'>} [Type of funtion]),[Type of funtion])
Count ({$ <[Type or funtion] = {'*'} - {"<< >> choose from list","..."}>} [Type of funtion])
....
Let me know
Like this?
aggr(Count ({$ <[Type or function] - = {'<<choose from list>>','...'>} [Type of function]),[Type of function]) /
aggr(Count (TOTAL <Organization> ({$ <[Type or function] - = {'<<choose from list>>','...'>} [Type of function]),[Type of function])
Probably not, since it doesn't work...
I don't know about aggr because I don't know data but
aggr(Count ({$ <[Type or function] - = {'<<choose from list>>','...'}>} [Type of function]) /
aggr(Count (TOTAL <Organization> ({$ <[Type or function] - = {'<<choose from list>>','...'}>} [Type of function])
Let me know
you can change only below in expression
[Type or function] - = {'listvalue1','listvalue2','listvalue3'}
you can even exclude more you want by comma sepeareted as above
hope this helps
The tips given work, thanks... but on second thoughts I find it more convenient to configure the load script. After some research:
The dimension that you want to exclude of certain values:
[dimension]
FROM '$ (SOURCE) "(OOXML, embedded labels, table is [NAME TABLE]
Where [dimension] <> 'value to exclude' AND [dimension] <> 'value to exclude';