Forum Academy Marketplace Showcase Pricing Features

Filtering by quarter

Hello everyone,

I was wondering how can I get results from a filtering based in the current quarter and the past quarter.

For example for the current quarter I´ll be showing data of the 3rd quarter since we are in September and for the past quarter I´ll be showing the data of the 2nd quarter of this year.

I´ve been playing with dates but cannot figure out yet how to do this.

Thanks a lot guys.

Have a good day.

I’m sure there are many ways to do this, but the first thing that popped in my head is when you create the “thing” that existed in September, you would also have a field on that thing called “quarter.” You’d set the quarter equal to 3 if the date was September. Then, on your filter, you’d just have to filter by the thing’s quarter field.

Not sure what your specific use case is, but I think it’d work.

Hi @potentialthings,

I´ve tried that and it works. The problem now is that it has to be filtered by the current quarter and the past quarter.

Do you have any ideas? I´ve been thinking a lot about this but nothing.

Thanks a lot for your help.

Good question. I’ve struggled with getting “or” logic working in my apps, too. Unfortunately, I got nothin

You could used the “merged” function in the search to combine last quarter and this quarter.

And the quarters can be controlled by looking up a record with the current date that has the quarters in them ?

Hi,

It´s like a Dashboard where you have the filters: current quarter and previous quarter. So when hitting on current quarter the box below will be showing the current quarter´s “net” “:sum” for example so the user can see the total of all the invoices net amount.

What do you think?

Thanks a lot.

Ah, ok. yes, it is a little involved, and I struggled to make it any simpler.

So I filtered invoices where the invoice date is between two dates on the “Quarter” table.

And I chose the Quarter table that the current date is between quarter start and end.

So that table shows you the current quarter and the previous, and you can filter using those dates.

1 Like

Wow, nice one.

I´m still figuring out how you got that. I´m getting a little bit lost about it.

So you created a new “type of thing” on the database named “quarters” and then you set the quarter start and the quarter end, right?

But what about setting the quarter right in the invoices as “Q1”, “Q2”, … ?

Could you explain me a little bit?

Thanks a lot.

Yes, that is another way of doing it. Set the Quarter by extracting month, and if it is 1,2,3 set Q1 etc.

But you will end up, I think, doing pretty much the same thing in terms of working out what Quarter you are in, and what the last quarter was.

Thanks a lot @NigelG

I´ll try my best to achieve it.

It is one of those things that seems like it should be easier than it really is.

You´re so right. It´s like oh current quarter and last quarter, then you try to get the computer to do that and it gets so difficult. Hehe

Thanks a lot Nigel.