Need help with expression needed to display timestamp for certain attribute
So I am trying to build a report using the transactions table that will tell me when the status changed on a task to 'on route' and 'onsite'. We are trying to gather data on travel times for our engineers.
I assume that I will have a filter for the transactions table to only show me transactions.trans_type = 'Status Changed' but what expression would i use to return the time (transactions.created) of attribute1 (transactions.id1)
Attributes are as follows:
On Route = 102
Onsite = 108
I can accomplish this using multiple lines for each attribute but I am trying to get the timestamps for both on the same line of the report. What I am trying to get would be something like this: