Code Error interface

My code appears to be correct, however i receive the following error message when i change to design view.

Error:

 

My code is the following:

a!localVariables(
  local!DatosPedidos: a!queryRecordType(
    recordType: 'recordType!{3c95c0e4-e69d-43f6-b485-e72b24252af7}CPF Maestro Pedidos',
    pagingInfo: a!pagingInfo(startIndex: 1, batchSize: 500)
  ).data,
  local!DatosPedidosLineasPedidos: a!queryRecordType(
    recordType: 'recordType!{495578a9-1b23-4253-8145-6418faabe727}CPF Lineas Pedido',
    pagingInfo: a!pagingInfo(startIndex: 1, batchSize: 500)
  ).data,
  local!DatosPedidosRecepFiltro: a!queryRecordType(
    recordType: 'recordType!{3c95c0e4-e69d-43f6-b485-e72b24252af7}CPF Maestro Pedidos',
    filters: a!queryFilter(
      field: 'recordType!{3c95c0e4-e69d-43f6-b485-e72b24252af7}CPF Maestro Pedidos.fields.{eeea3ae1-9516-46e3-8caa-327a9154b43d}recepcionado',
      operator: "=",
      value: true
    ),
    pagingInfo: a!pagingInfo(startIndex: 1, batchSize: 500)
  ).data,
  local!DatosPedidosFacturadoFiltro: a!queryRecordType(
    recordType: 'recordType!{51d44df6-c727-4443-8114-aef8a7509b41}CPF Maestro Facturas',
    filters: a!queryFilter(
      field: 'recordType!{51d44df6-c727-4443-8114-aef8a7509b41}CPF Maestro Facturas.fields.{d95fb6de-1b02-4867-8312-974781dde99a}estadoFact',
      operator: "=",
      value: "Facturación Aceptada"
    ),
    pagingInfo: a!pagingInfo(startIndex: 1, batchSize: 500)
  ).data,
  local!DatosPedidosImpRecep: a!queryRecordType(
    recordType: 'recordType!{b6fc6108-1f5d-4cbe-9c5c-08da4b1d58f3}CPF Maestro Recepciones',
    filters: a!queryFilter(
      field: 'recordType!{b6fc6108-1f5d-4cbe-9c5c-08da4b1d58f3}CPF Maestro Recepciones.fields.{3ea89e40-8997-4318-8e85-7e49ebc0a7de}validada',
      operator: "=",
      value: true
    ),
    pagingInfo: a!pagingInfo(startIndex: 1, batchSize: 500)
  ).data,
  local!DatosPedidosFacturados: a!queryRecordType(
    recordType: 'recordType!{3c95c0e4-e69d-43f6-b485-e72b24252af7}CPF Maestro Pedidos',
    filters: a!queryFilter(
      field: 'recordType!{3c95c0e4-e69d-43f6-b485-e72b24252af7}CPF Maestro Pedidos.fields.{85bbd90f-fc62-46a3-9bcf-3590b7745510}facturado',
      operator: "=",
      value: true
    ),
    pagingInfo: a!pagingInfo(startIndex: 1, batchSize: 500)
  ).data,
  {
    a!sectionLayout(
      label: "KPIs",
      labelIcon: "bar-chart",
      labelSize: "LARGE",
      labelColor: "#434343",
      contents: {
        a!columnsLayout(
          columns: {
            a!columnLayout(
              contents: {
                a!cardLayout(
                  contents: {
                    a!richTextDisplayField(
                      labelPosition: "COLLAPSED",
                      value: {
                        a!richTextItem(
                          text: { "Pedidos Realizados:" },
                          color: "#980000",
                          size: "MEDIUM_PLUS",
                          style: { "STRONG" }
                        ),
                        char(10),
                        a!richTextItem(
                          text: {
                            count(
                              local!DatosPedidos['recordType!{3c95c0e4-e69d-43f6-b485-e72b24252af7}CPF Maestro Pedidos.fields.{7309402c-2312-4a4e-bdaa-5654789bffb2}idPedido']
                            )
                          },
                          size: "MEDIUM_PLUS",
                          style: { "STRONG" }
                        )
                      },
                      align: "LEFT"
                    )
                  },
                  height: "AUTO",
                  style: "#fce5cd",
                  marginBelow: "STANDARD",
                  showBorder: true,
                  showShadow: false,
                  decorativeBarColor: "#dd7e6b"
                )
              }
            ),
            a!columnLayout(
              contents: {
                a!cardLayout(
                  contents: {
                    a!richTextDisplayField(
                      labelPosition: "COLLAPSED",
                      value: {
                        a!richTextItem(
                          text: { "Pedidos Recepcionados:" },
                          color: "#980000",
                          size: "MEDIUM_PLUS",
                          style: { "STRONG" }
                        ),
                        char(10),
                        a!richTextItem(
                          text: {
                            count(
                              local!DatosPedidosRecepFiltro['recordType!{3c95c0e4-e69d-43f6-b485-e72b24252af7}CPF Maestro Pedidos.fields.{7309402c-2312-4a4e-bdaa-5654789bffb2}idPedido']
                            )
                          },
                          color: "#000000",
                          size: "MEDIUM_PLUS",
                          style: { "STRONG" }
                        )
                      }
                    )
                  },
                  height: "AUTO",
                  style: "#fce5cd",
                  marginBelow: "STANDARD"
                )
              }
            ),
            a!columnLayout(
              contents: {
                a!cardLayout(
                  contents: {
                    a!richTextDisplayField(
                      labelPosition: "COLLAPSED",
                      value: {
                        a!richTextItem(
                          text: { "Pedidos Facturados:" },
                          color: "#980000",
                          size: "MEDIUM_PLUS",
                          style: { "STRONG" }
                        ),
                        char(10),
                        a!richTextItem(
                          text: {
                            count(
                              local!DatosPedidosFacturados['recordType!{3c95c0e4-e69d-43f6-b485-e72b24252af7}CPF Maestro Pedidos.fields.{7309402c-2312-4a4e-bdaa-5654789bffb2}idPedido']
                            )
                          },
                          color: "#000000",
                          size: "MEDIUM_PLUS",
                          style: { "STRONG" }
                        )
                      }
                    )
                  },
                  height: "AUTO",
                  style: "#fce5cd",
                  marginBelow: "STANDARD"
                )
              }
            )
          }
        )
      }
    ),
    a!columnsLayout(
      columns: {
        a!columnLayout(
          contents: {
            a!cardLayout(
              contents: {
                a!richTextDisplayField(
                  labelPosition: "COLLAPSED",
                  value: {
                    a!richTextItem(
                      text: { "Importe Total en Pedidos:" },
                      color: "#980000",
                      size: "MEDIUM_PLUS",
                      style: { "STRONG" }
                    ),
                    char(10),
                    a!richTextItem(
                      text: {
                        dollar(
                          sum(
                            local!DatosPedidos['recordType!{3c95c0e4-e69d-43f6-b485-e72b24252af7}CPF Maestro Pedidos.fields.{50cb6461-d663-4038-a178-da96ddc870d0}importeTotal']
                          )
                        )
                      },
                      color: "STANDARD",
                      size: "MEDIUM_PLUS",
                      style: { "STRONG" }
                    )
                  }
                )
              },
              height: "AUTO",
              style: "#fce5cd",
              marginBelow: "STANDARD"
            )
          }
        ),
        a!columnLayout(
          contents: {
            a!cardLayout(
              contents: {
                a!richTextDisplayField(
                  labelPosition: "COLLAPSED",
                  value: {
                    a!richTextItem(
                      text: { "Importe Recepcionado:" },
                      color: "#980000",
                      size: "MEDIUM_PLUS",
                      style: { "STRONG" }
                    ),
                    char(10),
                    a!richTextItem(
                      text: {
                        dollar(
                          sum(
                            local!DatosPedidosImpRecep['recordType!{b6fc6108-1f5d-4cbe-9c5c-08da4b1d58f3}CPF Maestro Recepciones.fields.{f7c1d09c-e69f-4478-9115-87202de7fefc}TotalRecepcionado']
                          )
                        )
                      },
                      color: "#000000",
                      size: "MEDIUM_PLUS",
                      style: { "STRONG" }
                    )
                  }
                )
              },
              height: "AUTO",
              style: "#fce5cd",
              marginBelow: "STANDARD"
            )
          }
        ),
        a!columnLayout(
          contents: {
            a!cardLayout(
              contents: {
                a!richTextDisplayField(
                  labelPosition: "COLLAPSED",
                  value: {
                    a!richTextItem(
                      text: { "Importe Facturado:" },
                      color: "#980000",
                      size: "MEDIUM_PLUS",
                      style: { "STRONG" }
                    ),
                    char(10),
                    a!richTextItem(
                      text: {
                        dollar(
                          sum(
                            local!DatosPedidosFacturadoFiltro['recordType!{51d44df6-c727-4443-8114-aef8a7509b41}CPF Maestro Facturas.fields.{e832ec1e-f394-4193-896c-b1e74035964e}totalFact']
                          )
                        )
                      },
                      color: "#000000",
                      size: "MEDIUM_PLUS",
                      style: { "STRONG" }
                    )
                  }
                )
              },
              height: "AUTO",
              style: "#fce5cd",
              marginBelow: "STANDARD"
            )
          }
        )
      }
    ),
    a!gaugeField(
      label: "% Pedidos Facturados",
      percentage: (
        count(
          local!DatosPedidosFacturados['recordType!{3c95c0e4-e69d-43f6-b485-e72b24252af7}CPF Maestro Pedidos.fields.{7309402c-2312-4a4e-bdaa-5654789bffb2}idPedido']
        ) / count(
          local!DatosPedidos['recordType!{3c95c0e4-e69d-43f6-b485-e72b24252af7}CPF Maestro Pedidos.fields.{7309402c-2312-4a4e-bdaa-5654789bffb2}idPedido']
        )
      ) * 100,
      primarytext: a!gaugePercentage()
    ),
    a!cardLayout(
      contents: {
        a!lineChartField(
          data: 'recordType!{3c95c0e4-e69d-43f6-b485-e72b24252af7}CPF Maestro Pedidos',
          config: a!lineChartConfig(
            primaryGrouping: a!grouping(
              field: 'recordType!{3c95c0e4-e69d-43f6-b485-e72b24252af7}CPF Maestro Pedidos.fields.{4097e2aa-8ce4-4ed1-9224-2ece219ef208}fechaEmision',
              alias: "fechaEmision_primaryGrouping",
              interval: "AUTO"
            ),
            measures: {
              a!measure(
                function: "COUNT",
                field: 'recordType!{3c95c0e4-e69d-43f6-b485-e72b24252af7}CPF Maestro Pedidos.fields.{7309402c-2312-4a4e-bdaa-5654789bffb2}idPedido',
                alias: "idPedido_count_measure1"
              )
            },
            dataLimit: 100
          ),
          label: "Pedidos realizados por fecha ",
          labelPosition: "ABOVE",
          xAxisTitle: "Fecha Emisión",
          yAxisTitle: "Número de pedidos realizados",
          showLegend: false,
          showDataLabels: false,
          showTooltips: true,
          connectNulls: false,
          colorScheme: "SUNSET",
          height: "MEDIUM",
          xAxisStyle: "STANDARD",
          yAxisStyle: "STANDARD",
          refreshAfter: "RECORD_ACTION"
        )
      },
      height: "AUTO",
      style: "#f3f3f3",
      marginBelow: "STANDARD"
    ),
    a!cardLayout(
      contents: {
        a!sectionLayout(
          label: "Estados",
          labelColor: "#980000",
          contents: {
            a!columnsLayout(
              columns: {
                a!columnLayout(
                  contents: {
                    a!pieChartField(
                      data: 'recordType!{3c95c0e4-e69d-43f6-b485-e72b24252af7}CPF Maestro Pedidos',
                      config: a!pieChartConfig(
                        primaryGrouping: a!grouping(
                          field: 'recordType!{3c95c0e4-e69d-43f6-b485-e72b24252af7}CPF Maestro Pedidos.fields.{bbcdbad7-589d-4a3a-bf5b-db8e83b2a6a7}EstadoRecepcionDefi',
                          alias: "EstadoRecepcionDefi_primaryGrouping"
                        ),
                        measures: {
                          a!measure(
                            function: "COUNT",
                            field: 'recordType!{3c95c0e4-e69d-43f6-b485-e72b24252af7}CPF Maestro Pedidos.fields.{7309402c-2312-4a4e-bdaa-5654789bffb2}idPedido',
                            alias: "idPedido_count_measure1"
                          )
                        },
                        dataLimit: 100
                      ),
                      label: "Estado Recepciones",
                      labelPosition: "ABOVE",
                      showDataLabels: true,
                      colorScheme: "SUNSET",
                      style: "DONUT",
                      seriesLabelStyle: "ON_CHART",
                      height: "MEDIUM",
                      refreshAfter: "RECORD_ACTION"
                    )
                  }
                ),
                a!columnLayout(
                  contents: {
                    a!pieChartField(
                      data: 'recordType!{3c95c0e4-e69d-43f6-b485-e72b24252af7}CPF Maestro Pedidos',
                      config: a!pieChartConfig(
                        primaryGrouping: a!grouping(
                          field: 'recordType!{3c95c0e4-e69d-43f6-b485-e72b24252af7}CPF Maestro Pedidos.fields.{e5339b1a-541c-429f-86df-916153a199bc}estadoFactMultiple',
                          alias: "estadoFactMultiple_primaryGrouping"
                        ),
                        measures: {
                          a!measure(
                            function: "COUNT",
                            field: 'recordType!{3c95c0e4-e69d-43f6-b485-e72b24252af7}CPF Maestro Pedidos.fields.{7309402c-2312-4a4e-bdaa-5654789bffb2}idPedido',
                            alias: "idPedido_count_measure1"
                          )
                        },
                        dataLimit: 100
                      ),
                      label: "Estado Facturación",
                      labelPosition: "ABOVE",
                      showDataLabels: true,
                      colorScheme: "SUNSET",
                      style: "DONUT",
                      seriesLabelStyle: "ON_CHART",
                      height: "MEDIUM",
                      refreshAfter: "RECORD_ACTION"
                    )
                  }
                ),
                a!columnLayout(
                  contents: {
                    a!pieChartField(
                      data: 'recordType!{3c95c0e4-e69d-43f6-b485-e72b24252af7}CPF Maestro Pedidos',
                      config: a!pieChartConfig(
                        primaryGrouping: a!grouping(
                          field: 'recordType!{3c95c0e4-e69d-43f6-b485-e72b24252af7}CPF Maestro Pedidos.fields.{e11e6206-fc23-4a4b-9819-4db5a5bab685}nomProveedor',
                          alias: "nomProveedor_primaryGrouping"
                        ),
                        measures: {
                          a!measure(
                            function: "COUNT",
                            field: 'recordType!{3c95c0e4-e69d-43f6-b485-e72b24252af7}CPF Maestro Pedidos.fields.{7309402c-2312-4a4e-bdaa-5654789bffb2}idPedido',
                            alias: "idPedido_count_measure1"
                          )
                        },
                        dataLimit: 100
                      ),
                      label: "Pedidos por Proveedor",
                      labelPosition: "ABOVE",
                      showDataLabels: true,
                      showTooltips: false,
                      showAsPercentage: true,
                      colorScheme: "SUNSET",
                      style: "DONUT",
                      seriesLabelStyle: "ON_CHART",
                      height: "MEDIUM",
                      refreshAfter: "RECORD_ACTION"
                    )
                  }
                )
              }
            )
          }
        )
      },
      height: "AUTO",
      style: "#f3f3f3",
      marginBelow: "STANDARD"
    ),
    a!cardLayout(
      contents: {
        a!barChartField(
          data: 'recordType!{495578a9-1b23-4253-8145-6418faabe727}CPF Lineas Pedido',
          config: a!barChartConfig(
            primaryGrouping: a!grouping(
              field: 'recordType!{495578a9-1b23-4253-8145-6418faabe727}CPF Lineas Pedido.fields.{69e9a834-b2fb-4f35-a36d-3c526c97f4ac}Material',
              alias: "Material_primaryGrouping"
            ),
            measures: {
              a!measure(
                function: "SUM",
                field: 'recordType!{495578a9-1b23-4253-8145-6418faabe727}CPF Lineas Pedido.fields.{e78c5b35-026f-4713-8404-05077c6c9152}Cantidad',
                alias: "Cantidad_sum_measure1"
              ),
              a!measure(
                function: "SUM",
                field: 'recordType!{495578a9-1b23-4253-8145-6418faabe727}CPF Lineas Pedido.fields.{bd0fe4ca-322c-422e-89e5-97e5194817a1}CantRecepAcum',
                alias: "CantRecepAcum_sum_measure2"
              )
            },
            dataLimit: 100
          ),
          label: "Cantidades por Material",
          labelPosition: "ABOVE",
          xAxisTitle: "Material",
          yAxisTitle: "Cantidad Total",
          stacking: "NONE",
          showLegend: true,
          showTooltips: true,
          colorScheme: "SUNSET",
          height: "MEDIUM",
          xAxisStyle: "STANDARD",
          yAxisStyle: "STANDARD",
          refreshAfter: "RECORD_ACTION"
        )
      },
      height: "AUTO",
      style: "#f3f3f3",
      marginBelow: "STANDARD"
    )
  }
)

I have been trying to find the error but I couldn't solve the problem. Any help would be useful.

Thanks!

  Discussion posts and replies are publicly visible

Parents Reply Children
No Data