Expand my Community achievements bar.

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

View solution in original post

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