Need help to finely filter some information please.

[gennaroalpha7]

Hello Teachers -

I have a report that I am trying to filter tickets from the group BWHelpDesk.

I want tickets that have only the assignment to the group BWHelpdesk. I am getting tickets that have an assignment to BWHelpDesk, but some of the tickets have assignments to other groups as well. Tickets can have multiple assignments.

I am using the record selection to filter the records from the group BWHelpdesk. I have nothing in the group selection. I also have in the details section expert to filter duplicate records.

How can I ensure I get tickets that are only assigned to the BWHelpdesk group?

Thx.

G.

 

[pmax9999]

Please post your record selection formula.

Pete

 

[gennaroalpha7]

Hello Pete -

Here's the record selection...there is code in here because this is a quarterly report.

Thanks for your help.

G.

{Asgnmnt.GroupName} = "BWHelpdesk"

and

{CallLog.RecvdDate} >= totext(date
(
year(dateadd("q", -1, currentdate)),
if month(currentdate) in [1,2,3] then 10 else
if month(currentdate) in [4,5,6] then 01 else
if month(currentdate) in [7,8,9] then 04 else
if month(currentdate) in [10,11,12] then 07,
01
),'yyyy-MM-dd') and
{CallLog.RecvdDate} <= totext(date
(
year(dateadd("q", -1, currentdate)),
if month(currentdate) in [1,2,3] then 12 else
if month(currentdate) in [4,5,6] then 03 else
if month(currentdate) in [7,8,9] then 06 else
if month(currentdate) in [10,11,12] then 09
,

if month(currentdate) in [1,2,3] then day(dateadd("d", -1, date(year(currentdate), 01,01))) else
if month(currentdate) in [4,5,6] then day(dateadd("d", -1, date(year(currentdate), 04,01))) else
if month(currentdate) in [7,8,9] then day(dateadd("d", -1, date(year(currentdate), 07,01))) else
if month(currentdate) in [10,11,12] then day(dateadd("d", -1, date(year(currentdate), 10,01)))
),'yyyy-MM-dd')

 

[pmax9999]

The simplest way, although certainly not the most efficient, would be as follows:
[ol 1]
[li]Remove the line {Asgnmnt.GroupName} = "BWHelpdesk" from the Record Selection formula;[/li]
[li]Add the following code as the Group Selection formula:[/li]
[/ol]

{Asgnmnt.GroupName} = "BWHelpdesk" and
DistinctCount({Asgnmnt.GroupName},{Table.TicketNo}) = 1

This approach assumes that the records are grouped on {Table.TicketNo}; you will need to amend the table/column name in the code above to reflect the actual name.



Hope this helps.

Pete

 

[gennaroalpha7]

Hey Pete -

Thanks. I have a question. If the coding was like this instead of the way you have it, would it matter?


DistinctCount({Asgnmnt.GroupName},{Table.TicketNo}) = 1
and
{Asgnmnt.GroupName} = "BWHelpdesk"


Thx.

G

 

[gennaroalpha7]

Hi -

There are still tickets showing on the report that have assignments to other groups. On the first two pages there were at least 10 out of 36 tickets.

There is another field that could strengthen the search critereia/selection. It is the Asgnment.Assignee field. The people that are in the BWHelpDesk group can be assigned to this field. Would this help?

Thx.

G.