Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
I have some data that is "years a membner" between 0 - 10. I want to put this field in our x axes on the chart. However, some of the data is 0.3 and 0.4. etc. I want all 0 to be listed as 0 yers and everything between 1-2 listed as 1. So all these different time frames are loaded as 1-10 years.
Any thoughts?
Thanks,
Hi there, is easy either you use a calculated dimension as follows:
=floor([Years as member])
Or you can add the function within the load script, which is actually better in terms of performance:
Load A, B, C, floor([Years as member]) as [Years as member Display]
from Z;
Regards