Export to CSV

Data

static external_id created_by_sofit app_id chart report_folder_id id content created_at updated_at deleted_at created_by_id updated_by_id deleted_by_id owner_by_id name type description title main_table
{"type":"bar","categories":"vehicle.cf_34","values":[{"column":"_formula.QDE.","rawColumn":"_formula.QDE.","summarizer":"formula","axis":0,"isMainValue":true}],"legend":{"enabled":false},"filters":{"showOnlyFirstRecords":false,"showAllRecords":true,"recordsToShow":null},"show_values":{"enabled":true}} 268 1601 {"table":"vehicle","relationships":[],"type":"matrix","fields":[{"table":"_formula","column":"QDE.","type":"formula","query":"COUNT(DISTINCT vehicle.id)","showAt":{"inner":true,"total":true},"showInHours":false,"format":null,"daysEvaluatedColumns":null,"relatedTables":[{"table":"vehicle"}]},{"table":"vehicle","column":"cf_34","type":"STRING","showAt":{"inner":true,"total":true},"showInHours":false,"format":null,"daysEvaluatedColumns":null},{"table":"vehicle","column":"cf_379","type":"STRING","showAt":{"inner":true,"total":true},"showInHours":false,"format":null,"daysEvaluatedColumns":null}],"filters":[{"field":"vehicle.status","operator":"equal","condition":"AND","value":["active"],"variableValue":null,"variableValueType":null,"variableValueTranslated":null,"conditionType":"fixed","references":null,"format":"list:vehicleStatus","type":"STRING","isFixedPeriod":false,"isDatePeriod":false,"isDynamicPeriod":false,"isNotInTable":false,"translated":null,"lineNumber":19},{"field":"vehicle.cf_379","operator":"equal","condition":"AND","value":["CAVALO","UTILITARIO","TRUCK"],"variableValue":null,"variableValueType":null,"variableValueTranslated":null,"conditionType":"fixed","references":null,"format":null,"type":"STRING","isFixedPeriod":false,"isDatePeriod":false,"isDynamicPeriod":false,"isNotInTable":false,"translated":null,"lineNumber":20}],"aggregates":[{"table":"vehicle","column":"cf_34","group":true,"sum":null,"avg":null,"max":null,"min":null,"matrix_type":"horizontal","translated":"Propriedade","id":"vehicle.cf_34"},{"table":"vehicle","column":"cf_379","group":true,"sum":null,"avg":null,"max":null,"min":null,"matrix_type":"vertical","translated":"Tipo de Grupo","id":"vehicle.cf_379"}],"preview":false,"orderBy":[{"table":"vehicle","column":"cf_34","isHeaderColumn":true,"desc":false}],"groupBy":[]} 2022-09-21 12:35:32.53+00 2022-09-21 12:35:32.577+00 870 870 REL-001601 matrix Quantidade de veículos ativos por propriedade PROPRIEDADE VEICULOS v1 vehicle
{"type":"bar","categories":"vehicle.cf_34","values":[{"column":"_formula.QDE.","rawColumn":"_formula.QDE.","axis":0,"summarizer":"formula","isMainValue":true}],"legend":{"enabled":false},"show_values":{"enabled":true},"use_diferent_color":{"enabled":true},"stacked_column":{"enabled":false},"filters":{"showOnlyFirstRecords":false,"showAllRecords":true,"recordsToShow":null}} 268 1600 {"table":"vehicle","relationships":[],"type":"matrix","fields":[{"table":"_formula","column":"QDE.","type":"formula","query":"COUNT(DISTINCT vehicle.id)","showAt":{"inner":true,"total":true},"showInHours":false,"format":null,"daysEvaluatedColumns":null,"relatedTables":[{"table":"vehicle"}]},{"table":"vehicle","column":"cf_34","type":"STRING","showAt":{"inner":true,"total":true},"showInHours":false,"format":null,"daysEvaluatedColumns":null},{"table":"vehicle","column":"cf_379","type":"STRING","showAt":{"inner":true,"total":true},"showInHours":false,"format":null,"daysEvaluatedColumns":null}],"filters":[{"field":"vehicle.status","operator":"equal","condition":"AND","value":["active"],"variableValue":null,"variableValueType":null,"variableValueTranslated":null,"conditionType":"fixed","references":null,"format":"list:vehicleStatus","type":"STRING","isFixedPeriod":false,"isDatePeriod":false,"isDynamicPeriod":false,"isNotInTable":false,"translated":null,"lineNumber":1},{"field":"vehicle.cf_379","operator":"equal","condition":"AND","value":["CAVALO","UTILITARIO","TRUCK"],"variableValue":null,"variableValueType":null,"variableValueTranslated":null,"conditionType":"fixed","references":null,"format":null,"type":"STRING","isFixedPeriod":false,"isDatePeriod":false,"isDynamicPeriod":false,"isNotInTable":false,"translated":null,"lineNumber":2}],"aggregates":[{"table":"vehicle","column":"cf_34","group":true,"sum":null,"avg":null,"max":null,"min":null,"matrix_type":"horizontal","translated":"Propriedade","id":"vehicle.cf_34"},{"table":"vehicle","column":"cf_379","group":true,"sum":null,"avg":null,"max":null,"min":null,"matrix_type":"vertical","translated":"Tipo de Grupo","id":"vehicle.cf_379"}],"preview":false,"orderBy":[{"table":"vehicle","column":"cf_34","isHeaderColumn":true,"desc":false}],"groupBy":[]} 2022-09-21 12:27:02.814+00 2022-09-21 12:36:50.865+00 2022-09-21 12:36:50.861+00 870 870 870 870 REL-001600 matrix Quantidade de veículos ativos por propriedade PROPRIEDADE VEICULOS vehicle
{"type":"bar","categories":"vehicle.cf_34","values":[{"column":"_formula.QDE.","rawColumn":"_formula.QDE.","axis":0,"summarizer":"formula","isMainValue":true}],"legend":{"enabled":false},"show_values":{"enabled":true},"use_diferent_color":{"enabled":true},"stacked_column":{"enabled":false},"filters":{"showOnlyFirstRecords":false,"showAllRecords":true,"recordsToShow":null}} 268 1593 {"table":"vehicle","relationships":[],"type":"matrix","fields":[{"table":"_formula","column":"QDE.","type":"formula","query":"COUNT(DISTINCT vehicle.id)","showAt":{"inner":true,"total":true},"showInHours":false,"format":null,"daysEvaluatedColumns":null,"relatedTables":[{"table":"vehicle"}]},{"table":"vehicle","column":"model_group","type":"STRING","showAt":{"inner":true,"total":true},"showInHours":false,"format":null,"daysEvaluatedColumns":null},{"table":"vehicle","column":"cf_34","type":"STRING","showAt":{"inner":true,"total":true},"showInHours":false,"format":null,"daysEvaluatedColumns":null}],"filters":[{"field":"vehicle.status","operator":"equal","condition":"AND","value":["active"],"variableValue":null,"variableValueType":null,"variableValueTranslated":null,"conditionType":"fixed","references":null,"format":"list:vehicleStatus","type":"STRING","isFixedPeriod":false,"isDatePeriod":false,"isDynamicPeriod":false,"isNotInTable":false,"translated":null,"lineNumber":5},{"field":"vehicle.cf_379","operator":"equal","condition":"AND","value":["CAVALO","UTILITARIO","TRUCK"],"variableValue":null,"variableValueType":null,"variableValueTranslated":null,"conditionType":"fixed","references":null,"format":null,"type":"STRING","isFixedPeriod":false,"isDatePeriod":false,"isDynamicPeriod":false,"isNotInTable":false,"translated":null,"lineNumber":6}],"aggregates":[{"table":"vehicle","column":"model_group","group":true,"sum":null,"avg":null,"max":null,"min":null,"matrix_type":"vertical","translated":"Grupo do modelo","id":"vehicle.model_group"},{"table":"vehicle","column":"cf_34","group":true,"sum":null,"avg":null,"max":null,"min":null,"matrix_type":"horizontal","translated":"Propriedade","id":"vehicle.cf_34"}],"preview":false,"orderBy":[{"table":"vehicle","column":"cf_34","isHeaderColumn":true,"desc":false}],"groupBy":[]} 2022-09-21 11:55:52.238+00 2022-09-21 12:37:49.769+00 2022-09-21 12:37:49.765+00 870 870 870 870 REL-001593 matrix Quantidade de veículos por tipo QDE POR PROPRIEDADE VEICULOS vehicle
268 1604 {"table":"vehicle","relationships":["group","modelversion","cost_center","model"],"type":"table","fields":[{"table":"vehicle","column":"cf_611","type":"STRING","showAt":null,"showInHours":false,"format":null,"daysEvaluatedColumns":null},{"table":"vehicle","column":"license_plate","type":"STRING","showAt":null,"showInHours":false,"format":null,"daysEvaluatedColumns":null},{"table":"vehicle","column":"cf_379","type":"STRING","showAt":null,"showInHours":false,"format":null,"daysEvaluatedColumns":null},{"table":"vehicle","column":"subsidiary_id","type":"INTEGER","showAt":null,"showInHours":false,"format":null,"daysEvaluatedColumns":null},{"table":"vehicle","column":"cost_center_id","type":"INTEGER","showAt":null,"showInHours":false,"format":null,"daysEvaluatedColumns":null},{"table":"vehicle","column":"vehicle_group_id","type":"INTEGER","showAt":null,"showInHours":false,"format":null,"daysEvaluatedColumns":null},{"table":"vehicle","column":"fabrication_year","type":"INTEGER","showAt":null,"showInHours":false,"format":null,"daysEvaluatedColumns":null},{"table":"vehicle","column":"model_year","type":"INTEGER","showAt":null,"showInHours":false,"format":null,"daysEvaluatedColumns":null},{"table":"vehicle","column":"axis_number","type":"STRING","showAt":null,"showInHours":false,"format":null,"daysEvaluatedColumns":null},{"table":"vehicle","column":"cf_142","type":"STRING","showAt":null,"showInHours":false,"format":null,"daysEvaluatedColumns":null},{"table":"vehicle","column":"cf_141","type":"STRING","showAt":null,"showInHours":false,"format":null,"daysEvaluatedColumns":null},{"table":"vehicle","column":"cf_36","type":"STRING","showAt":null,"showInHours":false,"format":null,"daysEvaluatedColumns":null},{"table":"vehicle","column":"cf_663","type":"STRING","showAt":null,"showInHours":false,"format":null,"daysEvaluatedColumns":null},{"table":"vehicle","column":"cf_34","type":"STRING","showAt":null,"showInHours":false,"format":null,"daysEvaluatedColumns":null},{"table":"vehicle","column":"cf_734","type":"STRING","showAt":null,"showInHours":false,"format":null,"daysEvaluatedColumns":null},{"table":"vehicle","column":"cf_308","type":"STRING","showAt":null,"showInHours":false,"format":null,"daysEvaluatedColumns":null},{"table":"vehicle","column":"cf_35","type":"STRING","showAt":null,"showInHours":false,"format":null,"daysEvaluatedColumns":null},{"table":"vehicle","column":"cf_612","type":"TEXT","showAt":null,"showInHours":false,"format":null,"daysEvaluatedColumns":null},{"table":"vehicle","column":"created_at","type":"DATE","showAt":null,"showInHours":false,"format":null,"daysEvaluatedColumns":null}],"filters":[{"field":"vehicle.status","operator":"equal","condition":"AND","value":["active"],"variableValue":null,"variableValueType":null,"variableValueTranslated":null,"conditionType":"fixed","references":null,"format":"list:vehicleStatus","type":"STRING","isFixedPeriod":false,"isDatePeriod":false,"isDynamicPeriod":false,"isNotInTable":false,"translated":null,"lineNumber":1}],"aggregates":[],"preview":false,"orderBy":[],"groupBy":[]} 2022-09-21 12:55:45.023+00 2022-09-21 12:55:45.062+00 870 870 REL-001604 table relatório para verificar veículos ativos RELATÓRIO ANALITICO VEICULOS v2 vehicle
{"type":"donut","categories":"vehicle.cf_663","values":[{"column":"_formula.QDE.","rawColumn":"_formula.QDE.","axis":0,"summarizer":"formula","isMainValue":true}],"legend":{"enabled":true},"show_values":{"enabled":false},"use_diferent_color":{},"stacked_column":{"enabled":false},"filters":{"showOnlyFirstRecords":false,"showAllRecords":true,"recordsToShow":null}} 268 1603 {"table":"vehicle","relationships":[],"type":"matrix","fields":[{"table":"_formula","column":"QDE.","type":"formula","query":"COUNT(DISTINCT vehicle.id)","showAt":{"inner":true,"total":true},"showInHours":false,"format":null,"daysEvaluatedColumns":null,"relatedTables":[{"table":"vehicle"}]},{"table":"vehicle","column":"cf_141","type":"STRING","showAt":{"inner":true,"total":true},"showInHours":false,"format":null,"daysEvaluatedColumns":null},{"table":"vehicle","column":"cf_663","type":"STRING","showAt":{"inner":true,"total":true},"showInHours":false,"format":null,"daysEvaluatedColumns":null}],"filters":[{"field":"vehicle.status","operator":"equal","condition":"AND","value":["active"],"variableValue":null,"variableValueType":null,"variableValueTranslated":null,"conditionType":"fixed","references":null,"format":"list:vehicleStatus","type":"STRING","isFixedPeriod":false,"isDatePeriod":false,"isDynamicPeriod":false,"isNotInTable":false,"translated":null,"lineNumber":1},{"field":"vehicle.cf_379","operator":"equal","condition":"AND","value":["CAVALO","UTILITARIO","TRUCK"],"variableValue":null,"variableValueType":null,"variableValueTranslated":null,"conditionType":"fixed","references":null,"format":null,"type":"STRING","isFixedPeriod":false,"isDatePeriod":false,"isDynamicPeriod":false,"isNotInTable":false,"translated":null,"lineNumber":2}],"aggregates":[{"table":"vehicle","column":"cf_141","group":true,"sum":null,"avg":null,"max":null,"min":null,"matrix_type":"vertical","translated":"Modelo RG LOG","id":"vehicle.cf_141"},{"table":"vehicle","column":"cf_663","group":true,"sum":null,"avg":null,"max":null,"min":null,"matrix_type":"horizontal","translated":"Tração","id":"vehicle.cf_663"}],"preview":false,"orderBy":[{"table":"vehicle","column":"cf_663","isHeaderColumn":true,"desc":false}],"groupBy":[]} 2022-09-21 12:51:49.078+00 2022-09-21 12:51:50.029+00 870 870 REL-001603 matrix Quantidade de veículos por TRAÇÃO VEICULOS QDE POR TRAÇÃO VEICULOS vehicle
{"type":"column","categories":"service_order.name","values":[{"column":"service_order.total_cost","rawColumn":"service_order.total_cost__sum__","axis":0,"summarizer":"sum","isMainValue":true}],"legend":{"enabled":false},"show_values":{"enabled":true},"use_diferent_color":{"enabled":false},"stacked_column":{"enabled":false},"filters":{"showOnlyFirstRecords":false,"showAllRecords":true,"recordsToShow":null}} 400 2222 {"table":"service_order","relationships":["vehicle"],"type":"table","fields":[{"table":"service_order","column":"name","type":"STRING","showAt":null,"showInHours":false,"format":null,"daysEvaluatedColumns":null},{"table":"vehicle","column":"name","type":"STRING","showAt":null,"showInHours":false,"format":null,"daysEvaluatedColumns":null},{"table":"service_order","column":"forecast_finish_date","type":"DATE","showAt":null,"showInHours":false,"format":null,"daysEvaluatedColumns":null},{"table":"service_order","column":"total_cost","type":"DECIMAL","showAt":null,"showInHours":false,"format":"Money","daysEvaluatedColumns":null}],"filters":[{"field":"service_order.status","operator":"equal","condition":"AND","value":["in_progress"],"variableValue":null,"variableValueType":null,"variableValueTranslated":null,"conditionType":"fixed","references":null,"format":"list:serviceOrderStatus","type":"STRING","isFixedPeriod":false,"isDatePeriod":false,"isDynamicPeriod":false,"isNotInTable":false,"translated":null,"lineNumber":4}],"aggregates":[{"table":"service_order","column":"total_cost","group":false,"sum":true,"avg":false,"max":false,"min":false,"stddev":false},{"table":"service_order","column":"name","group":true,"sum":false,"avg":false,"max":false,"min":false,"stddev":false}],"preview":false,"orderBy":[],"groupBy":[]} 2022-09-29 19:17:01.743+00 2022-09-29 19:56:36.232+00 870 870 870 REL-002222 table Relatório de valores de ordens de serviços em andamento por OS. Graf. Valores OS em Andamento por OS service_order
{"type":"treemap","categories":"vehicle.cost_center_id","values":[{"column":"_formula.QDE.","rawColumn":"_formula.QDE.","axis":0,"summarizer":"formula","isMainValue":true}],"legend":{"enabled":false},"show_values":{"enabled":false},"use_diferent_color":{"enabled":true},"stacked_column":{},"filters":{"showOnlyFirstRecords":false,"showAllRecords":true,"recordsToShow":null}} 268 1607 {"table":"vehicle","relationships":[],"type":"matrix","fields":[{"table":"_formula","column":"QDE.","type":"formula","query":"COUNT(DISTINCT vehicle.id)","showAt":{"inner":true,"total":true},"showInHours":false,"format":null,"daysEvaluatedColumns":null,"relatedTables":[{"table":"vehicle"}]},{"table":"vehicle","column":"cf_142","type":"STRING","showAt":{"inner":true,"total":true},"showInHours":false,"format":null,"daysEvaluatedColumns":null},{"table":"vehicle","column":"cost_center_id","type":"INTEGER","showAt":{"inner":true,"total":true},"showInHours":false,"format":null,"daysEvaluatedColumns":null}],"filters":[{"field":"vehicle.status","operator":"equal","condition":"AND","value":["active"],"variableValue":null,"variableValueType":null,"variableValueTranslated":null,"conditionType":"fixed","references":null,"format":"list:vehicleStatus","type":"STRING","isFixedPeriod":false,"isDatePeriod":false,"isDynamicPeriod":false,"isNotInTable":false,"translated":null,"lineNumber":1},{"field":"vehicle.cf_379","operator":"equal","condition":"AND","value":["SEMIRREBOQUE","REBOQUE"],"variableValue":null,"variableValueType":null,"variableValueTranslated":null,"conditionType":"fixed","references":null,"format":null,"type":"STRING","isFixedPeriod":false,"isDatePeriod":false,"isDynamicPeriod":false,"isNotInTable":false,"translated":null,"lineNumber":2}],"aggregates":[{"table":"vehicle","column":"cf_142","group":true,"sum":null,"avg":null,"max":null,"min":null,"matrix_type":"vertical","translated":"Marca RG LOG","id":"vehicle.cf_142"},{"table":"vehicle","column":"cost_center_id","group":true,"sum":null,"avg":null,"max":null,"min":null,"matrix_type":"horizontal","translated":"Centro de custo","id":"vehicle.cost_center_id"}],"preview":false,"orderBy":[{"table":"vehicle","column":"cost_center_id","isHeaderColumn":true,"desc":false}],"groupBy":[]} 2022-09-21 13:15:50.254+00 2022-09-21 13:15:50.505+00 870 870 REL-001607 matrix Quantidade de CARRETAS por centro de custos QDE POR CENTRO CUSTO CARRETAS vehicle
565 4984 {"table":"transaction","relationships":[],"type":"table","fields":[{"table":"transaction","column":"supplier_id","type":"INTEGER","showAt":null,"showInHours":false,"format":null,"daysEvaluatedColumns":null,"translated":"Fornecedor"},{"table":"transaction","column":"expense_id","type":"INTEGER","showAt":null,"showInHours":false,"format":null,"daysEvaluatedColumns":null,"translated":"Despesa"},{"table":"transaction","column":"date","type":"DATE","showAt":null,"showInHours":false,"format":null,"daysEvaluatedColumns":null,"translated":"Data"},{"table":"transaction","column":"vehicle_id","type":"INTEGER","showAt":null,"showInHours":false,"format":null,"daysEvaluatedColumns":null,"translated":"Veículo"},{"table":"transaction","column":"item_id","type":"INTEGER","showAt":null,"showInHours":false,"format":null,"daysEvaluatedColumns":null,"translated":"Item"},{"table":"transaction","column":"quantity","type":"DECIMAL","showAt":null,"showInHours":false,"format":null,"daysEvaluatedColumns":null,"translated":"Quantidade"},{"table":"transaction","column":"unit_value","type":"DECIMAL","showAt":null,"showInHours":false,"format":"Money","daysEvaluatedColumns":null,"translated":"Valor unitário"},{"table":"transaction","column":"final_value","type":"DECIMAL","showAt":null,"showInHours":false,"format":"Money","daysEvaluatedColumns":null,"translated":"Valor total"},{"table":"transaction","column":"invoice","type":"STRING","showAt":null,"showInHours":false,"format":null,"daysEvaluatedColumns":null,"translated":"Fatura"}],"filters":[{"field":"transaction.date","operator":"dynamic_period","condition":"AND","value":"this_year:this_year","references":null,"format":null,"type":"DATE","variableValue":null,"variableValueType":null,"conditionType":"fixed","isFixedPeriod":false,"isDynamicPeriod":true,"isDatePeriod":false,"translated":null},{"field":"transaction.type","operator":"equal","condition":"AND","value":["expense"],"references":null,"format":"list:transactionTypes","type":"STRING","variableValue":null,"variableValueType":null,"conditionType":"fixed","isFixedPeriod":false,"isDynamicPeriod":false,"isDatePeriod":false,"translated":null},{"field":"transaction.item_id","operator":"not_empty","condition":"AND","value":null,"references":"item","format":null,"type":"INTEGER","variableValue":null,"variableValueType":null,"conditionType":"fixed","isFixedPeriod":false,"isDynamicPeriod":false,"isDatePeriod":false,"daysInPeriod":null,"frequencyInPeriod":null,"translated":null},{"field":"transaction.vehicle_id","operator":"not_empty","condition":"AND","value":null,"references":"vehicle","format":null,"type":"INTEGER","variableValue":null,"variableValueType":null,"conditionType":"fixed","isFixedPeriod":false,"isDynamicPeriod":false,"isDatePeriod":false,"daysInPeriod":null,"frequencyInPeriod":null,"translated":null},{"field":"transaction.register_type","operator":"$ne","condition":"AND","value":["Abastecimento"],"references":null,"format":"list:transactionRegisterTypes","type":"STRING","variableValue":null,"variableValueType":null,"conditionType":"fixed","isFixedPeriod":false,"isDynamicPeriod":false,"isDatePeriod":false,"translated":null},{"field":"transaction.supplier_id","operator":"equal","condition":"AND","value":[2290],"references":"supplier","format":null,"type":"INTEGER","variableValue":null,"variableValueType":null,"conditionType":"fixed","isFixedPeriod":false,"isDynamicPeriod":false,"isNotInTable":false,"isDatePeriod":false,"daysInPeriod":null,"frequencyInPeriod":null,"translated":null}],"aggregates":[{"table":"transaction","column":"final_value","group":false,"sum":true,"avg":false,"max":false,"min":false}],"preview":false,"orderBy":[{"table":"transaction","column":"date","isHeaderColumn":true,"desc":false}],"groupBy":[],"having":[]} 2023-05-22 16:46:18.176+00 2023-05-22 16:49:12.235+00 276 276 276 REL-004984 table Custos total detalhado de todas as despesas, exceto abastecimentos. Despesas - custo por fornecedor mês anterior exceto abastecimentos - detalhadoo transaction
{"type":"column","categories":"vehicle.cf_141","values":[{"column":"_formula.QDE.","rawColumn":"_formula.QDE.","axis":0,"summarizer":"formula","isMainValue":true}],"legend":{"enabled":false},"show_values":{"enabled":true},"use_diferent_color":{"enabled":false},"stacked_column":{"enabled":true},"filters":{"showOnlyFirstRecords":false,"showAllRecords":true,"recordsToShow":null}} 268 1605 {"table":"vehicle","relationships":[],"type":"matrix","fields":[{"table":"_formula","column":"QDE.","type":"formula","query":"COUNT(DISTINCT vehicle.id)","showAt":{"inner":true,"total":true},"showInHours":false,"format":null,"daysEvaluatedColumns":null,"relatedTables":[{"table":"vehicle"}]},{"table":"vehicle","column":"cf_141","type":"STRING","showAt":{"inner":true,"total":true},"showInHours":false,"format":null,"daysEvaluatedColumns":null},{"table":"vehicle","column":"cf_142","type":"STRING","showAt":{"inner":true,"total":true},"showInHours":false,"format":null,"daysEvaluatedColumns":null}],"filters":[{"field":"vehicle.status","operator":"equal","condition":"AND","value":["active"],"variableValue":null,"variableValueType":null,"variableValueTranslated":null,"conditionType":"fixed","references":null,"format":"list:vehicleStatus","type":"STRING","isFixedPeriod":false,"isDatePeriod":false,"isDynamicPeriod":false,"isNotInTable":false,"translated":null,"lineNumber":1},{"field":"vehicle.cf_379","operator":"equal","condition":"AND","value":["CAVALO","UTILITARIO","TRUCK"],"variableValue":null,"variableValueType":null,"variableValueTranslated":null,"conditionType":"fixed","references":null,"format":null,"type":"STRING","isFixedPeriod":false,"isDatePeriod":false,"isDynamicPeriod":false,"isNotInTable":false,"translated":null,"lineNumber":2}],"aggregates":[{"table":"vehicle","column":"cf_141","group":true,"sum":null,"avg":null,"max":null,"min":null,"matrix_type":"horizontal","translated":"Modelo RG LOG","id":"vehicle.cf_141"},{"table":"vehicle","column":"cf_142","group":true,"sum":null,"avg":null,"max":null,"min":null,"matrix_type":"vertical","translated":"Marca RG LOG","id":"vehicle.cf_142"}],"preview":false,"orderBy":[{"table":"vehicle","column":"cf_141","isHeaderColumn":true,"desc":false}],"groupBy":[]} 2022-09-21 13:00:44.33+00 2022-09-21 13:19:47.524+00 870 870 870 REL-001605 matrix Quantidade de veículos por modelo QDE POR MODELO VEICULOS vehicle
{"type":"column","categories":"vehicle.cf_141","values":[{"column":"_formula.QDE.","rawColumn":"_formula.QDE.","axis":0,"summarizer":"formula","isMainValue":true}],"legend":{"enabled":false},"show_values":{"enabled":true},"use_diferent_color":{},"stacked_column":{"enabled":true},"filters":{"showOnlyFirstRecords":false,"showAllRecords":true,"recordsToShow":null}} 268 1608 {"table":"vehicle","relationships":[],"type":"matrix","fields":[{"table":"_formula","column":"QDE.","type":"formula","query":"COUNT(DISTINCT vehicle.id)","showAt":{"inner":true,"total":true},"showInHours":false,"format":null,"daysEvaluatedColumns":null,"relatedTables":[{"table":"vehicle"}]},{"table":"vehicle","column":"cf_141","type":"STRING","showAt":{"inner":true,"total":true},"showInHours":false,"format":null,"daysEvaluatedColumns":null},{"table":"vehicle","column":"cf_379","type":"STRING","showAt":{"inner":true,"total":true},"showInHours":false,"format":null,"daysEvaluatedColumns":null}],"filters":[{"field":"vehicle.status","operator":"equal","condition":"AND","value":["active"],"variableValue":null,"variableValueType":null,"variableValueTranslated":null,"conditionType":"fixed","references":null,"format":"list:vehicleStatus","type":"STRING","isFixedPeriod":false,"isDatePeriod":false,"isDynamicPeriod":false,"isNotInTable":false,"translated":null,"lineNumber":1},{"field":"vehicle.cf_379","operator":"equal","condition":"AND","value":["SEMIRREBOQUE","REBOQUE"],"variableValue":null,"variableValueType":null,"variableValueTranslated":null,"conditionType":"fixed","references":null,"format":null,"type":"STRING","isFixedPeriod":false,"isDatePeriod":false,"isDynamicPeriod":false,"isNotInTable":false,"translated":null,"lineNumber":2}],"aggregates":[{"table":"vehicle","column":"cf_141","group":true,"sum":null,"avg":null,"max":null,"min":null,"matrix_type":"horizontal","translated":"Modelo RG LOG","id":"vehicle.cf_141"},{"table":"vehicle","column":"cf_379","group":true,"sum":null,"avg":null,"max":null,"min":null,"matrix_type":"vertical","translated":"Tipo de Grupo","id":"vehicle.cf_379"}],"preview":false,"orderBy":[{"table":"vehicle","column":"cf_141","isHeaderColumn":true,"desc":false}],"groupBy":[]} 2022-09-21 13:20:21.603+00 2022-09-21 13:20:21.637+00 870 870 REL-001608 matrix Quantidade de CARRETAS por TIPO QDE POR MODELO CARRETAS vehicle