can we increase the loop dynamically

[Prakash004]

Hi All,

Need you help on the below query.

In my dashboard I'm take data using for loop for multiple quarters. I have data load from 2016 till date and data load is on quarterly basis. Now I am loading the data with manually changing the loop every quarter
like 0 to 22 for last quarter and 0 to 23 for this quarter, but I need to automate this loop for every upcoming quarter.
that is next quarter the loop should dynamically change to 0 to 24 without manual intervention.

Could you please suggest some approach here, how the loop can change dynamically.

Thanks,

Prakash Sethy

[rubenmarin1]

Hi, I think you can get your max value using:

=Ceil(((Year(Today())*12+Month(Today()))-(2016*12))/3)-1