You should be in the View mode after refreshing your Instaview. With a newly updated model, it is a good idea to test model changes by creating a new analysis. The analysis created in the following exercise will validate that our measures are correctly aggregating across the Referringurl
dimension:
Click on the New Analysis button.
Drag all three measures,
Event Count
,Session Count
, andSession Duration
, to the Measures drop zone in the Layout section.Drag
Referringurl
to the Rows drop zone in the Layout section.Click on the Report Options button, checkmark Show Grand Totals for Columns, and then click on OK.
Right click on the Session Duration column header and choose Subtotals from the right-click menu options.
Uncheck the default Sum aggregation and check Average.
Click on OK.
Your table values should match those in the following figure:
Click on the Save View button and name the visualization...