Creating a chart for rolling figure in date format
Hi all, I have built a employee turnover metric that looks at average headcount and total leavers in a 12 month timeframe. To get the % figures I have built a Date Table that when I slide the start and end period of each month it returns me the complete breakdown of the data I need. Rolling Turnover % (Total) = DIVIDE([Rolling Leavers (Total)],[Avg Monthly Headcount (12M)],0) However, when reporting on trends it makes it difficult as I have to move the date table periods each time to the 12 month outlook I need. For example for December 2024 I need to put 01/01/2024 - 31/12/2024, for January 2025 it would be 01/02/2024 - 31/01/2025. The Date Table is linked to my main staff file, which has each month of the period 01/2024, 02/2024 etc, and then linked also to my exits table that has the last day per individual. This gives me exactly what I need but it would be very helpful to try and investigate if there is a way to add to this to be able to build some charts over time to better understand trends. Appreciate I may be lacking a lot of info still required, will try my best to share anything that is not clear. Kind regards,
Trend Analysis
Hi Guys, Asking the community for help, I've a coloumn which has inconsitent data however it has keywords which i'll be using in the "cards" for visualization such as "ABC" and "XYZ". So when I click on the card "ABC" the "clustered bar chart" should change according to the data and show the trend. I was thinking to seperate the column with all "ABC" in one column and "XYZ" in another" however I am finding it impossible to do it as has 20k+ rows and too many words/letter/delimiters in between "ABC" and "XYZ". Sample data is below Can you guys help please? Any help is greatly appreciated. Margins ABC 10days ABC XYZ 64 minutes ABC Remote work Internal Job ABC External Job XYZ ABC half 2020 New postpaid work
