Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 
Not applicable

How to use a self created measure as dimension?

Hi everyone,

I have created an expression to calculate something ,now can I do some more calculation on the same expression?

Example:

count(if(abc=0,id))

and named it as  "#ids"

Now, can I do

count(if(#ids >1, 'A','B'))

and I want to use this in pie chart.

Pls help on this.

Thanks

Shivesh

2 Replies
jonathandienst
Partner - Champion III
Partner - Champion III

Perhaps thuis:

=count(Aggr(if(count(if(abc=0,id)) >1, 'A','B'), <...pie chart dimension here...>))

I suggest that you post a sample qvw to save the guesswork and ensure that you get accurate and useful suggestions.

Logic will get you from a to b. Imagination will take you everywhere. - A Einstein
sunny_talwar

I agree it would be easier to troubleshoot with a handy sample