Forum Discussion

rohitjmd's avatar
rohitjmd
Helper II
7 years ago
Solved

need help

i am working on a respondent data where i have names of apps installed along with thier category. Could anyone suggest how to bulid a graph to show cateogry wise counts for these cuts- more than 10 a...
Need Help
  • Ashish_Mathur's avatar
    Ashish_Mathur
    7 years ago

    Hi,

    That's easy but then for any category you select, there will only be one bar because there will only be one number per category.  Please clarify.  More importantly, please review the numbers in the left hand side table and met me know whether they are correct.

  • Ashish_Mathur's avatar
    Ashish_Mathur
    7 years ago

    Hi,

    Download the zipped folder from here.

rohitjmd's avatar
rohitjmd
Helper II
7 years ago

hi Ashish, 

thanks for your reply.

though rather than counting the unique repspondents, i want to see how many same respid appears for a cateogory which have different apps installed. a respid represents a user id so if i am having a same user id for more than 10 times for a category for different apps, i need to count that user once in no of user with more than 10 apps bucket.

 

below pic is to show you the outcome required in case of app category social.

 

 

Ashish_Mathur's avatar
Ashish_Mathur
Super User
7 years ago

Hi,

Is this the result you are expecting?  Could you share a much larger dataset and the actual bucket sizes.  This is for me to check the efficiency of the formula.  Also, on the larger dataset, please share the sample output for 1 or 2 categories.  Lastly, if there are more column that you want to include in the dataset (say Country) and filter the table by a specific country, then share that result of 1-2 categories for that specific country as well.