I think the easiest would be to create the bins via a calculated field like in this guide.
Basically the calculation looks like:
IF [Trans count] = 21
ELSEIF [Trans count] = 22
Through a calculation similar to this you can create any custom bins.
Alternatively if you really only want a bin size of 1, you could drag your [Trans Count] to the dimensions pane (or duplicate and then frag into dimensions). That way you can bring it into the view to give you headers.
Hope my answer helps.
Thank you Justus and Mahooj for your quick replies. These seems fine but I have to apply it on my complete database and there are around lakhs of unique customers and their transaction count can vary up to 1000. Its very difficult to write formula for each bin size of transaction. Is there any alternative solution for this?
Justus Niemzok: Transaction Count being an aggregated field it cannot be converted in to dimension. I am trying to pull it in dimension table but it still remains in measure.
Thank you very much Mahooj...
Please see my reply to Justus.....
Good point Harshal, sorry I missed that. Of course you cannot drag an aggregated measure into the dimensions.
You can though create bins based on LoD calculations. So I guess what you need is a count of transactions per customer. Then create a bin on that. See picture and attached workbook.
Let me know if this helps you.
Sample_Workbook_transcount.twbx 20.5 KB
Glad I could help!