Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi,
Struggling a little bit with some bucket analysis using a calculated dimesnion. Simple example qvw attached.
Basically I can define the bucket as a calculated dimesnion. The chart seems to correctly count the number of IDs that fall in each bucket for each year, but when I try to calculate the TOTAL Ids for the year (in order to create a 100% bar chart) it seems to ignore TOTAL <Year> part of the formula and give me the same result as the simple COUNT. Where am I going wrong?
Hope someone can help.
Thanks
Matt
Try this
=Aggr(NODISTINCT Count(DISTINCT ID), Year)
That works, thanks!
Can you explain the difference between the two methods and why one works but not the other?
Thanks
Matt
Not sure why the TOTAL isn't working (I would have thought that it would work and I would have suggested you to use it), but to see the what they do, check here: