see the attached
Since you did not include a TWBX workbook I used super store data and counted orders the counted the number of customers and created the viz below
the order count is date dependent converted to a distinct dimension
and the customer count is
If this posts assists in resolving the question, please mark it helpful or as the 'correct answer' if it resolves the question. This will help other users find the same answer/resolution. Thank you.
count d examples.twbx 2.4 MB
Convert invalid column into Dimension and then do like I did in below image.
You don't need to create any calculated field.
Please revert for any clarification.
if It will help you kindly mark this answer as correct or helpful so that it will helpful for others
Here I have attached my workbook as well. Please take a look.
Count.twbx 30.4 KB
The problem I've now is in my real data, the "invalid fields" column is an aggregate and I can't convert it into dimension. So, how can I do it? Sorry I'm newby in Tableau
Have you tried my approach??
just wanted to know whether its working for you or not.
Yes I've tried but I've the same problem that I've posted in my last comment.
Just take a look into my workbook.
I have dragged Invalid into the Column
then click on that like below image
Then click like below image
Then again click on invalid in column and select Discrete
then go into measure in left data pane like below image
and double click on Invalid.
now see below image and change calculation type from SUM to COUNT