Need Help with creating a time series dashboard for Postgres

Grafana Configuration
1

i Have three column in my postgres table.

creationtime -> timestamp with time zone -> 21-MAY-19 00:27:43.683 +05:30
content -> jsonb -> Json Data
resourceid -> character

I need to create a dashboard for previous day total count, and showcase for last 6 days, Can someone Kindly Help me with that.

Thanks!