I have a Postgres DB with Bill#, BillDate & Bill Amount. I have data from Jan 2017 till Oct 23, 2018. I need to create a Sales analytics dashboard with the daily, weekly, monthly & yearly bar chart. I also need to show a comparison with respect to the previous year.
I get data from Postgres DB only at end of the day. Say I am permitted to pull data on every day 10 pm.
Can I achieve this using grafana.? I am aware that my data is not coming in regular interval but my x-axis is Daily/Monthly/Yearly derivative of date.