Vizlib default date

[stekol61]

Hi!

I use the Vizlib calendar extension in an app.

I want the app when open to present data for the previous 5 days .

I use the "Initial Selection" and can set a "Initial Start Date".

What should the formula be in order to present the previous 5 days?

[groveliam]

and you can always replace those "max(dateField)" with "Today()"

[stekol61]

Hi!

A little bit complicated but I will try.

Where do I create variables in Sense?

[stekol61]

Hi!

I guess this is the way to do it:

SET d1 = Date(max(Date)-1, 'YYYY-MM-DD');

SET d2 = Date(max(Date)-2, 'YYYY-MM-DD');

LOAD

Week (Date)as Week,

    Country,

    "Answered Calls",

    Date((Date),'YYYY-MM-DD') as Date,

    %CALENDARID

FROM

I then added: $(d1) in the Vizlib filter.

This works OK, but if I add $(d1), $(d2) it dosn't work

[Giuseppe_VizLib]

Hello!  🙂

You may reach us at support@vizlib.com 

or you can open a ticket after you login to our User Portal.

You can also evaluate as a free trial, by downloading and installing our Vizlib June 2019 Release.

regards

Giuseppe

Vizlib Customer Success Manager

[Giuseppe_VizLib]

I was actually taking a look at this, and will let you know ASAP

[Giuseppe_VizLib]

Hello,

there is a functionality under the section called INTERACTIVITY.

The setting is called INITIAL SELECTION

regards

Giuseppe