Thank you! I knew it must be something simple but I would never have thought to move a Measure to a Dimension. If you know of any blog or training that covers the theory behind this or cases where such a move would be useful, that would be most helpful. In this case, it seems that converting the measure to a dimension converts the measure value set to "categories" that can then be counted - am I getting this right? Looking for an underlying business rule so I can figure out things in the future...
1 of 1 people found this helpful
Glad you found it useful. In this case it was trivial to just move it because based on your snapshot above:
the 1,2,3 is what you wanted to count the number of records for when grouped by date. Because it is a number, Tableau automatically threw it in the measures pane which should then be manually moved to dimension because that is what you wanted in this case. The way I usually think about while solving a problem in Tableau is by 'grouping' and that would mostly mean dimensions. Hence, my instant thought was to move it. Leaving it in measures in this case would give incorrect aggregate results. There are a ton of resources out there from articles, blogs to videos and not to forget this community forum full of talented folks.
Hope this helps!