Forum Discussion
Play Axis with time aggregation
Using Oracle, i created another calendar table this way:
select a.data, b.data from
(select a.data
from
(select to_date('01/01/2022','dd/mm/yyyy') + rownum - 1 as data
from dual
connect by rownum <= to_date('31/12/' || to_char(sysdate, 'yyyy'),'dd/mm/yyyy') - to_date('01/01/2022','dd/mm/yyyy') + 1) a) a
left join
(select a.data
from
(select to_date('01/01/2022','dd/mm/yyyy') + rownum - 1 as data
from dual
connect by rownum <= to_date('31/12/' || to_char(sysdate, 'yyyy'),'dd/mm/yyyy') - to_date('01/01/2022','dd/mm/yyyy') + 1) a) b
on a.data >= b.data
Using this table, i connected the column named Data (in Brazil Date is wrote like Data) with the column Date from my original calendar Table and then into the Play Axis i used the column Data_Pai (mother/father date).
You can view this result in this link: