
Calculate distinct values ignoring one dimension
Stefan Wühl Apr 12, 2012 6:36 AM (in response to Mathias Vanden Auweele)Remove the dimension?

Re: Calculate distinct values ignoring one dimension
Celambarasan Adhimulam Apr 12, 2012 6:41 AM (in response to Mathias Vanden Auweele)Hi,
Try with dollar expansion like below
use your expression as $(=count( distinct VALUE))
Celambarasan

Calculate distinct values ignoring one dimension
Mathias Vanden Auweele Apr 12, 2012 6:51 AM (in response to Celambarasan Adhimulam )Thanks for your fast replies. However:
@swuehl: then my chart wouldn't have a dimension...
@Celambarasan Adhimulam: that ignores my dimension completely. I still want the count to be calculated for every MONTH but it shouldn't include the VALUES already counted in the previous MONTHs

Calculate distinct values ignoring one dimension
jagan mohan rao appala Apr 12, 2012 6:59 AM (in response to Mathias Vanden Auweele)Hi,
Try this expression
=Count( distinct TOTAL VALUE)
Regards,
Jagan.

Calculate distinct values ignoring one dimension
Mathias Vanden Auweele Apr 12, 2012 7:25 AM (in response to jagan mohan rao appala )That gives me the same result as using the dollar sign expansion

Re: Calculate distinct values ignoring one dimension
Stefan Wühl Apr 12, 2012 7:33 AM (in response to Mathias Vanden Auweele)You could use something like
=count (distinct aggr(ID, ID))
as expression (see attached sample). aggr() function will list your IDs in load order and determine based on this if a values is already read in. So to make it work, your load order of IDs should be also in chronological order.
Hope this helps,
Stefan
edit:
even a
count( aggr(ID,ID))
should / could be enough, the distinct we need is implicitely part of the aggr() function.

comm51224.qvw 146.8 K

Re: Calculate distinct values ignoring one dimension
Mathias Vanden Auweele Apr 13, 2012 10:08 AM (in response to Stefan Wühl )swuehl: thanks! that does the work perfectely!!


Calculate distinct values ignoring one dimension
jagan mohan rao appala Apr 12, 2012 7:31 AM (in response to Mathias Vanden Auweele)Hi,
Can you attach sample file.
Regards,
Jagan.



