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 149 1 75 {"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","showAt":{"inner":true,"total":true},"format":null,"date_config":["month","year"],"is_full_period":true},{"table":"_formula","column":"Receitas","type":"formula","query":"SUM(transaction.revenues)","showAt":{"inner":true,"total":true},"format":null},{"table":"_formula","column":"Despesas","type":"formula","query":"SUM(transaction.expenses)","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 FROM transaction"} 2018-12-12 17:09:15.749+00 2019-01-24 19:42:09.243+00 2 2 REL-000075 matrix Receita x Despesas mensais por Veículo transaction
2 2220 {"table":"service_order","relationships":[],"type":"table","fields":[{"table":"service_order","column":"vehicle_id","type":"INTEGER","showAt":null,"showInHours":false,"format":null,"daysEvaluatedColumns":null},{"table":"service_order","column":"name","type":"STRING","showAt":null,"showInHours":false,"format":null,"daysEvaluatedColumns":null},{"table":"service_order","column":"type","type":"STRING","showAt":null,"showInHours":false,"format":"list:serviceOrderTypes","daysEvaluatedColumns":null},{"table":"service_order","column":"status","type":"STRING","showAt":null,"showInHours":false,"format":"list:serviceOrderStatus","daysEvaluatedColumns":null},{"table":"service_order","column":"service_start_date","type":"DATE","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":"service_finish_date","type":"DATE","showAt":null,"showInHours":false,"format":null,"daysEvaluatedColumns":null},{"table":"service_order","column":"doc_number","type":"STRING","showAt":null,"showInHours":false,"format":null,"daysEvaluatedColumns":null},{"table":"service_order","column":"total_cost","type":"DECIMAL","showAt":null,"showInHours":false,"format":"Money","daysEvaluatedColumns":null},{"table":"service_order","column":"request_reason","type":"STRING","showAt":null,"showInHours":false,"format":"list:requestReasonsSO","daysEvaluatedColumns":null}],"filters":[{"field":"service_order.vehicle_id","operator":"not_empty","condition":"AND","value":null,"variableValue":null,"variableValueType":null,"variableValueTranslated":null,"conditionType":"fixed","references":"vehicle","format":null,"type":"INTEGER","isFixedPeriod":false,"isDatePeriod":false,"isDynamicPeriod":false,"isNotInTable":false,"translated":null,"lineNumber":1},{"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":2}],"aggregates":[{"table":"service_order","column":"total_cost","group":false,"sum":true,"avg":false,"max":false,"min":false,"stddev":false}],"preview":false,"orderBy":[],"groupBy":[]} 2022-09-29 19:00:22.292+00 2022-09-29 19:00:23.163+00 870 870 REL-002220 table Relatório utiliza a previsão da data de término para o período As ordens Aguardando NF e Terminadas possuem data de término. Ordens de Serviço - Custos com ordens de serviço por veículo V2 service_order
{"type":"bar","categories":"vehicle.cf_36","values":[{"column":"_formula.QDE. TIPO","rawColumn":"_formula.QDE. TIPO","summarizer":"formula","axis":0,"isMainValue":true}],"legend":{"enabled":false},"filters":{"showOnlyFirstRecords":false,"showAllRecords":true,"recordsToShow":null},"show_values":{"enabled":true}} 268 4779 {"table":"vehicle","relationships":[],"type":"matrix","fields":[{"table":"_formula","column":"QDE. TIPO","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_379","type":"STRING","showAt":{"inner":true,"total":true},"showInHours":false,"format":null,"daysEvaluatedColumns":null},{"table":"vehicle","column":"cf_36","type":"STRING","showAt":{"inner":true,"total":true},"showInHours":false,"format":null,"daysEvaluatedColumns":null},{"table":"vehicle","column":"license_plate","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},{"table":"vehicle","column":"cf_141","type":"STRING","showAt":{"inner":true,"total":true},"showInHours":false,"format":null,"daysEvaluatedColumns":null},{"table":"vehicle","column":"fabrication_year","type":"INTEGER","showAt":{"inner":true,"total":true},"showInHours":false,"format":null,"daysEvaluatedColumns":null},{"table":"vehicle","column":"model_year","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":["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_379","group":true,"sum":null,"avg":null,"max":null,"min":null,"matrix_type":"vertical","translated":"Tipo de Grupo","id":"vehicle.cf_379"},{"table":"vehicle","column":"cf_36","group":true,"sum":null,"avg":null,"max":null,"min":null,"matrix_type":"horizontal","translated":"Classificação","id":"vehicle.cf_36"},{"table":"vehicle","column":"license_plate","group":true,"sum":null,"avg":null,"max":null,"min":null,"matrix_type":"vertical"},{"table":"vehicle","column":"cf_142","group":true,"sum":null,"avg":null,"max":null,"min":null,"matrix_type":"vertical"},{"table":"vehicle","column":"cf_141","group":true,"sum":null,"avg":null,"max":null,"min":null,"matrix_type":"vertical"},{"table":"vehicle","column":"fabrication_year","group":true,"sum":null,"avg":null,"max":null,"min":null,"matrix_type":"vertical"},{"table":"vehicle","column":"model_year","group":true,"sum":null,"avg":null,"max":null,"min":null,"matrix_type":"vertical"}],"preview":false,"orderBy":[{"table":"vehicle","column":"cf_36","isHeaderColumn":true,"desc":false}],"groupBy":[]} 2023-03-06 12:22:21.159+00 2023-03-06 12:22:21.172+00 870 870 REL-004779 matrix Quantidade de veículos por tipo QDE POR TIPOS TRUCKS. vehicle
1 132 1 56 {"table":"vehicle","relationships":["model"],"type":"table","fields":[{"table":"vehicle","column":"name","type":"STRING","showAt":null,"format":null},{"table":"vehicle","column":"license_plate","type":"STRING","showAt":null,"format":null},{"table":"vehicle","column":"status","type":"STRING","showAt":null,"format":"list:vehicleStatus"},{"table":"vehicle","column":"motorized","type":"BOOLEAN","showAt":null,"format":null},{"table":"model","column":"vehicle_brand_id","type":"INTEGER","showAt":null,"format":null},{"table":"vehicle","column":"vehicle_model_id","type":"INTEGER","showAt":null,"format":null},{"table":"vehicle","column":"vehicle_model_version_id","type":"INTEGER","showAt":null,"format":null},{"table":"vehicle","column":"vehicle_layout_id","type":"INTEGER","showAt":null,"format":null}],"filters":[],"aggregates":[],"preview":false,"orderBy":[{"table":"vehicle","column":"name","isHeaderColumn":true,"desc":true}]} 2017-12-07 19:02:33.653+00 2017-12-07 19:02:33.653+00 1 1 REL-000056 table Este relatório exibe os layouts que estão associados aos veículos. Com as informações necessárias (marca, modelo, versão) para conferência Cadastros - Veículos e seus layouts vehicle
1 153 1 76 {"table":"transaction","relationships":["subsidiary"],"type":"matrix","fields":[{"table":"transaction","column":"subsidiary_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":"subsidiary_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.subsidiary_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:50.817+00 2019-01-24 19:42:19.692+00 2 2 REL-000076 matrix Receitas x Tipos de custo mensais por Filial transaction
1 133 1 53 {"table":"vehicle_due","relationships":[],"type":"table","fields":[{"table":"vehicle_due","column":"vehicle_id","type":"INTEGER","showAt":null,"format":null},{"table":"vehicle_due","column":"item_id","type":"INTEGER","showAt":null,"format":null},{"table":"vehicle_due","column":"due_date","type":"DATE","showAt":null,"format":null},{"table":"vehicle_due","column":"recurrent_due","type":"BOOLEAN","showAt":null,"format":null}],"filters":[{"field":"vehicle_due.due_date","operator":"not_empty","condition":"AND","value":null,"references":null,"format":null,"type":"DATE","isFixedPeriod":false,"isDynamicPeriod":false}],"aggregates":[{"table":"vehicle_due","column":"vehicle_id","group":true,"sum":false,"avg":false,"max":false,"min":false}],"preview":false,"orderBy":[{"table":"vehicle_due","column":"due_date","isHeaderColumn":true,"desc":false}]} 2017-12-11 11:16:20.209+00 2017-12-11 11:16:20.209+00 1 1 REL-000053 table Listagem dos itens cadastrados na seção vencimentos do cadastro de veículo. Serve para conferir vencimentos registrados no veículo, principalmente os recorrentes. Cadastros - Vencimentos dos veículos vehicle_due
1 151 1 67 {"table":"transaction","relationships":[],"type":"matrix","fields":[{"table":"transaction","column":"cost_center_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":"Receitas","type":"formula","query":"SUM(transaction.revenues)","showAt":{"inner":true,"total":true},"format":null},{"table":"_formula","column":"Despesas","type":"formula","query":"SUM(transaction.expenses)","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":"cost_center_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.cost_center_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 FROM transaction"} 2018-12-12 17:09:03.842+00 2019-01-24 19:42:16.58+00 2 2 REL-000067 matrix Receitas x Despesas mensais por Centro de Custo transaction
1 71 {"type":"line","categories":"transaction.date","values":[{"column":"_formula.Custo por Km rodado","rawColumn":"_formula.Custo por Km rodado","summarizer":"formula","axis":0,"isMainValue":true}],"legend":{"enabled":false}} 1 18 {"table":"transaction","relationships":["vehicle"],"type":"matrix","fields":[{"table":"transaction","column":"date","type":"DATE","date_config":["month","year"],"showAt":{"inner":true,"total":true},"format":null},{"table":"_formula","column":"Custo por Km rodado","type":"formula","query":"SUM(transaction.final_value) / SUM(transaction.traveled_distance)","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"},{"table":"transaction","column":"traveled_distance","type":"DECIMAL","summarizers":{"sum":true,"avg":false,"max":false,"min":false},"showAt":{"inner":true,"total":true},"format":null},{"table":"transaction","column":"vehicle_id","type":"INTEGER","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":["km"],"references":null,"format":"list:unitMeasure","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":"final_value","group":false,"sum":true,"avg":false,"max":false,"min":false},{"table":"transaction","column":"traveled_distance","group":false,"sum":true,"avg":false,"max":false,"min":false},{"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"}],"preview":false,"orderBy":[{"table":"transaction","column":"date","isHeaderColumn":true,"desc":false}]} 2016-06-29 21:23:34.11+00 2017-10-13 12:37:22.839+00 REL-000018 matrix Despesas - Custo por km rodado mensal por veículo ano atual Apenas veículos cuja unidade de medida é KM irão aparecer no relatório Despesas - Custo por km rodado mensal por veículo ano atual transaction
268 3042 {"table":"vehicle","relationships":["group","modelversion","cost_center","model"],"type":"table","fields":[{"table":"vehicle","column":"license_plate","type":"STRING","showAt":null,"showInHours":false,"format":null,"daysEvaluatedColumns":null},{"table":"vehicle","column":"cf_611","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_379","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_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":"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":"cf_36","type":"STRING","showAt":null,"showInHours":false,"format":null,"daysEvaluatedColumns":null},{"table":"vehicle","column":"renavam","type":"STRING","showAt":null,"showInHours":false,"format":null,"daysEvaluatedColumns":null},{"table":"vehicle","column":"chassis_number","type":"STRING","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":"vehicle_group_id","type":"INTEGER","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":"cf_663","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":1}],"aggregates":[],"preview":false,"orderBy":[],"groupBy":[]} 2022-11-01 12:48:18.271+00 2022-11-01 12:48:18.465+00 870 870 REL-003042 table relatório para verificar veículos e semirreboques ativos RELATÓRIO ANALITICO VEICULOS v3 vehicle
1 69 {"type":"column","categories":"transaction.date","values":[{"column":"transaction.potential_economy_quantity","rawColumn":"transaction.potential_economy_quantity__sum__","summarizer":"sum","axis":0,"isMainValue":true}],"legend":{"enabled":true}} 1 32 {"table":"transaction","relationships":["vehicle"],"type":"matrix","fields":[{"table":"transaction","column":"date","type":"DATE","date_config":["month","year"],"showAt":{"inner":true,"total":true},"format":null},{"table":"vehicle","column":"name","type":"STRING","showAt":{"inner":true,"total":true},"format":null},{"table":"transaction","column":"potential_economy_quantity","type":"DECIMAL","summarizers":{"sum":true,"avg":false,"max":false,"min":false},"showAt":{"inner":true,"total":true},"format":null},{"table":"transaction","column":"potential_economy_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}],"aggregates":[{"table":"transaction","column":"date","group":true,"sum":null,"avg":null,"max":null,"min":null,"matrix_type":"horizontal"},{"table":"vehicle","column":"name","group":true,"sum":null,"avg":null,"max":null,"min":null,"matrix_type":"vertical"},{"table":"transaction","column":"potential_economy_quantity","group":false,"sum":true,"avg":false,"max":false,"min":false},{"table":"transaction","column":"potential_economy_value","group":false,"sum":true,"avg":false,"max":false,"min":false}],"preview":false,"orderBy":[{"table":"transaction","column":"date","isHeaderColumn":true,"desc":false},{"table":"vehicle","column":"name","isHeaderColumn":true,"desc":false}]} 2016-06-29 21:23:34.087+00 2018-11-19 16:33:25.033+00 REL-000032 matrix Abastecimentos - Economia potencial por veículo mensal ano atual transaction