How to guide - create a set showing all dates this year.

Using super Superstore dataset:

Navigate the Order Date, select the drop down and choose 'Create', then 'Set'.

It's important to remember we want this set to be Dynamic, so that when we have new data imported in, this set will adject with the new dates. We do this by creating a formula with our dates instead of manually selecting all the dates for the year you're wanting to show. In this case, we want all dates this year (2023).

Formula: YEAR(today( ) )=YEAR( [ORDER DATE] )

Author:
Alexandra Skelly
Powered by The Information Lab
1st Floor, 25 Watling Street, London, EC4M 9BR
Subscribe
to our Newsletter
Get the lastest news about The Data School and application tips
Subscribe now
© 2024 The Information Lab