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

How to pull report entries when one column is blank for certain rows?

in Reporting & Analytics for B2C Service 2 comments

Summary:

I'm building a report showing certain incidents, and I'd like to include the most recent thread entry in the report. The challenge is, I have many incidents without thread entries and those do not show on the report.

I tried if(length(treads.notes)>0, thread.notes, "no notes"), but only items with notes return in the report.

How do you add a column that can be blank?

Tagged:

Howdy, Stranger!

Log In

To view full details, sign in.

Register

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