
1. Re: Histogram off calculated Measure field
Dana Withers Mar 27, 2013 3:03 AM (in response to Jackie Klein)Hi Jackie,
It does say that histograms are not available for all measures. Your measure must be one of the exceptions. I have done histograms on calculated fields, but I think they are not available for certain table calculations.
If you want, you can attach a workbook with sample/dummy data and perhaps there is another way of doing what you would like to achieve...
Hope that helps,
Dana

2. Re: Histogram off calculated Measure field
Carl Persson May 1, 2013 3:30 PM (in response to Dana Withers)I too am trying to figure this out. I am using a calculated field averaging clocktimes. The calculation is based on 2 fields with numerical data:
sum([total_time])/sum([grand_total])
The option for "Create Bin" is not available in that calculated field.
Thanks
Carl

3. Re: Histogram off calculated Measure field
Justin Emerick May 1, 2013 5:11 PM (in response to Carl Persson)Carl,
While this doesn't give you the full use of a Bin, you could create another (or modify your existing) calc field to use the "Round" function. This would put your values for sum([total_time])/sum([grand_total]) into "bin" like segments.
let's say you wanted the values to increment every .5
round((sum([total_time])/sum([grand_total]))/.5,0)*.5
you could also create a parameter that to dynamically change the increments
round((sum([total_time])/sum([grand_total]))/([numeric parameter]),0)*([numeric parameter])
Justin