Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi Dear Experts,
i got the some script on community
im using two different scripts for Rolling 3 and Rolling 6 Months is there any way to implement in one script
need experts suggestions, below is the scripts
Rolling3 :
load 'Current' as Type,
Month as Rolling3,
Month as Month
Resident Calender;
Concatenate (Rolling3)
load 'Rolling 3' as Type,
Month as Rolling3,
Month + 1 - IterNo() as Month
Resident Calender
while IterNo() <= 3;
right join load Month Resident Calender;
Rolling6:
load 'Current' as Type,
Month as Rolling6,
Month as Month
Resident Calender;
Concatenate (Rolling6)
load 'Rolling 6' as Type,
Month as Rolling6,
Month + 1 - IterNo() as Month
Resident Calender
while IterNo() <= 6;
right join load Month Resident Calender;
Thanks,
Niranjan
Can you share the script where you are trying this? May be we can play around with it a little?
Hi Sunny,
Good Evening
i have attached sample application when im reloading its taking more time(5 Minutes)
is there any way without selections barchart how to display rolling3 and rolling6 months
Best Regards,
Niranjan
Good evening my friend. What do you mean when you say without selection show rolling 3Months and Rolling 6Months. Can you may be elaborate.
Best,
Sunny
i have to restrict barchart only for 3months, it should display every time 3months
based on month selections chart dynamically will change, please find the image for your reference, Thanks