After adding the dimensions and measures in Looker explorer when looked at the generated SQL I see lot of functions are added for the measures. When compared the simple version of it, this explorer generated version is impacting the accuracy and performance.
FYI When ran in sqlrunner using the simple agg functions data is returned fast and correct.
Wondering if there is an option to avoid this generation
Expected : Sum( Cost ) = 100
Looker Explorer generated SQL : COALESCE(CAST( ( SUM(DISTINCT (CAST(FLOOR(COALESCE( COST ,0)*(CAST(1000000 AS DOUBLE PRECISION)*1.0)) AS DECIMAL(38,0))) + CAST(to_number(SUBSTR(hash_md5…………………….. = 80