How to get QuickSight dashboard usage and access data to analyze metrics on the dashboard itself?

I found a (Japanese) site that might answer your question. https://dev.classmethod.jp/articles/visualize-amazon-quicksight-api-logs-with-quicksight/

The steps are below:

1. Enable CloudTrail
2. QuickSight permission settings for Athena
3. Create Athena Table

• You can create a table from the CloudTrail console ( I used to run a query to create a table from the Athena console ).

4. Create Dataset on QuickSight

• There is a SQL sample on the following site
  • https://dev.classmethod.jp/articles/count-quicksight-access-with-athena-and-cloudtrail/
• I was using the below query

SELECT
  date
  ,eventtime
  ,eventname
  ,useridentity.username AS username 
  ,json_extract_scalar( serviceeventdetails, '$.eventResponseDetails.dashboardDetails.dashboardName' ) AS dashboardName
  ,json_extract_scalar( serviceeventdetails, '$.eventResponseDetails.analysisDetails.analysisName' ) AS analysisName
FROM "logs"."cloudtrail_logs"
WHERE
  region = 'ap-northeast-1'
  AND eventsource = 'quicksight.amazonaws.com'
  AND eventname in ( 'GetDashboard','GetAnalysis')
;

5. Create a graph

• I have graphed the number of users by date as in the image below