Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
I am creating a dashboard that will be using a rolling calendar. How do I create a new slider/calendar object with the monthly, quarterly and yearly buttons as pictured below
Any documentation / examples / videos are greatly appreciated.
Thank you in advance for your help. 🙂
Carol
I don't quite understand what you want. Can you explain the relation between the buttons and the slider/calendar object?
Hi Carol,
For these buttons you need to create a master calendar in script
Let VarMinDate = Num(Peek('OrderDate',0,'OrdersQuery'));
LET VarMaxDate = num(peek('OrderDate', -1, 'OrdersQuery'));
LET VarToday = num(Today());
TempCalendar:
LOAD
$(VarMinDate) + RowNo() -1 as DateNum,
Date($(VarMinDate) + RowNo()-1 ) as TempDate
AutoGenerate
$(VarMaxDate) - $(VarMinDate);
MasterCalendar:
LOAD
TempDate as OrderDate,
Week(TempDate) as Week,
Year (TempDate) as Year,
Month(TempDate) as Month,
Day(TempDate) as Day,
WeekDay(TempDate) as WeekDay
Resident TempCalendar;
DROP Table TempCalendar;
then call the variables into buttons
Dear Carol,
Kindly find attached App and screenshots. I hope you are looking for that one solution.
Kind regards,
Ishfaque Ahmed