How to find field ids for use in insight object

Question & Answer
, , ,
1

Hi there, this is a follow-up to this question Field ID for Insight Visuals.
I have attempted to find the field id for insights using both describe-dataset and describe-analysis, with no luck. Would someone be able to aid me in this?

Cheers,
Magnus

2

Hi @purpledonkey17 ,

use : describe-analysis-definition — AWS CLI 1.29.10 Command Reference

Regards,
Koushik

1 Like
3

Hi @Koushik_Muthanna,
I can find the field ID, by inspecting a visual which already exists.
But, when I am trying to create a new analysis (using a different dataset) I need to plug in the new field ID. I don’t know how these are generated/where they are set.
Essentially what I would like to know is how I can set/find the field IDs when generating an analysis definition to use in create-analysis.

Best,
Magnus

4

For further reference,
I have an analysis which uses the field ID b3746aa6-1c7c-4d35-860a-3bafebcf53d8.date_hour.0.1683801669808
The first part of this is the dataset id, then the second part is the column name, the third part (the 0) is presumably the column number or something. But, the final part (1683801669808) I can’t find anywhere.

5

It’s part of the syntax and can be a string value
Example : NumericalMeasureField - Amazon QuickSight

Here is an example from one of my analysis definitions

 "InsightConfiguration": {
                                "Computations": [
                                    {
                                        "Forecast": {
                                            "ComputationId": "73b91a4b-7756-4b1d-854c-6f077997f6fe",
                                            "Name": "ForecastInsight",
                                            "Time": {
                                                "DateDimensionField": {
                                                    "FieldId": "7356d853-b47b-4c26-b7f9-89140a8cc2ec.order_purchase_timestamp.0.1649683329923",
                                                    "Column": {
                                                        "DataSetIdentifier": "orders_items_product_seller",
                                                        "ColumnName": "order_purchase_timestamp"
                                                    },
                                                    "DateGranularity": "MONTH"
                                                }
                                            },
                                            "Value": {
                                                "NumericalMeasureField": {
                                                    "FieldId": "aa6dcbf8-a5a1-452d-8ed9-b8f975c06a00.1.1649683329923",
                                                    "Column": {
                                                        "DataSetIdentifier": "orders_items_product_seller",
                                                        "ColumnName": "total_order_value_USD"
                                                    },
                                                    "AggregationFunction": {
:
                            },
1 Like
6

Thanks very much for getting back to me.
OK, perfect. So in theory I can just generate a random string to populate this field, when creating a new analysis?

Best, Magnus

7

@purpledonkey17 ,

test it out. If you are creating the new analysis and using the definition of an existing analysis, you don’t have to make any changes to fieldId.

I find it easier to build an analysis in QuickSight console :slight_smile:

Regards,Koushik

8

@Koushik_Muthanna
Thank you very much for this response. We are having issues with the insights when taking this approach. But this is unrelated to my question.
Thanks very much for your response!

Best,
Magnus