Your achievements

Level 1

0% to

Level 2

Tip /
Sign in

Sign in to Community

to gain points, level up, and earn exciting badges like the new
Bedrock Mission!

Learn more

View all

Sign in to view all badges

Date calculation functions

Avatar

Level 3

11-04-2022

Description - Saw a Summit session about tracking progress to goal using cumulative functions (which I'd never used before honestly).  While doing it I realized Adobe, for all it's functions, does not have date calculation functions.  So you could do, say a calculate of the different between today and Jan 1 and then be able to display how many days in the year have elapsed or calculate the % of year elapsed.  I've see some of this done using the rowcount function but then you need to have all your table rows displayed all the time, which is a pain.

Why is this feature important to you -  I'd like to really leverage goal progress more in dashboards and this would really help show where we are today vs where we should be.  I could calculate the YTD % of days and dynamically multiply it by my goal to easily displey where we should be TODAY vs where we actually are

How would you like the feature to work - In the calculated metric column, add a new function DateDiff that can caluclate the number between two days (fixed or dynamic)  This is already used in the rolling date ranges function for time segments.

Current Behaviour -  Only way to simulate this (I know of( is with lots of tables with rowcount functions but only works if all your metrics need the exact same number of rows.

1 Comment

Avatar

Level 5

19-04-2022

That sounds like a cool session to watch 😋 You could use the Count Distinct function to count the number of days as described here: https://www.fullstackanalyst.io/blog/adobe-analytics/cool-approximate-count-distinct-use-cases-adobe...

Those counts will be approximate, so slightly off from the real value.