Hello, everybody. Welcome to the second dashboard. In this video we will learn how to create this dashboard using macros. Now what does it do? Here we have all the jobs available, say for example admin. So what the chart represents is the trend based on admin across the world, and the overall trend.

So the gray dots and the trend line shows you the overall trend for the world. And the current blue line shows you the current trend selected for admin. The second chart also has a feature called country, we can select the country we're looking for. So if I select the US it automatically the chart displays the data for the US and it shows me the overall result. It also shows me result for the US as well. That is average maximum and minimum.

And at the top we do see the recruitment numbers across the world. We also have a spiderweb chart with shows the maximum requirement minimum requirement for the respective work for the respective location and we can also see average across the country for average result for admin in the US. Now this is created using a bit of macros and a bit of functions. In the upcoming videos we will learn how to create this dashboard. Until then, keep practicing, keep learning