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

Expression using last function with threads channel id

Received Response
1
Views
6
Comments

Summary:

Hello all,

I have a report with some incidents.

My goal is to add a column to this report and display a custom value in it based on last threads channel id. For example: threads.chan_id = 5. So my expression would look like this: if(last(threads.chan_id = 5,'value1','value2'))

The main table is Incidents that is joined to threads table.

I tried paying around but still did not managed to make it work. The main problem is that I need to take into consideration just the last threads channel with id 5. I also found an article about

Howdy, Stranger!

Log In

To view full details, sign in.

Register

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