Report bringing duplicate INCs and RITMs

[PhFranca]

Hey guys!

Is there a way to bring only one ANS definition per call?
In some calls I have the OLA type, in other calls I have the ANS type. In other calls, I have the OLA type and the ANS type. I would like the calls not to be repeated.
So, instead of returning two lines with the same call, I would like it to return just one line.

[AndersBGS]

Hi @PhFranca ,

Only option as I see it is to enhance the condition to only show e.g. the once that are completed, only show ANS, only show OLA etc. As you are utilizing the task_sla table, then an incident can contain multiple ANS/OLA.

If my answer has helped with your question, please mark my answer as accepted solution and give a thumb up.

best regards

Anders 

[PhFranca]

Hi AndersBGS!

I understood! As I am using the task_sla table, an incident can contain several ANS/OLA. But is it possible to create a condition such as IF? IF INC or RITM for OLA 'AND' ANS, select only the ANS? Or if it's just OLA, select just OLA?

What I don't want is for it to contain multiple ANS/OLA, just have one.

You mentioned that: "Only option as I see it is to enhance the condition to only show e.g. the once that are completed, only show ANS, only show OLA etc."

To improve this condition, can you explain it to me?
I tried to replicate it, but I couldn't.

Thank you very much in advance for your time!

[AndersBGS · Accepted solution]

Hi @PhFranca ,

Sure, let me explain a but further. You can't create a condition as you mentioned "IF INC or RITM for OLA 'AND' ANS, select only the ANS? Or if it's just OLA, select just OLA?" Instead you can create conditions like.

Type is OLA

Definition is XXX

Stage is completed. 

Afterwards, you can add another dataset to the report with below condition

Type is ANS

Definition is XXX

Stage is completed.

Please note that there can off course be several further conditions to be added, so all based on you instance setup.

If my answer has helped with your question, please mark my answer as accepted solution and give a thumb up.

best regards

Anders