Get Total Sales By Current Month

I’ve built a dashboard that shows a few boxes. one of which is the total sales for the current month. I’m having trouble understanding how to limit the results to just the current month.

Current month should be the actual current month we are in on the calendar year.



I think the issue is getting the month created and the month current so you can compare the two.

To do that I would create a hidden input field on your page that does a search for your invoice’s creation date and apply extract to just return the month.

Something like this:

then in your Search for invoices 2nd constraint just compare your new input box to the current date: extract month and it should work ::slight_smile:


This topic was automatically closed after 70 days. New replies are no longer allowed.