I notice that when I place State on the Details shelf I do get more data points; however, when I go to disaggregate the data, the number of data points stays the same. It seems I am getting more data points because of the State dimension detail not because I disaggregated the data. Again, nothing changes when I disaggregate the data after placing State in the Detail shelf, so that leads me to believe it's the State detail that's leading to more data points rather than any disaggregating. Am I understanding that correctly?
Warning: I'm an instructional designer, not a data miner, so my experience with data crunching is limited at best. I'm a quick learner and good technical writer, but I obviously can't design something if I don't understand it completely.
From what I can gather, aggregated data is a combination of data points that makes querying easy. Aggregated data is the culmination of your data depending on what you're looking for--SUM, Average, etc.
Disaggregated data, on the other hand, is the individual data that makes up that aggregation. So, in the case of SUM, disaggregated data is all the smaller data pieces added up to get your SUM aggregation.
So I guess what I'm not seeing is the individual, disaggregated, data used to bring me to my aggregated SUM(Order) and SUM(Profit) numbers, right Dan Cory?
Okay. I'm going to carry on a conversation with myself here, but if any Tableau experts can confirm my suspicions, please do!
I think the problem is that data cannot be disaggregated when the data is blended. In my screenshots you will see the Profit measure is from a secondary data source. I'm ASSUMING that's why I cannot disaggregate it.
Can someone confirm or deny that for me so I stop banging my head against the wall? Thanks!
1 of 1 people found this helpful
Since blending always aggregates the secondary data, it doesn't make much sense to turn off aggregation. I don't see why we don't disable the menu command, but it would be hard to prevent users from ever reaching the state of aggregate measures off and blending.