Should the “count” measure be stored in the fact table?

data-warehouse,dimensions,fact-table,datamart

1) Think about the grain of your existing fact table. It sounds like it's probably "an occasion on which a person received a service." If that's the same thing you're trying to count, then yes - the waiting time and the count are the same grain. However, while they may...