Set analysis

[0li5a3a]

Hi All,

I would like to use set analysis to do some calculations.

First calculation:

I need to  count  the total of incidents where the creator group is the same like the resolve group.

i used this :

=count({<CREATORGROUP = {'Intern'} ,RESOLVEDGROUP ={'Intern'}>}Incident)

Could someone confirm if this is right or no, because is looking that is not right.

Second calculation:

I want to count the total of incidents where the creator group is different then resolve group.

i tried this:

=count({<CREATORGROUP = {'Intern'} <> RESOLVEDGROUP ={'Intern'}>}Incident)

Regards,

C

[sunny_talwar]

May be these

=Count({<Incident = {"=CREATORGROUP = RESOLVEDGROUP"}>}Incident)

=Count({<Incident = {"=CREATORGROUP <> RESOLVEDGROUP"}>}Incident)

[0li5a3a]

Hi Sunny,

Thank you for your answer but I need  just a specific group like below

=Count({<Incident = {"=CREATORGROUP= {'Intern'}= RESOLVEDGROUP={'Intern'}"}>}Incident)

=Count({<Incident = {"=CREATORGROUP= {'Intern'}<> RESOLVEDGROUP={'Intern'}"}>}Incident)

But using  nothing is displayed.

Regards,

C

[sunny_talwar]

Can you show few rows of data.... I can make the first one work (equal), but not sure I understand they are not equal, but they both are Intern? What does that mean?

[Anonymous]

perhaps:

=Count({<Incident = {"=CREATORGROUP= {'Intern'}, RESOLVEDGROUP-={'Intern'}"}>}Incident)

[0li5a3a]

LOAD * INLINE [

    Incident, CREATORGROUP, RESOLVEGROUP

    1, Intern, Intern

    2, Intern, Extern

    3, Intern, Extern

    4, Intern, Intern

    5, Intern, Intern

    6, Intern, Extern

    7, Intern, Extern

    8, Intern, Extern

    9, Intern, Intern

    10, Extern, Extern

];

This is my data and I need to count  for ex : the total of incidents where the Creator is Intern and the 'Resolver' is 'Intern'. And the second request is to count all the tickets created by Intern and resolved by someone else.

Regards,

C

[0li5a3a]

I tried but this doesn't works:(

[Anonymous]

and that?:

=Count(

{<

     CREATORGROUP= {'Intern'}, RESOLVEDGROUP-={'Intern'}

>}

Incident)

[tresesco · Accepted solution]

R1: =Count({<CREATORGROUP={'Intern'}, RESOLVEGROUP={'Intern'}>}Incident)

R2: =Count({<CREATORGROUP={'Intern'}, RESOLVEGROUP-={'Intern'}>}Incident)

[0li5a3a]

Thanks for you help