Please share the workbook.
I have mocked up a dummy data that mimicking the real data. Attached are the spreadsheet and the twbx file.
For example Dob LA 13/02/1966, It suppose to have 3 entries (ProductProvider LA/ Product Provider NB : B/D, C/B, and C/D). However it only calculates 2 entries only.
Thanks for your help.
OMG IT WORKS !!!!!!!!!!!!!!!!!!!! Do you know how many people in the office that have been helping me since 2 days ago? 4 people !!!!! and no one know how to do it. You are SUPER LEGEND !!!!!
So this is the 'CountA' formula in Tableau. Would you mind telling me the understanding behind that formula or how the formula works? It doesn't make sense to me and all those 4 people. LOL... you should see their face when they see your formula. No one understand what it does.
Thank you very much Zhouyi for your help. You are genius !!!!!!!!
You are welcome and I am glad to help
If I understand correctly, you want to count the combination of LA and NB for the day.
And if you look at your data in different way as below, you will find the combination A+B has 3 distinct values.
While your original calculation only counts LA, so that's why it is 2, but if you just need the number of rows for that day, you can also use count instead of countd. which will give you the same result as my previous reply.
Hope this explains well to you.
Thanks Zhouyi for the answer.
Now it makes sense when segregate the data and you combine LA and NB together (A + B). Also now I get it as there are D, B and D in the ProductProvider NB but if I do CountD I will still get the result of 2. If I count ProductProvider LA, I also get the result 2 since there are only B and C. Interesting when someone explain it step by step, you can see it properly, but when you see the whole data, you get so confuse.
One more thing Zhouyi, if you don't mind, I need to apply some dimension filters. However when you apply the dimension filter (currently Reporting Period), some of the numbers don't change accordingly. How do you make the LOD formula above flexible with the changing of dimension filters (later on i need to add Investigation Type filter)? I tried to put dimension filter on the 'fixed' LOD but it throws off all the calculation.
Attached is the twbx that I have already modified according to your advise above.
Once again thanks Zhouyi for your help as I am still exploring Tableau (It's kinda fiddly applying Excel knowledge to Tableau).
Counting Entries - Test.twbx 33.3 KB
Awesome !!! Yes it works like charm now. It's my first time using context filter. It's another Tableau knowledge that I will use from now on.
Thanks Zhouyi, I really appreciate your help. You are Legend !!!!