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

set analysis issue

Hi guys!

I want to calculate the percentage of inhabitants that have called for information.

But for example 5000 calls have been recieven and I only have 1000 inhabitants.

So 1 inhabitant called approximatly 5 times.

But I don't want to see that.

When an inhabitant has called I dont want to count his other calls.

So when the inhabitant_id has already an inforequest, I don't want to count the others.

This is what I have for now:

count(DISTINCT {<inforequest_origin_id={'30'}>} inforequest_id)

/

NullCount(total{< inforequest_source_id=>} inhabitant_until)

Can you help me?

Kind regards,

Katleen

2 Replies
Not applicable
Author

Could you include some sample data?

Not applicable
Author

It seems like just a Count(Distinct inforequest_id) will do in your case. Not sure why set analysis would be required here. Can you attach a sample app with the results you are expecting.