Cartesian 2 Polar

Greg_Deckler — Wed, 27 Jun 2018 20:25:12 GMT

These two measures convert Cartesian coordinates to polar coordinates. Both take two parameters, x and y, which are Cartesian coordinates.

r = SQRT(POWER(MAX([x]),2)+POWER(MAX([y]),2))

theta =
SWITCH(TRUE(),
            MAX([x])>0, ATAN(MAX([y])/MAX([x])),
            MAX([x])<0 && MAX([y])>=0, ATAN(MAX([y])/MAX([x]))+PI(),
            MAX([x])<0 && MAX([y])<0, ATAN(MAX([y])/MAX([x]))-PI(),
            MAX([x])=0 && MAX([y])>0,PI()/2,
            MAX([x])=0 && MAX([y])<0,-1*PI()/2,
            BLANK()
)

eyJrIjoiYjY5OTIxMzEtMWRiNy00ZmQ0LTk5ZjMtMTMxN2M4OTdiNTMwIiwidCI6IjRhMDQyNzQzLTM3M2EtNDNkMi04MjdiLTAwM2Y0YzdiYTFlNSIsImMiOjN9

topic Cartesian 2 Polar in Quick Measures Gallery

Cartesian 2 Polar