5 Replies Latest reply on Aug 29, 2018 6:58 AM by Naveen B

    Calculating number of distinct callers

    Nimit Bhardwaj

      I have data where callers have called in and reported one of two problems. [Sample Attached]

      What I need is a visualization where I can see how many users called once, how many called twice and so on...


      Something like this:



      I need an option to see this for one problem at a time or more. (Hope putting problem in filter would work)


      Also, How do I create a visualization where I can show the total number of calls [sum of records? (200*1+150*2+100*3+50*4+25*5)] , the number of distinct callers [sum of each row?  (25+50+100+150+200)]  and the number of users who called more than once [ distinct - 200 ?] ?


      Thanks in advance.