cogswel__cogs
Board Regular
- Joined
- Jan 3, 2018
- Messages
- 178
I run some analysis that's fairly heavy. And one part involves getting unique instances of a customer where distinct data field would help.
However Data Model seems to be really CPU time consuming.
Since I know there are never really more than about 50 unique instance per customer per daily record. I use countif and sumifs on small range of the sorted data and which bacically bring info back on pivot to that unique instance.
If I am using one data table does data model help in any other way aside from Distinct count. You loose habitability to drill down which is annoying as well.
However Data Model seems to be really CPU time consuming.
Since I know there are never really more than about 50 unique instance per customer per daily record. I use countif and sumifs on small range of the sorted data and which bacically bring info back on pivot to that unique instance.
If I am using one data table does data model help in any other way aside from Distinct count. You loose habitability to drill down which is annoying as well.
Last edited: