Explanation

Explanation
Open Regional Dashboard twbx file, and select the region as Northeast and state as New York:


Hover the trend line of Obesity correlation with exercise chart, 0.57 percentage of average obesity increases when 1% average increase in the physical inactivity in theNortheast Region.
However, we have to find out for the New York State. Currently, when you have selected the New York state, the trend lines have not been recalculated.
To recalculate it, right-click on the trend line and click on Edit All Trend Lines:

In Trend Line Options, select the Show recalculated line check box:

Hover the trend line of Obesity correlation with exercise chart, 0.40 percentage of average obesity increases when 1% average increase in the physical inactivity in theNew York Statein the Northeast Region.

Add the Country population excel sheet as a New Data Source.
Select column 1960 to 2013, click on Pivot.
Graphical user interface, application Description automatically generated

Rename the new fields as Year and population.
Go to Data ->Edit Blend Relationship
Click on Custom and Add
Graphical user interface, text, application Description automatically generated

Ensure the blend relationship exists in Country & Country Name, and year & year between primary and secondary data sources.
Drop the year to the filters shelf and only enter 1963.
Graphical user interface Description automatically generated

Drop Country and Number of Records / volerup(Count) field to the view.
And drop population to the view from the secondary data source. Your view will look like this:
Graphical user interface, text, application, chat or text message Description automatically generated

Explanation
Drop the Country field to the view.
Drop the Region to the filters shelf and select Europe & Central Asia.
Drop the GDP per capita to the label and change the aggregation to Avg.

Create a Calculation to get the first alphabet of the customer name.
Graphical user interface, text, application Description automatically generated

Now drop the First Alphabet field to Rows and Quantity field to the Text on the Marks card. Change the aggregation from SUM to AVG. Your view will look like this: