Hello, I have a spreadsheet (.xlsx) that is refreshed everyday on our share drive and then I refresh (import) the new data into the SAC model where it is feeding a dashboard.
I am using "count dimensions" on a field, which has duplicates, and assume its counting unique ID's which is what I need it to do. For some reason it is counting more records than what is in the spreadsheet for that field. I double checked the numbers manually so confirmed this. Any thoughts ?
The model created a field called "Account" and using it as "default hierarchy" which I'm not following why that is.