Filtering months dynamically

Sharathkrishnan

In the above output the solution fetches last year's records.but I want to fetch last 12 months irrespective of year

Eg., if the data is till july 2021..last 12 months would be july 2020 to july 2021..

if the data is till feb 2020..last 12 months would be july 2019 to july feb 2020..

and also I should be able to change number of months I fetch...

sometimes I might want to fetch last 4 months also

Status 2.yxmd

data.xlsx

input.PNG

output.PNG

Datasets

Date Time

Common Use Cases

Join

Predictive Analysis

Data Investigation

Accepted answers

mceleavey

@Sharathkrishnan , yes, they're on the F output of the filter. You can do whatever you want.

All comments

mceleavey

Hi @Sharathkrishnan ,

I've built this as an analytic app for you.

This way you can select the cut-off date and the number of months before the cut-off you wish to go back.

For example, when you run the app using the following button:

you get the following pop-up:

If you select 3rd of June 2021 and the prior 10 months you get the following:

I've attached the workflow.

I hope this helps.

Status 2_mceleavey.yxwz

Sharathkrishnan

Hi,

But I need not want it as a app. It should fetch the latest date from the data and I need to traverse back to the number of months I mention.Fetching latest date should be doen automatically.. Can you help me with it?

Quick Links

This months top contributors

mceleavey 383

mbarone 337

Hollingsworth 335

LanisC 335

JeffF 335