Table with power counter reading for every 1st and 15th of month

Grafana Dashboards
1

Dear community,

I already have some Grafana energy meter dashboards but I struggle with a maybe simple idea.

For (external, analog) statistic reason I need the power counter reading for every 1st of the month and for every 15th.

This dashboard has the data “total_consumption” which is the couter meter.

grafik
grafik1853×811 86.8 KB

grafik
grafik1430×796 46.5 KB

I think there should be an easy way to have a table showing the counter reading for every 1st and 15th of each month?!

Thanks for any help in advance.

Cheers
Eike

2

might want to also ask in infkixdb community forum. maybe use one of the date functions listed here to find day of month? not sure which version of influxdb you are using

3

Thanks for the answer. I will check that out.