Skip to main content
Richard S. 님이 #Tableau Desktop & Web Authoring에 질문했습니다

For example, in the attached workbook, I am looking to count how many people that badged in at least once during that particular week. When they did not badge in at all during that week, it is blank. I want it to show a zero. I tried using this formula:

 

{ FIXED DATETRUNC('day', [Date]),[McID:]: IFNULL(CountD([McIDandPersonnelType]),0)}

 

However, it didn't work. I then would like to take the column grand total for each week. If someone can please assist, I would be most appreciative. Thank you!

답변 3개