Exercise 33

Create the transformation, as shown in the screen capture:

Exercise 33

Then create the metric:

Exercise 33

Place the Date attribute on rows, metrics on columns, and page-by year.

Get Business Intelligence with MicroStrategy Cookbook now with the O’Reilly learning platform.

O’Reilly members experience books, live events, courses curated by job role, and more from O’Reilly and nearly 200 top publishers.