Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi all,
I've a problem with the slider object. The purchases and sales data has a corresponding date. What I want is to create an slide in which only to select months, not days. I've created an slider and link it to the date field but if I move the selector, the selection is for only 1 day and what I want is to select the month, what can I do?
Thanks for your time and sorry my bad english.
Greetings,
Miguel.
Hello Miguel,
instead of using the date field itself, you can use an expression derived from this field. See Slider properties --> general tab --> pull down menü ---> choose last entry (in english: <expression>). Then you are able to input an expression similar to
=Year(SalesDate & '-' & Month(SalesDate)
Another (better) way would be to create this "rolling MonthYear" as a seperate field within your loadscript.
Regards, Roland
Hello Miguel,
instead of using the date field itself, you can use an expression derived from this field. See Slider properties --> general tab --> pull down menü ---> choose last entry (in english: <expression>). Then you are able to input an expression similar to
=Year(SalesDate & '-' & Month(SalesDate)
Another (better) way would be to create this "rolling MonthYear" as a seperate field within your loadscript.
Regards, Roland
Thank you Roland! It works! I've tested the expression and it works perfectly.