I will try to be as detailed as I can in this post, but please know I am limited on what I can share due to the sensitive nature of the data. I have put together a dashboard that uses COUNTD to count the total number of contracts from an Excel spreadsheet. There are duplicates within the dataset so by using the COUNTD it removes them in the count. However, when I go to export the data using the hamburger menu (see below), the number I get under the Full Data tab is not the same.
Is this just because the exported data under the Full Data tab does not take into account I am using a COUNTD, but rather is actually showing the original data? Ultimately, it boils down to the fact that when a user exports their data, the number shown in Excel is not the same as what is being displayed on the dashboard.
Is there any way around this? Any insight is greatly appreciated!
When you export your will get summary and full data view will shown.
Full data will come with duplicates and summary will take like view.