Need help creating the slider/calendar as an object

[#1]

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

[Gysbert_Wassenaar]

I don't quite understand what you want. Can you explain the relation between the buttons and the slider/calendar object?

[ramasaisaksoft]

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

[engishfaque]

Dear Carol,

Kindly find attached App and screenshots. I hope you are looking for that one solution.

Kind regards,

Ishfaque Ahmed