Sources to define headcount

Question & Answer
,
1

Hi team, as we are trying to move our MBR data, we realized that the metrics are not showing the same numbers in Quicksight and in Clarity for most of them. This issue may be due to the headcount number, which is significantly different. Can you please tell me what are the sources used by Quicksight to define the headcount metric? It would help us a lot to provide accurate data to our business leaders.

Please find attached two screenshots from a leader we are supporting, one from Quicksight and one from Clarity, with the same timespan, so you can see the differences I mentioned previously.

image
image1386×265 15.4 KB

image

Thank you

2

Hi @Perraudeau_Laurie, welcome to the QuickSight Community! I am not sure I will be able to tell you which data-source is connected, but I may be able to help guide you through how to check the data-source with some options I have added below:

The following depends on the access permissions you currently have:

  1. If you have access to the analysis:
    a. You can check which dataset is connected under “Dataset” on the left-hand side of the screen

    b. If you have access to the dataset, then you can:
    - go to the data source and trace back to the connection to review the data
    OR
    - (If one does not already exist) create a new table visual in the analysis that contains all of the columns to get a sense of what the raw data looks like, and how it might be being rolled-up

    c. If you do not have access to the dataset then please ask the dataset owner to share the dataset with you, or ask them to review the data:
    - Sharing datasets - Amazon QuickSight

    d. If you are not sure who the dataset owner is, then I would recommend reaching out to the QuickSight account admin for the account where the dashboard exists

  2. If you have access to the dashboard:
    A. You can view the connected datasources via the “Data” button on the top-right corner of the screen, and follow steps b-d from above
    image

    b. If the table visual is rolled-up into a summary view, you may be able to expand the columns to see more details via the + button on the visual (there is a chance it may not be available on the visual depending on how it was setup)

I hope this helps! Feel free to reach out if you have any additional questions.