Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi Community
See the Attachment
Regards
Aviral Nag
Maybe you can use this:
Count(DISTINCT if(aggr(nodistinct max(CompletedDate),MaxState)=CompletedDate,TicketID))
Attached.
Thanks Ajay for your reply but your logic is not working.
If you select Feb 2014 from field Monthname and Select India from field State it will show you 6 Tickets whereas from your formula i am getting 1 Ticket.
For the selections you mentioned the max date in Completed Date is 27/02/2014 for which there is just one
TicketID - 110.
Should a different logic be used to calculate that.
If You Go to Edit Script, than you'll see that i have picked the 2nd Max Completed Data "Key" wise.
So, the Max Date will come different for each case.
Hi,
Use this as your expression
Aggr(Count(DISTINCT TicketID),TicketID)
Checked enclose file,
Thanks for your reply.
This is not what I want.. Kindly read the post and see the Attachment.
Try :
Count({<State=p(MaxState)>}DISTINCT TicketID)
Thanks Tresesco for your reply.
There were some minute discrepancies. Not able to understand how to tackle it.
See the Attchment.