
1. Re: The Infamous Gauge
Ken Flerlage Jun 11, 2018 10:02 AM (in response to Nishant Trivedi)I'm not entirely sure I follow what you're trying to do here, but let me try to help out.
My biggest confusion is the calculation Angle Value. I believe this is intended to result in a value from 0 to 1, correct? So the HCC Accuracy of 0.5246 with a goal of 20 would result in an Angle Value of 0.02623. Is that what you expect?
Assuming the above assumptions are correct, I'd suggest a few changes to your calculated fields to simplify the logic.
Angle in Degrees
(1[Angle Value])*180
Angle in Radians
RADIANS([Angle in Degrees])
X
IF ATTR([Row Type])='Dial' THEN
0
ELSE
COS([Angle in Radians])
END
Y
IF ATTR([Row Type])='Dial' THEN
0
ELSE
SIN([Angle in Radians])
END
This will change the gauge to the following.
See attached workbook.
If this meets your needs, please be sure to mark this answer as correct. Thanks!

Gauge Try.twbx 36.3 KB
