Displaying quarterly data up to the current POSTGRESQL date

Question

According to the SQL Fiddle, I am displaying the quarterly data of a table, however, this query is only displaying when it has value in the quarter (3, 6, 9 or 12), when it has value for example in the current month (5), is not displayed anything, then...

How can I adjust my code SQL to display quarterly values up to the current date?

OBS.: Only the last month that would be out of the "standard" quarter in the case, to fit until the last record.

Answer 1

This is because in where you were filtering exactly this situation: only "divisible" months for 3.

AND cast(to_char("HistoricoIndicador"."dt_criado",'mm') as int) % 3 = 0 

If I understand correctly, you need to list the values of months per quarter, in which case you can use the function extract recovering the quarter number using the interval quarter.

SELECT 
"IndicadorPeriodo"."id" AS "IndicadorPeriodo__id",
"Meta"."meta" AS "Meta__meta",
(SUM("problemas") / SUM("total")) AS problemas,
extract(quarter from "HistoricoIndicador"."dt_criado") as periodo,
to_char("HistoricoIndicador"."dt_criado", 'yyyy/mm') as mes_ano,
case 
    when extract(month from "HistoricoIndicador"."dt_criado") <= 6 then '1º Sem.'
    else '2º Sem.'
end as semestre
FROM "indicador_funcionarios" AS "IndicadorFuncionario"
    LEFT JOIN "indicadors" AS "Indicador"
        ON ("IndicadorFuncionario"."indicador_id" = "Indicador"."id") 
    LEFT JOIN "historico_indicadors" AS "HistoricoIndicador"
        ON ("HistoricoIndicador"."indicador_id" = "Indicador"."id") 
    LEFT JOIN "indicador_periodos" AS "IndicadorPeriodo"
        ON ("Indicador"."indicador_periodo_id" = "IndicadorPeriodo"."id") 
    LEFT JOIN "indicador_metas" AS "IndicadorMeta"  
        ON ("IndicadorMeta"."indicador_id" = "Indicador"."id")
    LEFT JOIN "metas" AS "Meta" 
        ON ("IndicadorMeta"."meta_id" = "Meta"."id")
WHERE
    "IndicadorFuncionario"."funcionario_id" = 10131 
    AND "IndicadorPeriodo"."id" = 'T' 
    AND "Indicador"."id" = 1
GROUP BY
    "IndicadorPeriodo"."id",
    "Meta"."meta",
    "periodo",
    "mes_ano",
    "semestre"
ORDER BY "periodo";

If you need to display a row with the totals for each quarter, simply remove the column mes_ano of select and of group by.