Expand my Community achievements bar.

Webinar: Adobe Customer Journey Analytics Product Innovations: A Quarterly Overview. Come learn for the Adobe Analytics Product team who will be covering AJO reporting, Graph-based Stitching, guided analysis for CJA, and more!
SOLVED

Dynamic Day counter

Avatar

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

Avatar

Correct answer by
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

Avatar

Correct answer by
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.