Skip to Content
0
Oct 05, 2022 at 08:53 PM

Dashboard counting more records than imported data

241 Views

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.

image.png

image.png

Attachments

image.png (30.5 kB)
image.png (22.2 kB)