Need to create data visualization based on old assignment group value

[priyakosana]

A single data visualization, for every HR case that is assigned to GroupA (or was assigned to GroupA at some point), shows the HR Case number, Current Assignment Group, Previous Assignment Group, transfer timing metrics (transfer to/from date and time or time each group had the case), and cycle time (how long the case remained open before resolution). 

[Tanushree Maiti]

Hi @priyakosana 

To achieve your requirement , you must leverage the platform's Metric Definitions or build a Database View

Refer : How to run a Report of List View of HR Cases including the previous Assignment Group 

[Ankur Bawiskar]

@priyakosana 

you can refer OOTB metric definition for Assignment group on HR Case table

Then use metrics table in your data visualization

💡 If my response helped, please mark it as correct ✅ and close the thread 🔒— this helps future readers find the solution faster! 🙏

[priyakosana]

I have referred that but the thing is that the metric instances doesn't store the old assignment group value, for every change in the group value it is storing new value

[Ankur Bawiskar]

@priyakosana 

then with metrics this is not possible

you might have to store the old group and changes to it in some custom table and then use it for reporting

💡 If my response helped, please mark it as correct ✅ and close the thread 🔒— this helps future readers find the solution faster! 🙏