Multiple Selection/Condition Set Analysis

[#1]

Hi.

My problem is with Setting two conditions in Set Analysis.

Case Scenario: Calculate Tickets updated today.

Objects : GroupID , Updated Date

Requirement : Show total count for Tickets updated today and assigned to Group 15.

What is working is to show total amt of tickets updated for today with following code;

count({1<ASSIGNEDDATE_NUM={ '$(vToday)'} >} TicketID)

What is not working is when i try to assign it to Group = 15.

count({<GroupID ={'15'} ,{1<ASSIGNEDDATE_NUM={ '$(vToday)'} >} TicketID)

Expert help would be appreciated in this matter.

Best,

Bradley

[Gysbert_Wassenaar · Accepted solution]

Try

count({1<GroupID ={15}, ASSIGNEDDATE_NUM={'$(vToday)'} >} TicketID)

[Anonymous]

Hello,

please check with this

=count({<ASSIGNEDDATE_NUM={ '$(vToday)'}, GroupID ={'15'}>} TicketID)

Regards,

anant

[#4]

Hi Gysbert!

this Solution works great with a pre-prepared Excel sheet.

However when i try to run it in my application based on live data it seems to have no effect.

do you think that the field types could play a role in this?

[Gysbert_Wassenaar]

Yes, it's probably a problem with dates. Check that assigneddate_num is actually a numeric date. You may have to use the date# function.