Is the column of 1's and 0's a calculated field? If so, you could create a calculated field that references that active calculated field.
For example, create a calculated field, let's call it 'ActiveWeeks', with the following expression:
IF [YourCalcField] = 1 THEN 1 ELSE NULL END
Then create a measure to count, using COUNT(ActiveWeeks)
I can't count because it always says "argument to count is already an aggregation field...."
That's it, but is it possible to do it with Tableau v7?
I see that the point is that you hve to "extract data"... which I don't really know what it means.... :-(
But thanks! it seems to work!
Thanks a lot! It seems to work!
Do you know if it is possible to have something like this?
Jan: 3 (three active weeks) and 1 inactive week
Feb: 2 (two active weeks) and 2 inactive weeks.
Without creating another "InActive" variable... Something like assigning 0 to non-active and 1 to active and then counting distinct values (0 and 1)....