Glad to see you've already go my trick for optimising big table calculations.
I've added another sheet which replaces your 10 table calculations with a single one - I suspect that will be a lot faster for you. I've not done a 10+ bin - I've included all bins - I'll leave that as an exercise. ;-)
One trick to be aware of is that I disabled the "ignore in table calculations" option on the [sum visits] pill on the columns shelf - that allows you to partition the results by the values of that aggregate.
visits_by_user_histogram_rl.twbx 445.6 KB
Thanks Richard. Your blog entries have been a huge help as I've been trying to puzzle my way through this.
Didn't realize you could dimension based off of a table calc of an aggregate (makes my head hurt a little just thinking about it). I'll give it a shot on the full dataset... If nothing else, saves me from having to change 10+ calculated fields whenever I want to make a tweak.
Hi, this is really useful and exactly what my tired brain needed. Thank you.
One further question (hopefully a simple one) what syntax do I use to creat a range/group within one of the buckets e.g. between 1 and 3 visits, then between 4 and 6 visits?
In the above attached workbook , I have a requirement where it displays column headers as 1,2,3,4,5, ..... instead of 0.1.2.3.4.5.... or is there a way to alias the column headers (I do not see edit as alias option as it is derived field) ?
Thank you in advance !!