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

The 4th edition of the Campaign Community Lens newsletter is out now!
SOLVED

Pivot Delivery Summary dynamic report by "Week" + Specific Country

Avatar

Level 2

I am able to take the delivery summary report that contains any metric of my choice (sends, opens, clicks, etc) and pick a dimension like "week" in order to see all email channel metrics by week over a specific time period (e.g. one year). However, I would like to pick a specific country (e.g. Japan) and see those weekly results, instead of seeing it for all countries. 

 

I could take the country dimension and place it inside each week, but that would end up showing me results for all 200+ countries per week, which is overwhelming. Is there a way to pick a specific country and filter the weekly results?

Topics

Topics help categorize Community content and increase your ability to discover relevant content.

1 Accepted Solution

Avatar

Correct answer by
Employee Advisor

Yes, you can filter the list:

  • Drag country dimension into the report
  • click on Japan to select the row
  • Then right-click and choose "Display only selected rows"
  • This should now filter the report accordingly
1 Reply

Avatar

Correct answer by
Employee Advisor

Yes, you can filter the list:

  • Drag country dimension into the report
  • click on Japan to select the row
  • Then right-click and choose "Display only selected rows"
  • This should now filter the report accordingly