Calculate and display failure rate based on a "keyword" field

[zebu14 (xavier)]

Hello,

For a MFT platform, each transfer is tagged with a status_code, based on letters "E" for Ended, "C" for Canceled.

I have to find out the partners with high failure rates over time.

Do you have an idea on how to calculate (and use in visualizations ) the failure rate for each partner, based on the status contained in each doc ?

Example message (the status code is in 5th position) :

"1","I","R","230615 151102","E","0","431","SFTP","EE0F9","GREENTRF","transfer/IN/opaxvgw3","1283223-EE0F9","SFTP_B","$S_EE0F9","GREENTRF","230615 151102","230615 151102","0"

Thank you

[lukas (Lukas Olson)]

Is this message a single field in your document, or do you have separate fields for each code?

[zebu14 (xavier)]

This is a single field.
Here is the mapping if it helps

"1","I","R","230615 151102","E","0","431","SFTP","EE0F9","GREENTRF","transfer/IN/opaxvgw3","1283223-EE0F9","SFTP_B","$S_EE0F9","GREENTRF","230615 151102","230615 151102","0"
"type","direction","mode","date","status","code","size","protocol","source","target","path","file_id","appli_id","source_id","target_id","date_begin","date_end","retries"

[zebu14 (xavier)]

No idea ?