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

SOLVED

Dynamic Day counter

march63855757
Level 1
Level 1

I am looking for a way to create a ‘Summary Number’ or ‘Text’ field in Adobe Analytics Workspace that will count the number of days passed since the start of a Adobe Target test, is this possible?

 

So in the example below, the start date of the test was 11th Feb. I want to create another ‘Summary Number or Text Box’ that would show ‘The Number of Days The Test Has been Running’. It would work dynamically from today’s date. So the entry for today (24th Feb) would be ’13 days’. Is this possible?

 

march63855757_0-1614171897643.png

 

1 Accepted Solution
yuhuisg
Correct answer by
Community Advisor
Community Advisor

Here's one way:

  1. Ensure that your panel's date range is for your experiment's dates.
  2. Add a freeform table.
  3. Drag the "Day" dimension into the table. Delete the "Occurrences" metric.
  4. Add a new metric to the table, using the formula "Row Count ()". You should end up with the same number in all rows.
  5. Create a Summary Number visualisation from the metric in the first row.

The Summary Number should now show the number of days that your experiment has been running for.

View solution in original post

2 Replies
yuhuisg
Correct answer by
Community Advisor
Community Advisor

Here's one way:

  1. Ensure that your panel's date range is for your experiment's dates.
  2. Add a freeform table.
  3. Drag the "Day" dimension into the table. Delete the "Occurrences" metric.
  4. Add a new metric to the table, using the formula "Row Count ()". You should end up with the same number in all rows.
  5. Create a Summary Number visualisation from the metric in the first row.

The Summary Number should now show the number of days that your experiment has been running for.

View solution in original post