How can we combine two RightNow reports into one?

Content

Active day for agent value for management purposes, we want to combine the information held in reports:

• Public Reports > Service > Agent Reports > Agent Login > Agent Login
• Public Reports > Service > Chat Reports > Chat Agent Summary Status

into a single custom report to allow extra filtering such dividing a column to give the average per day.

However, simply adding extra columns to one of the reports with the same expression, e.g. adding a column in Chat Agent Summary Status using the Login Time definition from Agent Login:

sum( if ( user_trans.type = 1, date_diff( user_trans.end_dttm, user_trans.start_dttm ) ) )