1 of 1 people found this helpful
I'm not entirely certain on this one. You might try something like this to troubleshoot:
- Create a calculated field with the code LEN([ARTICLE ID])
- In a blank worksheet, place that field on Rows and make it discrete (right click and change to discrete).
- Place the [Number of Records] field on Columns.
- What is the result? Is everything 13 digits long? Or do you see other lengths?
Thanks very much for the response. I did not think to try to check the length of the field in Tableau, I'm not sure why.
Everything does look to be 13 digits long. I'll continue to play around with this to see if I can get the desired results. I've had this issue on a few different books and had to add parts 1 by 1 when I can't find some other attribute to filer on.