Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
I want to disregard all selections for this expression, except the city_id
The expression calculates the percentage of the population that has called the infocenter.
But the total population always has to be the total population, except when you select a city.
Then it has to be the total population of that city, not considering all the other selections that are made.
This is what I have, just disregarding all the selections:
count(DISTINCT inforequest_id)/count(total DISTINCT{1} inhabitant_id)
How do I add that the city_id has to be the selected city_id?
Hope someone can help!
Kind regards,
Katleen
Exactly what I wanted, thank you very much!