ContributionsMost RecentNewest TopicsMost LikesSolutionsRe: SiSense Security Concern I find it utterly ridiculous that we still have not received an answer to the most basic question : DOES THIS AFFECT SELF-HOSTED CUSTOMERS? We asked the question more than 24 hours ago and were given a generic cryptic "please refer to our FAQ". Well here I am... in your FAQ, and I still cannot find an answer. Please follow the most basic incident response protocol and help your customers identify if they're affected by your security incident. Re: How can you Count the number of patient with more than one AppointmentId in the same day Yes! Amazing, thank you so much it is working perfectly. Thank you for your help harikm007, it is very appreciated ! Have a very nice day, Olivier D. How can you Count the number of patient with more than one AppointmentId in the same day Hello, I've been trying to build build a widget (NUMBER) where I get the total Count of PatientId with more than one appointment in the same day... I was able to build a pivot table but I am confused when I try to replicate the calculation in other widget. Here is what I've been trying to do: (COUNT([PatientId]), COUNT([AppointmentId[), [AppointmentDate]) The problem is I can't filter the number of AppointmentId to be greater than 1 because AppointmentId is a String and Sisense doesn't offer the option to filter by value.... Thank you in advance for your help! Olivier