6/12/2023 0 Comments Javascript get current year![]() ![]() Note: This blog was written on April-15-2018. We will be considering a sample data file for this example that is created for all days from Jan-1-2017 to Dec-31-2018 with some random values. those from last year until today (including today). In essence what we are trying to do is simply evaluate the YTD (Year to Date) for the CY (Current Year) Vs. the PY (Previous Year) – note, there are different methods to do this and we will be discussing two type of calculations. ![]() In this blog, we will be comparing values from this year Vs. The list goes on as long as there is data. Department of Education tries to improve the education system by encouraging more children to be educated thus hiring more teachers and providing better infrastructure.Retail markets look for improvement in customer loyalty and product quality.Department of Homeland Security strives every year to reduce the number of illegal immigration cases.Air travel companies look for increase in passenger traffic thus driving the revenue.Police Departments introduce stricter measures every year to see decrease in crime rates, be it speeding tickets, petty crimes, theft etc.These questions ultimately lead to the most important questions i.e.Į) Why is this factor causing a decrease?į) What should we focus on to improve and propel in the forward direction? Today, most C-level suite or VP/Managerial workforce are looking for answers to questions like:Ī) How did we perform this year compared to the last year?ī) How much have we grown as a business from when we started the venture?Ĭ) Where do we stand against our own values with respect to the previous quarter or previous month or previous week? Metrics on a Tableau Dashboard play a major role in reporting – especially when comparing values across time, with the most common being Year over Year growth.
0 Comments
Leave a Reply. |