Story reporting - Last Trans Seq

[Mirjam]

Hi all,

I hope you can help me with an issue I'm encountering in a transfer report based on event reasons from the job information table.

I have some duplications in my story table due to the double use of an event reason. In the canvas report, I could use the field 'Last Trans Seq.' However, this field isn't available in the story report. How can I ensure that I have the last sequence in the report to avoid duplication in story reporting?

Example of the double event use

Thanks

Mirjam

[Olga_Antipina]

Hi Mirjam, There is no similar functionality ('Last Trans Seq.') in Stories. It is quite hard to show only the latest transactions, there are no settings to do it easily. Can you mayve set some filters on Event start and end date? This might help you to exclude some older changes.

[Olga_Antipina]

"Effective Latest Change" works only for transaction done during 1 day, not useful for a longer period. However, as Jeroen said, you can try to use a filter on "Promotion" event reason + Date range filter (e.g. year, month etc). Hopefully, there won't be multiple promotions per person during the chosen period.

[JeroenA · Accepted solution]

Hi Mirjam,

In Stories the filed is called different. It's called "Effective Latest Change" which will show a "Y" for the latest transaction in case there are multiple transactions on one day.

Kind regards,

Jeroen

[Mirjam · Accepted solution]

Hi, Jeroen. Unfortunately, this option won’t work because the purpose of the graph is to display only promotions. If I enable the option Y in the Graph, it will look all events reasons from the job information, which would exclude relevant data. The Promotion event is not always the last event.

[JeroenA · Accepted solution]

Hi Mirjam,

Your question was about the Last Transaction Seq. In Story Reports this field is called Effective Latest Change and has exactly the same function as Last Transaction Seq in canvas Reporting.

In case you only want to capture Promotion Events then I suggest working with a Data Range filter and apply a filter on the Event = "Promotion". As an alternative you can create a change report where you focus for example on Pay Grade Change or an other field change that indicates that someone has been promoted. 

Kind regards,

Jeroen