Tickets Logged Today

[belgarathza]

Hi

I'm busy creating a dashboard with a viewset which will contain the field "Tickets logged today".I'm battling to get the distinct count for all the Tickets logged for the specifc date. It either gives me all the tickets or it only shows 1. I'm currently using the following formula: "

=Count(DISTINCT([Num]=If([Open Date]=Today(),''))) "

Is there another way of getting the results?

Regards

Terence

[#2]

Hi,

you can use this expression

count(distinct if([Open Date]=Today(), TicketID))

Hope this helps.

Regards,

Amay.

[Anonymous]

If [Num] is your Ticket ID or something similar you should be able to do something along the lines of:

count({$<[Open Date]={$(=Today())}>} distinct [Num])

[alexandros17]

count({$ <[Open Date]={'$(=today())'}>} DISTINCT Num)

hope it helps

[belgarathza]

Hi All

Thank you for the quick responses, I've attached some of the data and a qv file to give more information.

Regards

Terence

[Anonymous · Accepted solution]

Hi Terence,

You can do this:

=Count(if(Date(floor([Open Date]))=Today(),Num))

But it's easier if you create an OpenDate in your script without timestamp (or just separate the timestamp into another field).

[belgarathza]

Hi 🙂

Thank you very much, it works.:-)

I adjusted the formula slightly to assist with the distinct count and it works perfectly.

=Count(Distinct(if(Date(floor([Open Date]))=Today(),Num)))

Regards

Terence