I have a dataset with a large number of events. They're all classified as belonging to a specific category (ie. category A, B, C and so on). The column is string / dimension - if I drag it to measurements, it gives 'count' as opposed to sum, which the plots I want to make seem to work with.
How do I deal with this issue? I basically want a way to work with the sum of subsets of these events.
OK - thanks for the explanation - so each record is an event and you would Count the events - that is done with the Count() functions
for example if you want to know how many "events" there are by day you could place the date dimension on rows count the number of records - that is done in tableau by dragging the CNT(dimension) to the canvas (it is the equivalent of count() )
see below
and attached
give it a try and if there are questions then pot your twbx is a small sample of fake data
and I will gladly look at it
Jim
