How to find which QS dataset metrics is actually used in the analysis?

Q&A
,
1

Hello,

I was wondering if there are any easy ways to find out which metrics from the QS dataset are actually being used in the analysis and dashboard?

e.g. QS dataset is created based on 3 tables. And only some of the metrics from each of the 3 tables are actually being used in the analysis and dashboard.
Thus, instead of manually checking each individual chart in the analysis, is there a way to get the list of metrics from each 3 tables that are used in the analysis at once?

2

Hi @irinaaaaa

Yes, it is possible to programmatically extract the dimension and measure fields used in the analysis. You can achieve this using the Boto3 API, particularly the ListAnalyses and DescribeAnalysis functions. By accessing the AnalysisDefinition from the DescribeAnalysis response, you can parse the JSON to identify all the fields in use. These fields are typically referenced in sections such as FieldWells (used in visuals), FilterGroups (used for filters) and CalculatedFields (derived fields used in the analysis)

Please refer to the below documentation this might be helpful for you.

3

Got it. Thanks for sharing @Xclipse

4

Hello @Xclipse,

I’d love to follow up on how to understand best the results from CLI data pulls.
e.g., from describe-analysis-definition, there are 3-4 parts for FieldId (ie. id.metrics_name.number.id), where do i find the definition of each part in this ID?
Similarly, where’s the best place to help myself understand the exported analysis definitions?

Best,
Irina