You need to find a way to filter the first visual from Dashboard 3 using the selection of years from the second visual (from 2000 until 2011). What I did was to select first Canada so I can have only one line in the second visual, set the second visual to be used as a filter and select all the years from 2000 until 2011. After that if you hover the circle in the first visual you will have your answer.
You’ll need to create the filter in the drop down menu in the second chart with years and specify 2000-2011 and then go to that filter at the top right. Using the drop down arrow, say it should apply to ALL worksheets using this data source. What happened is that we click Canada and see that it is 15.74 when it is really 16.43 with the date filter.
Your answer guide says question #1 is ‘C’ but when I test my answers it tells me it’s wrong and ‘B’ is correct.
Hi John,
Thanks for noticing that. We will correct that as soon as possible. The right answer is in the solution guide 🙂
Best regards,
Narcis
Could you explain the CO2 question please. I am a little confused.
Hi Lesbia,
You need to find a way to filter the first visual from Dashboard 3 using the selection of years from the second visual (from 2000 until 2011). What I did was to select first Canada so I can have only one line in the second visual, set the second visual to be used as a filter and select all the years from 2000 until 2011. After that if you hover the circle in the first visual you will have your answer.
Hope this helps,
Narcis
You’ll need to create the filter in the drop down menu in the second chart with years and specify 2000-2011 and then go to that filter at the top right. Using the drop down arrow, say it should apply to ALL worksheets using this data source. What happened is that we click Canada and see that it is 15.74 when it is really 16.43 with the date filter.