Forum Discussion

ETL

12-21-2023

Filter a BloX widget to the same day of the week a year ago

We have a requirement to filter a BloX widget to the same day of the week a year ago. Example: The dashboard filter is selected to Friday 11/24/2023 We want a particular widget to be filtered ...

Blox

Silutions

ETL

12-22-2023

Benji,

Thank you for this. I have tried on BloX and with Pivots. I followed your instructions. No joy. Can you send me your BloX templates from your example? With those I should be able to figure it out.

Regards, Jim

Benji_PaldiTeam

Data Pipeline

12-26-2023

Attaching the Blox template for your reference.

Also here is the summary of steps:

Add Date dashboard filter (level = Days). Make sure to select only one day at a time.
Create Blox with attached template.
Add Date widget filter to Blox (level = Days). and select any random date
For the attached Blox template, add Date dimension under 'Items' panel. One with level Days and other with level Weeks