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
Hello, your code looks fine with the parenthesis matched. Please copy the and try to refresh the page once and reload it. Hopefully it will solve the issue.