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
1 142 1 66 {"table":"fine","relationships":[],"type":"table","fields":[{"table":"fine","column":"name","type":"STRING","showAt":null,"format":null},{"table":"fine","column":"ait","type":"STRING","showAt":null,"format":null},{"table":"fine","column":"vehicle_id","type":"INTEGER","showAt":null,"format":null},{"table":"fine","column":"status","type":"STRING","showAt":null,"format":"list:fineStatus"},{"table":"fine","column":"description","type":"TEXT","showAt":null,"format":"list:fineDescriptions"},{"table":"fine","column":"penalty_print_date","type":"DATE","showAt":null,"format":null},{"table":"fine","column":"penalty_due_date","type":"DATE","showAt":null,"format":null},{"table":"fine","column":"penalty_total_amount","type":"DECIMAL","showAt":null,"format":"Money"}],"filters":[{"field":"fine.status","operator":"$ne","condition":"AND","value":["penalty_or_nic_paid"],"references":null,"format":"list:fineStatus","type":"STRING","isFixedPeriod":false,"isDynamicPeriod":false}],"aggregates":[],"preview":false,"orderBy":[{"table":"fine","column":"ait","isHeaderColumn":true,"desc":true}]} 2018-03-09 21:58:16.725+00 2018-05-08 18:21:35.116+00 1 1 REL-000066 table Infrações - Abertas para Liquidar fine
1 148 {"type":"column","categories":"fine_qualification.description","values":[{"column":"fine.penalty_total_amount","rawColumn":"fine.penalty_total_amount__sum__","summarizer":"sum","axis":0,"isMainValue":true}],"legend":{"enabled":true}} 1 73 {"table":"fine","relationships":["fine_qualification"],"type":"table","fields":[{"table":"fine_qualification","column":"description","type":"STRING","showAt":null,"showInHours":false,"format":null},{"table":"fine","column":"fine_qualification_id","type":"INTEGER","showAt":null,"showInHours":false,"format":null},{"table":"fine","column":"penalty_total_amount","type":"DECIMAL","showAt":null,"showInHours":false,"format":"Money"},{"table":"fine","column":"infringement_date","type":"DATE","showAt":null,"showInHours":false,"format":null},{"table":"fine","column":"vehicle_id","type":"INTEGER","showAt":null,"showInHours":false,"format":null},{"table":"fine","column":"driver_id","type":"INTEGER","showAt":null,"showInHours":false,"format":null},{"table":"_formula","column":"Quantidade","type":"formula","query":"COUNT(fine_qualification.id)","showAt":null,"showInHours":false,"format":null}],"filters":[{"field":"fine.infringement_date","operator":"dynamic_period","condition":"AND","value":"sub_12_months:last_month","references":null,"format":null,"type":"DATE","isFixedPeriod":false,"isDynamicPeriod":true}],"aggregates":[{"table":"fine","column":"penalty_total_amount","group":false,"sum":true,"avg":false,"max":false,"min":false},{"table":"fine_qualification","column":"description","group":true,"sum":false,"avg":false,"max":false,"min":false}],"preview":false,"orderBy":[{"table":"_formula","column":"Quantidade","isHeaderColumn":true,"desc":true}]} 2018-10-26 18:07:57.836+00 2019-04-23 21:16:47.276+00 1 1 REL-000073 table Ranking de infrações por tipo fine
1 141 {"type":"column","categories":"transaction.date","values":[{"column":"transaction.traveled_distance","rawColumn":"transaction.traveled_distance__sum__","summarizer":"sum","axis":0,"isMainValue":true}],"legend":{"enabled":true}} 1 63 {"table":"transaction","relationships":[],"type":"matrix","fields":[{"table":"transaction","column":"vehicle_id","type":"INTEGER","showAt":{"inner":true,"total":true},"format":null},{"table":"transaction","column":"date","type":"DATE","date_config":["month","year"],"showAt":{"inner":true,"total":true},"format":null,"is_full_period":false},{"table":"transaction","column":"traveled_distance","type":"DECIMAL","summarizers":{"sum":true,"avg":false,"max":false,"min":false},"showAt":{"inner":true,"total":true},"format":null}],"filters":[{"field":"transaction.date","operator":"dynamic_period","condition":"AND","value":"last_month:last_month","references":null,"format":null,"type":"DATE","isFixedPeriod":false,"isDynamicPeriod":true},{"field":"transaction.vehicle_id","operator":"not_empty","condition":"AND","value":null,"references":"vehicle","format":null,"type":"INTEGER","isFixedPeriod":false,"isDynamicPeriod":false}],"aggregates":[{"table":"transaction","column":"vehicle_id","group":true,"sum":null,"avg":null,"max":null,"min":null,"matrix_type":"vertical"},{"table":"transaction","column":"date","group":true,"sum":null,"avg":null,"max":null,"min":null,"matrix_type":"horizontal"},{"table":"transaction","column":"traveled_distance","group":false,"sum":true,"avg":false,"max":false,"min":false}],"preview":false,"orderBy":[{"table":"transaction","column":"date","isHeaderColumn":true,"desc":false}]} 2018-03-08 14:29:27.356+00 2018-03-08 14:29:27.356+00 1 1 REL-000063 matrix Infográfico - Distância percorrida no mês anterior transaction
1 152 1 77 {"table":"transaction","relationships":["vehicle"],"type":"matrix","fields":[{"table":"transaction","column":"vehicle_id","type":"INTEGER","showAt":{"inner":true,"total":true},"format":null},{"table":"transaction","column":"date","type":"DATE","showAt":{"inner":true,"total":true},"format":null,"date_config":["month","year"],"is_full_period":true},{"table":"_formula","column":"Abastecimentos","type":"formula","query":"SUM(transaction.fuel_supplies)","showAt":{"inner":true,"total":true},"format":null},{"table":"_formula","column":"Manutenção","type":"formula","query":"SUM(transaction.maintenance)","showAt":{"inner":true,"total":true},"format":null},{"table":"_formula","column":"Pneus","type":"formula","query":"SUM(transaction.tires)","showAt":{"inner":true,"total":true},"format":null},{"table":"_formula","column":"Outros","type":"formula","query":"SUM(transaction.others)","showAt":{"inner":true,"total":true},"format":null},{"table":"_formula","column":"Total Despesas","type":"formula","query":"SUM(transaction.expenses)","showAt":{"inner":true,"total":true},"format":null},{"table":"_formula","column":"Receitas","type":"formula","query":"SUM(transaction.revenues)","showAt":{"inner":true,"total":true},"format":null},{"table":"_formula","column":"Lucro","type":"formula","query":"SUM(transaction.revenues) - SUM(transaction.expenses)","showAt":{"inner":true,"total":true},"format":null},{"table":"_formula","column":"Margem %","type":"formula","query":"(SUM(transaction.revenues) - SUM(transaction.expenses)) * 100 / SUM(transaction.revenues)","showAt":{"inner":true,"total":true},"format":null}],"filters":[{"field":"transaction.date","operator":"dynamic_period","condition":"AND","value":"sub_12_months:last_month","references":null,"format":null,"type":"DATE","isFixedPeriod":false,"isDynamicPeriod":true},{"field":"transaction.type","operator":"equal","condition":"AND","value":["revenue","expense","tire_action"],"references":null,"format":"list:transactionTypes","type":"STRING","isFixedPeriod":false,"isDynamicPeriod":false}],"aggregates":[{"table":"transaction","column":"vehicle_id","group":true,"sum":null,"avg":null,"max":null,"min":null,"matrix_type":"vertical"},{"table":"transaction","column":"date","group":true,"sum":null,"avg":null,"max":null,"min":null,"matrix_type":"horizontal"}],"preview":false,"orderBy":[{"table":"transaction","column":"date","isHeaderColumn":true,"desc":false}],"from":"SELECT transaction.id, transaction.vehicle_id, transaction.date, transaction.type, transaction.deleted_at, CASE WHEN transaction.type = 'revenue' THEN transaction.final_value ELSE 0 END AS revenues, CASE WHEN transaction.type IN ('expense','tire_action') THEN transaction.final_value ELSE 0 END AS expenses, CASE WHEN item.cost_type = 'abastecimento' THEN transaction.final_value ELSE 0 END AS fuel_supplies, CASE WHEN item.cost_type = 'manutencao' THEN transaction.final_value ELSE 0 END AS maintenance, CASE WHEN item.cost_type = 'pneu' THEN transaction.final_value ELSE 0 END AS tires, CASE WHEN item.cost_type = 'outros' THEN transaction.final_value ELSE 0 END AS others FROM transaction LEFT OUTER JOIN item ON item.id = transaction.item_id AND item.deleted_at IS NULL"} 2018-12-12 17:08:59.063+00 2019-01-24 19:42:18.02+00 2 2 REL-000077 matrix Receitas x Tipos de custo mensais por Veículo transaction
268 1471 {"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_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}],"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":["UTILITARIO"],"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":[],"preview":false,"orderBy":[],"groupBy":[]} 2022-09-19 14:20:17.704+00 2022-09-19 14:20:20.029+00 870 870 REL-001471 table relatório para verificar veículos ativos RELATÓRIO ANALITICO SOMENTE UTILITARIOS vehicle
1 70 {"type":"line","categories":"transaction.date","values":[{"column":"transaction.distance","rawColumn":"transaction.distance__sum__","summarizer":"sum","axis":0,"isMainValue":true}],"legend":{"enabled":false}} 1 19 {"table":"transaction","relationships":["vehicle"],"type":"matrix","fields":[{"table":"transaction","column":"vehicle_id","type":"INTEGER","showAt":{"inner":true,"total":true},"format":null},{"table":"transaction","column":"date","type":"DATE","date_config":["month","year"],"showAt":{"inner":true,"total":true},"format":null,"is_full_period":false},{"table":"transaction","column":"distance","type":"DECIMAL","summarizers":{"sum":true,"avg":false,"max":false,"min":false},"showAt":{"inner":true,"total":true},"format":null},{"table":"transaction","column":"quantity","type":"DECIMAL","summarizers":{"sum":true,"avg":false,"max":false,"min":false},"showAt":{"inner":true,"total":true},"format":null},{"table":"_formula","column":"Média (km/l)","type":"formula","query":"SUM(transaction.distance) / SUM(transaction.quantity)","showAt":{"inner":true,"total":true},"format":null},{"table":"transaction","column":"final_value","type":"DECIMAL","summarizers":{"sum":true,"avg":false,"max":false,"min":false},"showAt":{"inner":true,"total":true},"format":"Money"}],"filters":[{"field":"transaction.date","operator":"dynamic_period","condition":"AND","value":"this_year:this_year","references":null,"format":null,"type":"DATE","isFixedPeriod":false,"isDynamicPeriod":true},{"field":"transaction.register_type","operator":"equal","condition":"AND","value":["Abastecimento"],"references":null,"format":"list:transactionRegisterTypes","type":"STRING","isFixedPeriod":false,"isDynamicPeriod":false},{"field":"transaction.item_id","operator":"not_empty","condition":"AND","value":null,"references":"item","format":null,"type":"INTEGER","isFixedPeriod":false,"isDynamicPeriod":false},{"field":"vehicle.consumption_type","operator":"equal","condition":"AND","value":["km/l"],"references":null,"format":"list:consumptionTypes","type":"STRING","isFixedPeriod":false,"isDynamicPeriod":false}],"aggregates":[{"table":"transaction","column":"vehicle_id","group":true,"sum":null,"avg":null,"max":null,"min":null,"matrix_type":"vertical"},{"table":"transaction","column":"date","group":true,"sum":null,"avg":null,"max":null,"min":null,"matrix_type":"horizontal"},{"table":"transaction","column":"distance","group":false,"sum":true,"avg":false,"max":false,"min":false},{"table":"transaction","column":"quantity","group":false,"sum":true,"avg":false,"max":false,"min":false},{"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}]} 2016-06-29 21:23:34.087+00 2017-11-09 18:31:39.93+00 REL-000019 matrix Abastecimentos - Abastecimentos por veículo consumo médio (km/l) mensal ano atual transaction
1 111 {"type":"column","categories":"transaction.date","values":[{"column":"transaction.final_value","rawColumn":"transaction.final_value__sum__","summarizer":"sum","axis":0,"isMainValue":true}],"legend":{"enabled":false}} 1 36 {"table":"transaction","relationships":["vehicle"],"type":"matrix","fields":[{"table":"transaction","column":"vehicle_id","type":"INTEGER","showAt":{"inner":true,"total":true},"format":null},{"table":"transaction","column":"date","type":"DATE","date_config":["month","year"],"showAt":{"inner":true,"total":true},"format":null,"is_full_period":false},{"table":"transaction","column":"final_value","type":"DECIMAL","summarizers":{"sum":true,"avg":false,"max":false,"min":false},"showAt":{"inner":true,"total":true},"format":"Money"},{"table":"_formula","column":"Horas Trabalhadas - Soma","type":"formula","query":"SUM(transaction.traveled_distance)","showAt":{"inner":true,"total":true},"format":null},{"table":"_formula","column":"Custo por hora trabalhada","type":"formula","query":"SUM(transaction.final_value) / SUM(transaction.traveled_distance)","showAt":{"inner":true,"total":true},"format":null}],"filters":[{"field":"transaction.date","operator":"dynamic_period","condition":"AND","value":"this_year:this_year","references":null,"format":null,"type":"DATE","isFixedPeriod":false,"isDynamicPeriod":true},{"field":"transaction.type","operator":"$ne","condition":"AND","value":["revenue"],"references":null,"format":"list:transactionTypes","type":"STRING","isFixedPeriod":false,"isDynamicPeriod":false},{"field":"transaction.vehicle_id","operator":"not_empty","condition":"AND","value":null,"references":"vehicle","format":null,"type":"INTEGER","isFixedPeriod":false,"isDynamicPeriod":false},{"field":"vehicle.measurement_unit","operator":"equal","condition":"AND","value":["hours"],"references":null,"format":"list:unitMeasure","type":"STRING","isFixedPeriod":false,"isDynamicPeriod":false}],"aggregates":[{"table":"transaction","column":"vehicle_id","group":true,"sum":null,"avg":null,"max":null,"min":null,"matrix_type":"vertical","translated":"Veículo","id":"transaction.vehicle_id"},{"table":"transaction","column":"date","group":true,"sum":null,"avg":null,"max":null,"min":null,"matrix_type":"horizontal","translated":"Data","id":"transaction.date"},{"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}]} 2017-10-10 20:41:26.096+00 2017-10-13 12:37:07.23+00 1 1 REL-000036 matrix Despesas - Custo por hora trabalhada mensal por veículo ano atual Apenas veículos cuja unidade de medida é Hora irão aparecer no relatório Despesas - Custo por hora trabalhada mensal por veículo ano atual transaction
1 57 {"type":"column","categories":"gate_appointment.vehicle_id","values":[{"column":"gate_appointment.distance_between_gates","rawColumn":"gate_appointment.distance_between_gates__sum__","axis":0,"summarizer":"sum","isMainValue":true}],"legend":{"enabled":true}} 1 20 {"table":"gate_appointment","relationships":["vehicle","driver","route","trip"],"type":"table","fields":[{"table":"gate_appointment","column":"vehicle_id","type":"INTEGER","showAt":null,"format":null},{"table":"gate_appointment","column":"trip_id","type":"INTEGER","showAt":null,"format":null},{"table":"gate_appointment","column":"name","type":"STRING","showAt":null,"format":null},{"table":"gate_appointment","column":"driver_id","type":"INTEGER","showAt":null,"format":null},{"table":"gate_appointment","column":"route_id","type":"INTEGER","showAt":null,"format":null},{"table":"gate_appointment","column":"exit_date","type":"DATE","showAt":null,"format":null},{"table":"gate_appointment","column":"exit_odometer","type":"DECIMAL","showAt":null,"format":null},{"table":"gate_appointment","column":"entrance_date","type":"DATE","showAt":null,"format":null},{"table":"gate_appointment","column":"entrance_odometer","type":"DECIMAL","showAt":null,"format":null},{"table":"gate_appointment","column":"distance_between_gates","type":"DECIMAL","showAt":null,"format":null}],"filters":[{"field":"gate_appointment.exit_date","operator":"dynamic_period","condition":"AND","value":"sub_60_days:this_day","references":null,"format":null,"type":"DATE","isFixedPeriod":false,"isDynamicPeriod":true}],"aggregates":[{"table":"gate_appointment","column":"vehicle_id","group":true,"sum":false,"avg":false,"max":false,"min":false,"translated":"Veículo","id":"gate_appointment.vehicle_id"},{"table":"gate_appointment","column":"distance_between_gates","group":false,"sum":true,"avg":false,"max":false,"min":false}],"preview":false,"orderBy":[{"table":"gate_appointment","column":"exit_date","isHeaderColumn":true,"desc":true}]} 2016-06-29 21:23:34.041+00 2017-10-13 12:50:47.328+00 REL-000020 table Controles de portaria - Histórico dos controles de portaria últimos 60 dias gate_appointment
1 63 {"type":"column","categories":"trip.vehicle_id","values":[{"column":"trip.total_income","rawColumn":"trip.total_income__sum__","summarizer":"sum","axis":0,"isMainValue":true}],"legend":{"enabled":true}} 1 34 {"table":"trip","relationships":["employee","vehicle","route"],"type":"table","fields":[{"table":"trip","column":"vehicle_id","type":"INTEGER","showAt":null,"format":null},{"table":"trip","column":"name","type":"STRING","showAt":null,"format":null},{"table":"trip","column":"date","type":"DATE","showAt":null,"format":null},{"table":"trip","column":"route_id","type":"INTEGER","showAt":null,"format":null},{"table":"trip","column":"total_income","type":"DECIMAL","showAt":null,"format":null},{"table":"trip","column":"total_cost","type":"DECIMAL","showAt":null,"format":null},{"table":"trip","column":"margin","type":"DECIMAL","showAt":null,"format":null},{"table":"trip","column":"distance","type":"DECIMAL","showAt":null,"format":null},{"table":"trip","column":"cost_distance","type":"DECIMAL","showAt":null,"format":null},{"table":"trip","column":"balance_distance","type":"DECIMAL","showAt":null,"format":null},{"table":"_formula","column":"Lucro por Km rodado","type":"formula","query":"( SUM(trip.total_income) - SUM(trip.total_cost) ) / SUM(trip.distance)\n\n","showAt":null,"format":null}],"filters":[{"field":"trip.status","operator":"equal","condition":"AND","value":["Terminada"],"references":null,"format":"list:tripStatus","type":"STRING"}],"aggregates":[{"table":"trip","column":"total_income","group":false,"sum":true,"avg":false,"max":false,"min":false},{"table":"trip","column":"total_cost","group":false,"sum":true,"avg":false,"max":false,"min":false},{"table":"trip","column":"margin","group":false,"sum":true,"avg":false,"max":false,"min":false},{"table":"trip","column":"distance","group":false,"sum":true,"avg":false,"max":false,"min":false},{"table":"trip","column":"vehicle_id","group":true,"sum":false,"avg":false,"max":false,"min":false}],"preview":false,"orderBy":[{"table":"trip","column":"date","isHeaderColumn":true,"desc":true}]} 2016-06-29 21:23:34.077+00 2018-01-08 12:25:12.791+00 REL-000034 table Viagens - DRE das viagens terminadas por veículo trip
1 128 {"type":"column","categories":"transaction.vehicle_id","values":[{"column":"transaction.final_value","rawColumn":"transaction.final_value__sum__","axis":0,"summarizer":"sum","isMainValue":true}],"legend":{"enabled":false}} 1 49 {"table":"transaction","relationships":["item"],"type":"matrix","fields":[{"table":"transaction","column":"date","type":"DATE","date_config":["month","year"],"showAt":{"inner":true,"total":true},"format":null,"is_full_period":false,"translated":"Data"},{"table":"transaction","column":"vehicle_id","type":"INTEGER","showAt":{"inner":true,"total":true},"format":null,"translated":"Veículo"},{"table":"transaction","column":"final_value","type":"DECIMAL","summarizers":{"sum":true,"avg":false,"max":false,"min":false},"showAt":{"inner":true,"total":true},"format":"Money","translated":"Valor total"}],"filters":[{"field":"transaction.date","operator":"dynamic_period","condition":"AND","value":"last_month:last_month","references":null,"format":null,"type":"DATE","isFixedPeriod":false,"isDynamicPeriod":true},{"field":"transaction.vehicle_id","operator":"not_empty","condition":"AND","value":null,"references":"vehicle","format":null,"type":"INTEGER","isFixedPeriod":false,"isDynamicPeriod":false},{"field":"transaction.item_id","operator":"not_empty","condition":"AND","value":null,"references":"item","format":null,"type":"INTEGER","isFixedPeriod":false,"isDynamicPeriod":false},{"field":"item.cost_type","operator":"equal","condition":"AND","value":["manutencao"],"references":null,"format":"list:transactionCostTypes","type":"STRING","isFixedPeriod":false,"isDynamicPeriod":false}],"aggregates":[{"table":"transaction","column":"date","group":true,"sum":null,"avg":null,"max":null,"min":null,"matrix_type":"horizontal","translated":"Data","id":"transaction.date"},{"table":"transaction","column":"vehicle_id","group":true,"sum":null,"avg":null,"max":null,"min":null,"matrix_type":"vertical","translated":"Veículo","id":"transaction.vehicle_id"},{"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}]} 2017-11-07 17:17:21.764+00 2018-06-29 13:05:28.115+00 1 1 REL-000049 matrix Infográfico - Manutenção por veículo mês anterior transaction