I need advice on Story Reports.
I have a requirement to calculate by Employee Central event reasons out of a organization and as well as into the organization.
And it is to calculate the total movement in/ out across a selected period eg 12 month period.
How can we achieve this?
E.g i select a Division A, i need to calculate all event reasons into Div A and at the same time calculate all event reasons that resulted in a move to a position not in the Div A (ie outside)
How can this be achieved when story report applies the filter based on selected Division A?
I can do a calculated column to count the event reasons in the Div but how can i do the calculation for "outside" of that Div?
Also the story report filter can be division, department, business unit.
How can the calculation be dynamic based on the selection filter/ criteria?
Thanks & regards
Unfortunately, it is not yet possible in Story to use a filter selection within a calculation.
Below is details on something I just tried to see if it can help you get close to what you need.
Maybe you already figured this part out, but I think you will need to start your data model with the Person schema as you will likely need to duplicate the Job Information table in order to get the previous (moved out from) Division. Think change reporting if you are familiar with it.
The first version of Job Information should be set to a date range 12 months.
The second version of Job Information should not have any time filter so that it pulls all records.
You will need a calculated column to find the number of days between the start date from the first job information table and the end date from the second job information table.
In attempting this I also created calculations as follows:
Moves Within: IF Division = Previous Division, 1, 0
Moves In/Out: If Division != Previous Division, 1, 0
In your data model, you will need the following filters:
Your days between calculation mentioned above = 1, this is to identify just the previous job information records
You will probably also need to filter on specific movement events so as not to count other generic data change events as movements within a Division.
Then on the Story I created a simple cross tab with Division on the Rows (my screenshot shows Dept because I didn't have any Division changes in my instance) and my two calculated columns as the Columns.
I added a Story filter on Department (again because I only have Department changes, and no Division changes). When I then filter, I can see the number of moves into and moves within the department.
I think the part I'm still missing for you is the number of moves out of the Division.
Right now, my only thought is a separate cross tab (I understand this is not ideal), this time showing the Previous Department in the Rows and using the same measure for moves out of/into the department. But the filtering doesn't work well for the second table. Is there a strong reason you need to be able to filter to the Division?
I even played around with adding the previous department and department as second rows on each of the two cross tabs respectively to see where the moves came from/went to.
I hope this may help a little in getting you close to what you need. If you have WFA there is a WFA metrics pack that provide this information.