Select a date and time range to filter your dashboards:

1.Elasticube Model

The goal here is to convert the date & time field you wish to filter by to a BIGINT in the format (YYYYDDMMHHMMSS). Let's break that down.

Choose your date & time field to convert.
Create a new custom column in the same table.
Convert the date & time field to a Bigint with the format (YYYYDDMMHHMMSS).
Your values should not have '/' or '-'. If you have these characters, they will need to be parsed out.

Example:

In this example we will be converting the [Time] field into a custom column [FilterDate] as a BIGINT. **Note: Your date formats can vary so the method to convert will vary.

-- Changing datatype to  bigint

tobigint(

--formatting date

replaceall(StrParts(tostring([Time]), ' ',1),'-','')  +

-- formatting time             

replaceall(left(SubString(tostring([time]),12),8),':',''))

2. Create new blox widget to dashboard

Upload blox template. Download link below:
https://drive.google.com/file/d/1i142Oh8cY2wUqK62l-2hNzuMt6fOtKSj/view?usp=sharing

3. Create a new custom action

Copy and paste the Javascript code found in below txt file into the custom action editor
https://drive.google.com/file/d/1UmD4a9tHr1iiKXYBpVWdnnGNpKtxl3OS/view?usp=sharing
Give action a name, press next and save the new action.
Copy the name of the new action

Click the Editor tab
Scroll to the actionset and under actions, change the type to the name of the action you created

4. Add the FilterDate you created in the model to the values panel.

5. Click filters tab in widget, ensure dashboard filters is disabled.

6. Add FilterDate to the dashboard filter panel.

When adding this filter, go to the values tab,
And select the 'between values' option
Press ok

That’s it, now select a date & time in the picker and press the filter button

Konstantinos Anagnostou February 07, 2020 14:48

Kaitleen Crowe I followed your instructions step by step but the filter button is not working. Any ideas why? Do I maybe need ot change anything else in the blox editor tab?

Thanks,

Kostas

Konstantinos Anagnostou February 28, 2020 08:51

With help of the Sisense suppor tteam the widget works now. BUT I have an assumption that it works without the custom action described above. The creator of this widget should have a look

Paul Furman April 08, 2020 04:22

Great approach!

How about complicating it and using "To" from a different field, i.e. if I have StartDate and EndDate fields and I need to filter in between.

Hemlata Mingwal December 20, 2020 21:06 (Edited December 20, 2020 21:07)

Hi @Kaitleen Crowe,

Can you please share google drive access to hemlatamingwal2015@gmail.com.

Hemlata

Select a date and time range to filter your dashboards:

Comments

Didn't find what you were looking for?