Trying to filter unix time to current month only

Grafana Dashboards
1

Hello, I am using grafana cloud dashboards… I have a data series that I have pulled in via an API.

image
image1172×385 17 KB

I am trying to find a way to filter the Unix Epoch time in the clientCreatedTime field so that my data set only shows the current month’s data (ie from the 1st of the current month → today inclusive).

Is there a way to do this using the transform options?

Thanks

2

Hi @markbull and welcome to the Grafana forum.

Does your table change at all when you select this in the time picker?

image

If not, it’s because Grafana does not “see” the clientCreatedTime field as the time field. If that’s the case, you should be able to use one of Grafana’s tools to change it. See some ideas here.

3

which plugin are you using to fetch the rest api data? infinity plugin or json api?