topic Comparing to a specific month in SAS Visual Analytics https://communities.sas.com/t5/SAS-Visual-Analytics/Comparing-to-a-specific-month/m-p/722506#M14681 <P>In the post-COVID world there is a lot of interest in where jobs have been lost or gained. I have access to the industry data for this in SAS VA but am not able to work out how to compare industry job numbers to a fixed month i.e. February 2020 which is the data before COVID really impacted.<BR /><BR />As the current months data is loaded the comparison needs to be most recent month compared to Feb 2020.<BR /><BR />A comparison to an annual relative period doesn't work (except for February) as the comparison point stays fixed.<BR /><BR />The data in VA has the following formats<BR />Industry&nbsp; Accommodation<BR />Month 02/2020<BR />Total jobs 67308<BR /><BR />As the jobs are both lost and gained I would also like to show a top 30 based on absolute values - if this can't be done I can do two graphs lost jobs and increased jobs.</P> Sun, 28 Feb 2021 22:48:09 GMT Noel88 2021-02-28T22:48:09Z Comparing to a specific month https://communities.sas.com/t5/SAS-Visual-Analytics/Comparing-to-a-specific-month/m-p/722506#M14681 <P>In the post-COVID world there is a lot of interest in where jobs have been lost or gained. I have access to the industry data for this in SAS VA but am not able to work out how to compare industry job numbers to a fixed month i.e. February 2020 which is the data before COVID really impacted.<BR /><BR />As the current months data is loaded the comparison needs to be most recent month compared to Feb 2020.<BR /><BR />A comparison to an annual relative period doesn't work (except for February) as the comparison point stays fixed.<BR /><BR />The data in VA has the following formats<BR />Industry&nbsp; Accommodation<BR />Month 02/2020<BR />Total jobs 67308<BR /><BR />As the jobs are both lost and gained I would also like to show a top 30 based on absolute values - if this can't be done I can do two graphs lost jobs and increased jobs.</P> Sun, 28 Feb 2021 22:48:09 GMT https://communities.sas.com/t5/SAS-Visual-Analytics/Comparing-to-a-specific-month/m-p/722506#M14681 Noel88 2021-02-28T22:48:09Z