is it possible to append the output from 2 bookmarks
I have an odd problem that I'm trying to solve. I look after two teams of engineers and one of the engineers has now changed teams.
The bookmarks that I had for each of the teams are not totally accurate as all the calls for the engineer are included in both bookmarks.
What I'd really like to do is to include all calls for the engineer before Oct 1st in one teams reports (bookmarkA) and all calls after Oct 1st in his new teams reports (bookmarkB).
I was hoping to be able to do this without having to re-write the SQL or creating separate dashboards for the two teams...I'd like to be able to keep all the data in the same table and find some way to separate the calls out before a date for one team and after a date for the other team.
So I'd like to have for one team (engineer1 AND engineer2 AND engineer3 AND (if call date < 01/10/2013 engineer4)) and for the other team (engineer5 AND engineer6 AND engineer7 AND (if call date < 01/10/2013 engineer4))
I was thinking I may be able to do something with bookmarks...but dont know if it would be possble to append the output from two bookmarks.
Perhaps you can use set analysis expressions. Suppose you have an expression count(TicketID). You can change that to count({BM1+BM2} TicketID) to combine the selections from two bookmarks named BM1 and BM2.
