
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개
Does this work for your case? LOOKUP(ZN(CountD([McIDandPersonnelType])),0)
https://www.phdata.io/blog/how-to-replace-null-blank-values-in-tableau/
See attached