Skip to content

[Bug]: Cannot set target_value for kpi_visual #31901

Closed
@jshort-insights

Description

@jshort-insights

Terraform Core Version

1.4.5

AWS Provider Version

5.1.0

Affected Resource(s)

aws_quicksight_analysis

Expected Behavior

Defining a target_value should add necessary field to field well

Actual Behavior

Terraform apply runs successfully, but change is not replicated into AWS

Relevant Error/Panic Output Snippet

No response

Terraform Configuration Files

resource "aws_quicksight_analysis" "generated_weekly_sales_analysis" {
  analysis_id    = "generated-weekly-sales-analysis"
  name           = "Old vs New Weekly sales Analysis"
  aws_account_id = data.aws_caller_identity.current.account_id

  definition {
    data_set_identifiers_declarations {
      data_set_arn = "arn:aws:quicksight:eu-west-1:370044283886:dataset/70d3ce75-c58d-4664-a1bc-495b483d9cb7"
      identifier   = "70d3ce75-c58d-4664-a1bc-495b483d9cb7"
    }

    sheets {
      sheet_id = "weekly-sales-sheet"
      name     = "Old V New Generated sales"

      visuals {
        kpi_visual {
          visual_id = "last-3-months-kpi"
          title {
            visibility = "VISIBLE"
            format_text {
              rich_text = "<visual-title>Difference Old  vs New sales (Last 3 Months)</visual-title>"
            }
          }
          subtitle {
            visibility = "VISIBLE"
          }
          chart_configuration {
            field_wells {
              values {
                numerical_measure_field {
                  field_id = "old-total-sales"
                  column {
                    data_set_identifier = "70d3ce75-c58d-4664-a1bc-495b483d9cb7"
                    column_name         = "Old Total sales"
                  }
                  aggregation_function {
                    simple_numerical_aggregation = "SUM"
                  }
                }
              }
              target_values {
                numerical_measure_field {
                  field_id = "new-total-sales"
                  column {
                    data_set_identifier = "70d3ce75-c58d-4664-a1bc-495b483d9cb7"
                    column_name         = "New Total sales"
                  }
                  aggregation_function {
                    simple_numerical_aggregation = "SUM"
                  }
                }
              }
            }
            sort_configuration {}

          }
        }
      }
      layouts {
        configuration {
          grid_layout {
            elements {
              element_id   = "last-3-months-kpi"
              element_type = "VISUAL"
              column_index = "0"
              column_span  = "32"
              row_index    = "12"
              row_span     = "4"
            }

            canvas_size_options {
              screen_canvas_size_options {
                resize_option             = "FIXED"
                optimized_view_port_width = "1600px"
              }
            }
          }
        }
      }
      content_type = "INTERACTIVE"
    }

    analysis_defaults {
      default_new_sheet_configuration {
        interactive_layout_configuration {
          grid {
            canvas_size_options {
              screen_canvas_size_options {
                resize_option             = "FIXED"
                optimized_view_port_width = "1600px"
              }
            }
          }
        }
        sheet_content_type = "INTERACTIVE"
      }
    }
  }
}

Steps to Reproduce

aws quicksight describe-analysis-definition --aws-account-id <account_id> --analysis-id generated-weekly-sales-analysis


{
  "Status": 200,
  "AnalysisId": "generated-weekly-sales-analysis",
  "Name": "Old vs New Weekly sales Analysis",
  "ResourceStatus": "CREATION_SUCCESSFUL",
  "Definition": {
    "DataSetIdentifierDeclarations": [
      {
        "Identifier": "70d3ce75-c58d-4664-a1bc-495b483d9cb7",
        "DataSetArn": "arn:aws:quicksight:eu-west-1:12345678:dataset/70d3ce75-c58d-4664-a1bc-495b483d9cb7"
      }
    ],
    "Sheets": [
      {
        "SheetId": "weekly-sales-sheet",
        "Name": "Old V New Generated sales",
        "Visuals": [
          {
            "KPIVisual": {
              "VisualId": "last-3-months-kpi",
              "Title": {
                "Visibility": "VISIBLE",
                "FormatText": {
                  "RichText": "<visual-title>Difference Old  vs New sales (Last 3 Months)</visual-title>"
                }
              },
              "Subtitle": {
                "Visibility": "VISIBLE"
              },
              "ChartConfiguration": {
                "FieldWells": {
                  "Values": [
                    {
                      "NumericalMeasureField": {
                        "FieldId": "old-total-sales",
                        "Column": {
                          "DataSetIdentifier": "70d3ce75-c58d-4664-a1bc-495b483d9cb7",
                          "ColumnName": "Old Total Sales"
                        },
                        "AggregationFunction": {
                          "SimpleNumericalAggregation": "SUM"
                        }
                      }
                    }
                  ],
                  "TargetValues": [],
                  "TrendGroups": []
                },
                "SortConfiguration": {}
              },
              "Actions": [],
              "ColumnHierarchies": []
            }
          }
        ],
        "Layouts": [
          {
            "Configuration": {
              "GridLayout": {
                "Elements": [
                  {
                    "ElementId": "last-3-months-kpi",
                    "ElementType": "VISUAL",
                    "ColumnSpan": 32,
                    "RowIndex": 12,
                    "RowSpan": 4
                  }
                ],
                "CanvasSizeOptions": {
                  "ScreenCanvasSizeOptions": {
                    "ResizeOption": "FIXED",
                    "OptimizedViewPortWidth": "1600px"
                  }
                }
              }
            }
          }
        ],
        "ContentType": "INTERACTIVE"
      }
    ],
    "CalculatedFields": [],
    "ParameterDeclarations": [],
    "FilterGroups": [],
    "AnalysisDefaults": {
      "DefaultNewSheetConfiguration": {
        "InteractiveLayoutConfiguration": {
          "Grid": {
            "CanvasSizeOptions": {
              "ScreenCanvasSizeOptions": {
                "ResizeOption": "FIXED",
                "OptimizedViewPortWidth": "1600px"
              }
            }
          }
        },
        "SheetContentType": "INTERACTIVE"
      }
    }
  },
  "RequestId": "4a8f69de-c94b-4d29-b6dc-63de599d595a"
}


Note that TargetValues is an empty array although has been defined and applied in hcl

Debug Output

No response

Panic Output

No response

Important Factoids

No response

References

No response

Would you like to implement a fix?

None

Metadata

Metadata

Assignees

No one assigned

    Labels

    bugAddresses a defect in current functionality.service/quicksightIssues and PRs that pertain to the quicksight service.

    Type

    No type

    Projects

    No projects

    Milestone

    Relationships

    None yet

    Development

    No branches or pull requests

    Issue actions