set analysis question

Fri, 25 Jul 2014 12:12:16 GMT

How do I write this set analysis?

The one I have now counts how many inforequest there are (per city) divided by the population of a certain city

For this the next expression works.

count(DISTINCT inforequest_id)/NullCount(total Inhabitant_until)

Now I want to add a set analysis.

Because when I select a month/quarter/year the the expression changes aswell.

So I did the next:

count(DISTINCT inforequest_id)/NullCount(total {1}Inhabitant_until)

which worked fine to disregard the selections I made.

But the problem is that is should take into account the selected city.

How do I write in the expression that the city should equal the selected city

but disregard all the other selections that are made.

Kind regards,

Katleen

Re: set analysis question

gmoraleswit — Fri, 25 Jul 2014 12:31:00 GMT

try this:

count(DISTINCT inforequest_id)/NullCount(total {1<city=P(city)>}Inhabitant_until)

Fri, 25 Jul 2014 12:36:41 GMT

Gives me a few 1000%, so it doesn't work unfortunatly