Graph to display only last months entries

Ask for Help
1

Hi there, I am trying to display a graph that plots the numerical output from a report of underlying companies (e.g. Monthly headcount).

I want it to only display records submitted in the latest month (I have a date submitted field in Airtable e.g. 04/04/2024) and would only want the records relating to April 2024.

When I plot them on the graph now, it automatically aggregates all months from the Airtable data, whereas I just want the most recent period/30 days without having to hard code the filters each month.

Do you have any suggestions?

2

In the Glide Data Editor, create a Math column using the formula Now-30, where Now is the special “Now” value (current date/time).

That should return a Date that is always 30 days in the past.

Then filter your chart where Submitted On is on or after that date.

3

you so smart

4

btw, do you know how I can only show one linked record per company? E.g. the most recent report if multiple filed within the Now-30 period? It’s stacking together headcount and displaying 2x reports of 10 headcount as 20.

5

Not sure if I fully get it, but if I’m reading correctly then you could probably create a Query column in your Companies table that targets the Submissions table, filter that by Date Submitted and CompanyID, do a rollup through that to get the counts, and then use the Companies table as the source of a chart.

6

This topic was automatically closed 7 days after the last reply. New replies are no longer allowed.