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

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

mbkass
Level 2
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
ramon_bisswanger
Correct answer by
Employee
Employee

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

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