Thank you for supporting the Cloud Customer Connect Community in 2024. It's a gift to work with you!

Look back
You're almost there! Please answer a few more questions for access to the Applications content. Complete registration
Interested in joining? Complete your registration by providing Areas of Interest here. Register

Need help with expression needed to display timestamp for certain attribute

edited May 26, 2021 7:50PM in Reporting & Analytics for B2C Service 4 comments

Content

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:

Howdy, Stranger!

Log In

To view full details, sign in.

Register

Don't have an account? Click here to get started!