Data manipulation using calendar interface

[Polite123]

Hi Team,

Need quick help on below topic:

I have data in one columns in the form of quarters Q1,Q2,Q3,Q4.

I have created new column of Month by converting quarter to particular month i .e. March,June,Sep,Dec etc.

Now my requirement is that whenever I select a date from particular quarter using calendar ,it should filter data in Month column corresponding to previous quarter.

For example:

Input data:

Quarter	Month	Value
Q1	March	3
Q1	March	4
Q2	June	5
Q3	Sep	6
Q4	Dec	8
Q4	Dec	7

Using calendar interface, I select one date from Dec month

Output:(Need previous quarter data)

Quarter	Month	Value
Q3	Sep	6

[FinnCharlton]

Hello,

Here is an app that does this. Hope this helps

[binuacs · Accepted solution]

@Polite123 One way of doing this

[Polite123]

Hi @FinnCharlton ,

Thanks for the quick reply.

But the app seems to be working only for Dec.

When I select Sep, I am getting no data.

It is more hard coded.

Do we have any alternative solution to make it more dynamic in nature using calendar

[FinnCharlton]

@Polite123 The app is working in every month for me? Maybe the < and > operators need changing to <= and >=? The only hard coded part of this app is the year 2022, which I added as you have no Year field in your data. I have attached a fully dynamic version.