I am trying to display the total length of utility pipes by using the indicator widget and using the sum statistic of the shape_length field, I am given an error with the data by trying this, and I am wondering if it is even possible to use this field for statistics, and if not, what my other options are.
I happened to have the same question today. I used a factor of 0.000189394 to convert feet to miles. I left the offset at zero. I'm creating a gauge that shows the number of feet of sewer pipe inspected to the total number of miles that should be inspected in one year.
To figure out the conversion factor I googled conversion factor feet to miles
Were you able to use shape_length as a statistic field for your gauge? I am trying to just show the length of sewer pipe in the region in miles with the indicator widget, I figured this would be simple in OD, but its been more complicated than I thought.
I've tried using SHAPE.LEN from both a feature layer and a map image layer and both give the same "Cannot Access Data" error. We had to create a spatial view of our SDE data and add a length column using ST_Length(). This is in Enterprise 10.6.1. Hopefully ESRI figures out this bug in 10.7 or 10.7.1.