We see that while deriving a measure based on aggregation over fiscal quarters-
Data View -
Visualization -
Generated SQL -
SELECT
(TO_CHAR(DATE_TRUNC('month', DATE_TRUNC('quarter', salesorderdetail."modifieddate" )), 'YYYY-MM')) AS "salesorderdetail.modifieddate_fiscal_quarter",
COALESCE(SUM(( salesorderdetail."unitprice" )), 0) AS "salesorderdetail.sum_of_units"
FROM
"sales"."salesorderdetail" AS "salesorderdetail"
GROUP BY
1
ORDER BY
1 DESC
FETCH NEXT 5000 ROWS ONLY
it seems the the missing quarter is being handled by the visualization layer, rather than generated SQL itself. Is there any plan/merit doing it at the SQL layer?