topic Re: How to use a self created measure as dimension? in App Development

How to use a self created measure as dimension?

Thu, 03 Dec 2015 07:17:49 GMT

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

jonathandienst — Thu, 03 Dec 2015 12:38:03 GMT

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.

sunny_talwar — Thu, 03 Dec 2015 13:13:38 GMT

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