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
local!DatosPedidosLineasPedidos: is not used.Besides that, i dont see any parenthesis issue either