Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi Community
I am trying to get this done, but to no success....
From Excel I read this info:
Date Month CallerID
2019-01-01 Jan 3ababab
2019-01-28 Jan 3ababab
2019-01-01 Jan 2efefefef
2019-02-01 Feb 3ababab
2019-02-02 Feb 3ababab
2019-02-03 Feb 3ababab
2019-03-01 Mar 3ababab
2019-03-02 Mar 2efefefef
2019-03-03 Mar 2efefefef
2019-03-03 Mar 2efefefef
2019-03-03 Mar 2efefefef
2019-03-03 Mar 2efefefef
I need find, per month, the persons (CallerID's) that have called once, twice, three times and four times or more.
So the result should be
Month: (Number of people who called) once; twice; three times; four times or more
January: 1;1;0;0 (Expl. 2efefef called once, 3ababab called two times)
February: 0;0;1;0 (Expl. 3ababab called three times)
March: 1;0;0;1
Hope it is clear what I try to achieve ... and someone has an idea how to solve this...
Highly appreciated, that's for sure.
Found a solution after a long, long day of learning a lot and a zillion trial-and-errors!
In the expression I use:
=COUNT({<CallerID = {"=COUNT(CallerID)=3"}>}DISTINCT CallerID)
To determine the total number op (unique/distinct) people, who called us (for this example) three times.
Might be easy for the experts but perhaps it can help some other beginners; the syntax is still a hand full.
Kudos to me.😅
Something like this?
Hi Sunny_Talwar
Thanks for your prompt reply. What I miss is the 'condition part' unfortunately (how often do these people call).
Let me try to formulate the problem statement again, perhaps it was unclear: I need to find the number of unique CallerID's (persons), that -per month- call us, given the condition that they called 'once', 'twice', 'three' and 'four times or more'.
So in a example bar graph it should look like this:
Month = January
In red are my handwritten 'conditions' signifying how often people called us in that month. So the dark blue (962) bar represent: 962 people calling us 1 time. The red bar shows the number of people (250) calling us two times (in January).
[The graph is incorrect and only used to test many formula's on my side in trying to understand what the formula's that I have entered represent]
I still don't think I understand...
Found a solution after a long, long day of learning a lot and a zillion trial-and-errors!
In the expression I use:
=COUNT({<CallerID = {"=COUNT(CallerID)=3"}>}DISTINCT CallerID)
To determine the total number op (unique/distinct) people, who called us (for this example) three times.
Might be easy for the experts but perhaps it can help some other beginners; the syntax is still a hand full.
Kudos to me.😅