See what status type an incident had at a particular time?
Content
Hi,
Currently using this formula but it's using the status and not status type (Solved, Unresolved, Waiting etc)
last(if(transactions.trans_type='Created', 'New', if(transactions.trans_type='Status Changed' & transactions.id1=102,'Pending',if(transactions.trans_type='Status Changed' & transactions.id1=8,'Updated',if(transactions.trans_type='Status Changed' & transactions.id1=3,'Pending Information',if(transactions.trans_type='Status Changed' & transactions.id1=2,'Resolved at Tier 1',if(transactions.trans_type='Status Changed' & transactions.id1=103,'Resolved at Tier 2','-')))))), transactions.created)
Any idea how I could see what status type an incident had at a particular time?
Code Snippet
last(if(transactions.trans_type='Created', 'New', if(transactions.trans_type='Status Changed' & transactions.id1=102,'Pending',if(transactions.trans_type='Status Changed' & transactions.id1=8,'Updated',if(transactions.trans_type='Status Changed' & transactions.id1=3,'Pending Information',if(transactions.trans_type='Status Changed' & transactions.id1=2,'Resolved at Tier 1',if(transactions.trans_type='Status Changed' & transactions.id1=103,'Resolved at Tier 2','-')))))), transactions.created)
Tagged:
0