Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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
Could you include some sample data?
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.