I need to Group a particular column based on its row value. what i mean to say is if i have a column with value range from 1 to 100 , i want that column to grouped into certain buckets like from 1 to 20 should come in one bucket and 2 to 20 should come in other...?
Any idea how can i acheive this? I tried for GroupbyEvaluator but coulnd find much info on that:(
Hello Mike,
Thank you for your feedback. I am glad that you resolved your issue and I believe that other community members may benefit from this as well.
Thanks again.
That worked great!
Thanks (and thanks for the incredibly fast response!),
Mike
I have modified the sample, so now it has the functionality you want. Please let me know if this helps you or you need further assistance on this matter.
Looking forward for your reply.
I see the images I attempted to load from my local disk didn't make it. It's pretty easy to see what I'm talking about. Simply run the example and group by anything other than Dosage and you'll see the counts. Grouping by Dosage no longer shows the counts.
I tried out your example, after finding a problem with my own code, and it shows the same problem. When you use custom grouping, the count of the number of items is no longer shown.
For instance, if I group by Patient, I get the counts [(2 items) etc.] on each group.
But if I group by Dosage, I only get the name of the group (0-33, 33-66, and 66-100), but the counts are missing.
This is going to be a big issue for us, because I want to apply a case-insensitive grouping to all String columns, so I will be losing the counts on all of those columns.
Is there a way to have custom grouping and the counts?
Thanks,