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 54 {"type":"donut","categories":"transaction.vehicle_id","values":[{"column":"transaction.potential_economy_value","rawColumn":"transaction.potential_economy_value__sum__","axis":0,"summarizer":"sum","isMainValue":true}],"legend":{"enabled":false}} 1 15 {"table":"transaction","relationships":["vehicle","item"],"type":"table","fields":[{"table":"transaction","column":"vehicle_id","type":"INTEGER","showAt":null,"format":null},{"table":"transaction","column":"expense_id","type":"INTEGER","showAt":null,"format":null},{"table":"transaction","column":"date","type":"DATE","showAt":null,"format":null},{"table":"transaction","column":"item_id","type":"INTEGER","showAt":null,"format":null},{"table":"transaction","column":"real_consumption","type":"DECIMAL","showAt":null,"format":null},{"table":"transaction","column":"standard_consumption","type":"DECIMAL","showAt":null,"format":null},{"table":"transaction","column":"deviation_percentage","type":"DECIMAL","showAt":null,"format":null},{"table":"transaction","column":"potential_economy_quantity","type":"DECIMAL","showAt":null,"format":null},{"table":"transaction","column":"potential_economy_value","type":"DECIMAL","showAt":null,"format":"Money"}],"filters":[{"field":"transaction.register_type","operator":"equal","condition":"AND","value":["Abastecimento"],"references":null,"format":"list:transactionRegisterTypes","type":"STRING"},{"field":"transaction.date","operator":"dynamic_period","condition":"AND","value":"sub_60_days:this_day","references":null,"format":null,"type":"DATE","isFixedPeriod":false,"isDynamicPeriod":true},{"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":"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},{"table":"transaction","column":"vehicle_id","group":true,"sum":false,"avg":false,"max":false,"min":false,"translated":"Veículo","id":"transaction.vehicle_id"}],"preview":false,"orderBy":[{"table":"transaction","column":"date","isHeaderColumn":true,"desc":true}]} 2016-06-29 21:23:34.024+00 2018-03-21 12:27:52.418+00 REL-000015 table Abastecimentos - Auditoria da economia potencial por veículo últimos 60 dias transaction
1 1 160 1 5017 {"table":"vehicle","relationships":["employee","employee_role","model"],"type":"table","fields":[{"table":"vehicle","column":"employee_id","type":"INTEGER","showAt":null,"showInHours":false,"format":null,"daysEvaluatedColumns":null},{"table":"employee","column":"employee_role_id","type":"INTEGER","showAt":null,"showInHours":false,"format":null,"daysEvaluatedColumns":null},{"table":"employee_role","column":"vehicle_classes","type":"JSON","showAt":null,"showInHours":false,"format":"association:vehicle_class","daysEvaluatedColumns":null},{"table":"employee","column":"subsidiary_id","type":"INTEGER","showAt":null,"showInHours":false,"format":null,"daysEvaluatedColumns":null},{"table":"employee","column":"cost_center_id","type":"INTEGER","showAt":null,"showInHours":false,"format":null,"daysEvaluatedColumns":null},{"table":"vehicle","column":"name","type":"STRING","showAt":null,"showInHours":false,"format":null,"daysEvaluatedColumns":null},{"table":"vehicle","column":"vehicle_model_id","type":"INTEGER","showAt":null,"showInHours":false,"format":null,"daysEvaluatedColumns":null},{"table":"vehicle","column":"vehicle_model_version_id","type":"INTEGER","showAt":null,"showInHours":false,"format":null,"daysEvaluatedColumns":null},{"table":"model","column":"vehicle_brand_id","type":"INTEGER","showAt":null,"showInHours":false,"format":null,"daysEvaluatedColumns":null},{"table":"vehicle_model_class","column":"vehicle_class_id","type":"INTEGER","showAt":null,"showInHours":false,"format":null,"association":{"model":"vehicle_class","key":"id"},"daysEvaluatedColumns":null},{"table":"_formula","column":"Contador","type":"formula","query":"COUNT(DISTINCT vehicle.id)","showAt":null,"showInHours":false,"format":null,"daysEvaluatedColumns":null}],"filters":[{"field":"employee.employee_role_id","operator":"not_empty","condition":"AND","value":null,"references":"employee_role","format":null,"type":"INTEGER","fixed":true,"variableValue":null,"conditionType":"fixed","isFixedPeriod":false,"sql":"vehicle.employee_id IS NOT NULL AND vehicle_joins_employee_role.vehicle_classes :: text <> '[]' :: text AND( ( SELECT vehicle_class_id FROM vehicle_model_class WHERE vehicle_model_id = vehicle.vehicle_model_id AND ( vehicle_model_version_id = vehicle.vehicle_model_version_id OR vehicle_model_version_id IS NULL ) ORDER BY vehicle_model_version_id ASC LIMIT 1 ) NOT IN ( SELECT json_array_elements_text(vehicle_joins_employee_role.vehicle_classes) :: integer ) OR ( SELECT vehicle_class_id FROM vehicle_model_class WHERE vehicle_model_id = vehicle.vehicle_model_id AND ( vehicle_model_version_id = vehicle.vehicle_model_version_id OR vehicle_model_version_id IS NULL ) ORDER BY vehicle_model_version_id ASC LIMIT 1 ) IS NULL )","isDynamicPeriod":false,"isNotInTable":false,"isDatePeriod":false,"daysInPeriod":null,"frequencyInPeriod":null}],"aggregates":[],"preview":false,"orderBy":[],"completeFrom":"vehicle AS vehicle LEFT OUTER JOIN employee AS vehicle_joins_employee ON vehicle.employee_id = vehicle_joins_employee.id AND vehicle_joins_employee.deleted_at IS NULL LEFT OUTER JOIN vehicle_model AS vehicle_joins_model ON vehicle.vehicle_model_id = vehicle_joins_model.id AND vehicle_joins_model.deleted_at IS NULL LEFT OUTER JOIN subsidiary AS employee_joins_subsidiary ON vehicle_joins_employee.subsidiary_id = employee_joins_subsidiary.id AND employee_joins_subsidiary.deleted_at IS NULL LEFT OUTER JOIN cost_center AS employee_joins_cost_center ON vehicle_joins_employee.cost_center_id = employee_joins_cost_center.id AND employee_joins_cost_center.deleted_at IS NULL LEFT OUTER JOIN vehicle_model_version AS vehicle_joins_modelversion ON vehicle.vehicle_model_version_id = vehicle_joins_modelversion.id AND vehicle_joins_modelversion.deleted_at IS NULL LEFT OUTER JOIN vehicle_brand AS model_joins_brand ON vehicle_joins_model.vehicle_brand_id = model_joins_brand.id AND model_joins_brand.deleted_at IS NULL LEFT OUTER JOIN employee_role AS employee_joins_role ON vehicle_joins_employee.employee_role_id = employee_joins_role.id LEFT OUTER JOIN employee_role AS vehicle_joins_employee_role ON vehicle_joins_employee.employee_role_id = vehicle_joins_employee_role.id LEFT OUTER JOIN vehicle_class AS vehicle_model_class_joins_vehicle_class ON vehicle_model_class_joins_vehicle_class.id =( SELECT vehicle_class_id FROM vehicle_model_class WHERE vehicle_model_id = vehicle.vehicle_model_id AND ( vehicle_model_version_id = vehicle.vehicle_model_version_id OR vehicle_model_version_id IS NULL ) ORDER BY vehicle_model_version_id ASC LIMIT 1 )"} 2023-07-13 03:04:39.726+00 2023-07-13 03:04:39.742+00 REL-005017 table Colaborador com classe com veículo diferente da classe vehicle
268 1433 {"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},{"table":"vehicle","column":"created_at","type":"DATE","showAt":null,"showInHours":false,"format":null,"daysEvaluatedColumns":null},{"table":"vehicle","column":"acquisition_date","type":"DATE","showAt":null,"showInHours":false,"format":null,"daysEvaluatedColumns":null},{"table":"vehicle","column":"credtudo_updated_date","type":"STRING","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-18 13:42:36.51+00 2022-09-21 14:14:03.234+00 2022-09-21 14:14:03.22+00 870 870 870 870 REL-001433 table relatório para verificar veículos ativos RELATÓRIO ANALITICO VEICULOS vehicle
103 326 {"table":"transaction","relationships":["service_order","vehicle","item","foreseen_service_order_item"],"type":"table","fields":[{"table":"transaction","column":"vehicle_id","type":"INTEGER","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_142","type":"STRING","showAt":null,"showInHours":false,"format":null,"daysEvaluatedColumns":null},{"table":"transaction","column":"service_order_id","type":"INTEGER","showAt":null,"showInHours":false,"format":null,"daysEvaluatedColumns":null},{"table":"transaction","column":"date","type":"DATE","showAt":null,"showInHours":false,"format":null,"daysEvaluatedColumns":null},{"table":"transaction","column":"final_value","type":"DECIMAL","showAt":null,"showInHours":false,"format":"Money","daysEvaluatedColumns":null},{"table":"transaction","column":"item_id","type":"INTEGER","showAt":null,"showInHours":false,"format":null,"daysEvaluatedColumns":null},{"table":"foreseen_service_order_item","column":"item_id","type":"INTEGER","showAt":null,"showInHours":false,"format":null,"daysEvaluatedColumns":null},{"table":"service_order","column":"problem_description","type":"TEXT","showAt":null,"showInHours":false,"format":null,"daysEvaluatedColumns":null},{"table":"service_order","column":"forecast_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_start_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":"transaction","column":"item_description","type":"TEXT","showAt":null,"showInHours":false,"format":null,"daysEvaluatedColumns":null},{"table":"_formula","column":"Tempo parado","type":"formula","query":"DATE_DIFF('hours', service_order.service_start_date, service_order.service_finish_date)","showAt":null,"showInHours":true,"format":null,"daysEvaluatedColumns":null,"relatedTables":[{"table":"service_order"},{"table":"service_order"}]},{"table":"_formula","column":"Tempo previsto ","type":"formula","query":"DATE_DIFF('hours', service_order.forecast_start_date, service_order.forecast_finish_date)","showAt":null,"showInHours":false,"format":null,"daysEvaluatedColumns":null,"relatedTables":[{"table":"service_order"},{"table":"service_order"}]},{"table":"transaction","column":"supplier_id","type":"INTEGER","showAt":null,"showInHours":false,"format":null,"daysEvaluatedColumns":null},{"table":"service_order","column":"final_odometer","type":"DECIMAL","showAt":null,"showInHours":false,"format":null,"daysEvaluatedColumns":null},{"table":"transaction","column":"created_by_id","type":"INTEGER","showAt":null,"showInHours":false,"format":null,"daysEvaluatedColumns":null}],"filters":[{"field":"transaction.service_order_id","operator":"$ne","condition":"AND","value":null,"variableValue":null,"variableValueType":null,"variableValueTranslated":null,"conditionType":"fixed","references":"service_order","format":null,"type":"INTEGER","isDatePeriod":false,"translated":null,"lineNumber":1},{"field":"transaction.final_value","operator":"$gte","condition":"AND","value":0.01,"variableValue":null,"variableValueType":null,"variableValueTranslated":null,"conditionType":"fixed","references":null,"format":null,"type":"DECIMAL","isDatePeriod":false,"translated":null,"lineNumber":2},{"field":"transaction.date","operator":"$gte","condition":"AND","value":"2023-07-01T03:00:00.000Z","variableValue":null,"variableValueType":null,"variableValueTranslated":null,"conditionType":"fixed","references":null,"format":null,"type":"DATE","isFixedPeriod":true,"isDatePeriod":false,"isDynamicPeriod":false,"isNotInTable":false,"translated":null,"lineNumber":3},{"field":"transaction.date","operator":"$lte","condition":"AND","value":"2023-10-01T02:59:59.999Z","variableValue":null,"variableValueType":null,"variableValueTranslated":null,"conditionType":"fixed","references":null,"format":null,"type":"DATE","isFixedPeriod":true,"isDatePeriod":false,"isDynamicPeriod":false,"isNotInTable":false,"translated":null,"lineNumber":3}],"aggregates":[{"table":"transaction","column":"final_value","group":false,"sum":true,"avg":false,"max":false,"min":false}],"preview":false,"orderBy":[{"table":"transaction","column":"vehicle_id","isHeaderColumn":false,"desc":true}],"groupBy":[]} 2022-08-03 20:01:08.865+00 2024-03-04 14:58:23.011+00 77 276 77 REL-000326 table Mostra todas as informações de manutenção realizadas Histórico de manutenção transaction
{"type":"column","categories":"transaction.date","values":[{"column":"transaction.final_value","rawColumn":"transaction.final_value__sum__","axis":0,"summarizer":"sum","isMainValue":true}],"legend":{"enabled":true},"filters":{"showOnlyFirstRecords":false,"showAllRecords":true,"recordsToShow":null},"show_values":{"enabled":true}} 235 4745 {"table":"transaction","relationships":[],"type":"matrix","fields":[{"table":"transaction","column":"date","type":"DATE","date_config":["month","year"],"showAt":{"inner":true,"total":true},"showInHours":false,"format":null,"daysEvaluatedColumns":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},"showInHours":false,"format":"Money","daysEvaluatedColumns":null},{"table":"transaction","column":"item_id","type":"INTEGER","showAt":{"inner":true,"total":true},"showInHours":false,"format":null,"daysEvaluatedColumns":null}],"filters":[{"field":"transaction.supplier_id","operator":"equal","condition":"AND","value":[2290],"variableValue":null,"variableValueType":null,"variableValueTranslated":null,"conditionType":"fixed","references":"supplier","format":null,"type":"INTEGER","isFixedPeriod":false,"isDatePeriod":false,"isDynamicPeriod":false,"isNotInTable":false,"translated":null,"lineNumber":1},{"field":"transaction.date","operator":"dynamic_period","condition":"AND","value":"this_year:this_year","variableValue":null,"variableValueType":null,"variableValueTranslated":null,"conditionType":"fixed","references":null,"format":null,"type":"DATE","isFixedPeriod":false,"isDatePeriod":false,"isDynamicPeriod":true,"isNotInTable":false,"translated":null,"lineNumber":2}],"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":"item_id","group":true,"sum":null,"avg":null,"max":null,"min":null,"matrix_type":"vertical","translated":"Item","id":"transaction.item_id"}],"preview":false,"orderBy":[{"table":"transaction","column":"date","isHeaderColumn":true,"desc":false}],"groupBy":[]} 2023-03-06 11:19:45.765+00 2023-03-06 11:19:45.78+00 870 870 REL-004745 matrix Gastos acumulados no ano de 2023 por tipo Move Mais Total gasto acumulado ano atual (MOVE MAIS) transaction
1 53 {"type":"column","categories":"transaction.vehicle_id","values":[{"column":"_formula.Média (km/l)","rawColumn":"_formula.Média (km/l)","axis":0,"summarizer":"formula","isMainValue":true}],"legend":{"enabled":false}} 1 22 {"table":"transaction","relationships":["vehicle"],"type":"table","fields":[{"table":"transaction","column":"vehicle_id","type":"INTEGER","showAt":null,"format":null},{"table":"transaction","column":"expense_id","type":"INTEGER","showAt":null,"format":null},{"table":"transaction","column":"item_id","type":"INTEGER","showAt":null,"format":null},{"table":"transaction","column":"date","type":"DATE","showAt":null,"format":null},{"table":"transaction","column":"final_value","type":"DECIMAL","showAt":null,"format":"Money"},{"table":"transaction","column":"odometer","type":"DECIMAL","showAt":null,"format":null},{"table":"transaction","column":"distance","type":"DECIMAL","showAt":null,"format":null},{"table":"transaction","column":"quantity","type":"DECIMAL","showAt":null,"format":null},{"table":"transaction","column":"real_consumption","type":"DECIMAL","showAt":null,"format":null},{"table":"transaction","column":"standard_consumption","type":"DECIMAL","showAt":null,"format":null},{"table":"transaction","column":"deviation_percentage","type":"DECIMAL","showAt":null,"format":null},{"table":"_formula","column":"Média (km/l)","type":"formula","query":"SUM(transaction.distance) / SUM(transaction.quantity)","showAt":null,"format":null}],"filters":[{"field":"transaction.register_type","operator":"equal","condition":"AND","value":["Abastecimento"],"references":null,"format":"list:transactionRegisterTypes","type":"STRING","isFixedPeriod":false,"isDynamicPeriod":false},{"field":"transaction.date","operator":"dynamic_period","condition":"AND","value":"sub_60_days:this_day","references":null,"format":null,"type":"DATE","isFixedPeriod":false,"isDynamicPeriod":true},{"field":"vehicle.consumption_type","operator":"equal","condition":"AND","value":["km/l"],"references":null,"format":"list:consumptionTypes","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":"vehicle_id","group":true,"sum":false,"avg":false,"max":false,"min":false,"translated":"Veículo","id":"transaction.vehicle_id"},{"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.02+00 2018-12-11 17:02:46.999+00 REL-000022 table Auditoria dos abastecimentos por veículo, e a média de em km/l, Nos últimos 60 dias Abastecimentos - Auditoria dos abastecimentos por veículo consumo médio (km/l) U60d transaction
1 51 {"type":"column","categories":"transaction.employee_id","values":[{"column":"transaction.distance","rawColumn":"transaction.distance__sum__","summarizer":"sum","axis":0,"isMainValue":true}],"legend":{"enabled":false}} 1 16 {"table":"transaction","relationships":["vehicle"],"type":"table","fields":[{"table":"transaction","column":"employee_id","type":"INTEGER","showAt":null,"format":null},{"table":"transaction","column":"expense_id","type":"INTEGER","showAt":null,"format":null},{"table":"transaction","column":"vehicle_id","type":"INTEGER","showAt":null,"format":null},{"table":"transaction","column":"item_id","type":"INTEGER","showAt":null,"format":null},{"table":"transaction","column":"date","type":"DATE","showAt":null,"format":null},{"table":"transaction","column":"odometer","type":"DECIMAL","showAt":null,"format":null},{"table":"transaction","column":"distance","type":"DECIMAL","showAt":null,"format":null},{"table":"transaction","column":"quantity","type":"DECIMAL","showAt":null,"format":null},{"table":"transaction","column":"final_value","type":"DECIMAL","showAt":null,"format":"Money"},{"table":"transaction","column":"real_consumption","type":"DECIMAL","showAt":null,"format":null},{"table":"_formula","column":"Consumo médio (km/l)","type":"formula","query":"SUM(transaction.distance) / SUM(transaction.quantity)","showAt":null,"format":null}],"filters":[{"field":"transaction.register_type","operator":"equal","condition":"AND","value":["Abastecimento"],"references":null,"format":"list:transactionRegisterTypes","type":"STRING","isFixedPeriod":false,"isDynamicPeriod":false},{"field":"transaction.date","operator":"dynamic_period","condition":"AND","value":"sub_60_days:this_day","references":null,"format":null,"type":"DATE","isFixedPeriod":false,"isDynamicPeriod":true},{"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":"employee_id","group":true,"sum":false,"avg":false,"max":false,"min":false},{"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.009+00 2017-10-26 12:23:50.996+00 REL-000016 table Abastecimentos - Abastecimentos por colaborador consumo médio (km/l) últimos 60 dias transaction
1 102 {"type":"column","categories":"vehicle_maintenance_plan.vehicle_id","values":[{"column":"vehicle_maintenance_plan_service.due_utilization","rawColumn":"vehicle_maintenance_plan_service.due_utilization__min__","summarizer":"min","axis":0,"isMainValue":true}],"legend":{"enabled":true}} 1 1 {"table":"vehicle_maintenance_plan_service","relationships":["vehicle_maintenance_plan","maint_plan_ser"],"type":"table","fields":[{"table":"vehicle_maintenance_plan","column":"vehicle_id","type":"INTEGER","showAt":null,"format":null},{"table":"vehicle_maintenance_plan","column":"status","type":"STRING","showAt":null,"format":"list:vehicleMaintenancePlanStatuses"},{"table":"maint_plan_ser","column":"service_id","type":"INTEGER","showAt":null,"format":null},{"table":"maint_plan_ser","column":"period_usage","type":"DECIMAL","showAt":null,"format":null},{"table":"vehicle_maintenance_plan_service","column":"l_exec_so_id","type":"INTEGER","showAt":null,"format":null},{"table":"vehicle_maintenance_plan_service","column":"last_execution_date","type":"DATE","showAt":null,"format":null},{"table":"vehicle_maintenance_plan_service","column":"last_execution_counter","type":"DECIMAL","showAt":null,"format":null},{"table":"vehicle_maintenance_plan_service","column":"current_utilization","type":"DECIMAL","showAt":null,"format":null},{"table":"vehicle_maintenance_plan_service","column":"due_utilization","type":"DECIMAL","showAt":null,"format":null},{"table":"vehicle_maintenance_plan_service","column":"open_service_order_id","type":"INTEGER","showAt":null,"format":null}],"filters":[{"field":"maint_plan_ser.status","operator":"equal","condition":"AND","value":["active"],"references":null,"format":"list:maintenancePlanServiceStatus","type":"STRING"},{"field":"vehicle_maintenance_plan.control_end_date","operator":"empty","condition":"AND","value":null,"references":null,"format":null,"type":"DATE","isFixedPeriod":false,"isDynamicPeriod":false}],"aggregates":[{"table":"vehicle_maintenance_plan","column":"vehicle_id","group":true,"sum":false,"avg":false,"max":false,"min":false},{"table":"vehicle_maintenance_plan_service","column":"due_utilization","group":false,"sum":false,"avg":false,"max":false,"min":true}],"preview":false,"orderBy":[{"table":"vehicle_maintenance_plan","column":"vehicle_id","isHeaderColumn":true,"desc":true}]} 2016-07-04 18:04:09.565+00 2018-10-26 14:16:59.925+00 REL-000001 table Planos de manutenção - Situação atual dos planos de manutenção vehicle_maintenance_plan_service
1 75 {"type":"line","categories":"transaction.date","values":[{"column":"_formula.Média (km/l)","rawColumn":"_formula.Média (km/l)","summarizer":"formula","axis":0,"isMainValue":true}],"legend":{"enabled":false}} 1 25 {"table":"transaction","relationships":["vehicle","employee"],"type":"matrix","fields":[{"table":"employee","column":"name","type":"STRING","showAt":{"inner":true,"total":true},"format":null},{"table":"transaction","column":"date","type":"DATE","date_config":["month","year"],"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":"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}],"filters":[{"field":"transaction.register_type","operator":"equal","condition":"AND","value":["Abastecimento"],"references":null,"format":"list:transactionRegisterTypes","type":"STRING"},{"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.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":"employee","column":"name","group":true,"sum":null,"avg":null,"max":null,"min":null,"matrix_type":"vertical","translated":"Nome","id":"employee.name"},{"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":"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}],"preview":false,"orderBy":[{"table":"transaction","column":"date","isHeaderColumn":true,"desc":false},{"table":"employee","column":"name","isHeaderColumn":true,"desc":false}]} 2016-06-29 21:23:34.11+00 2017-10-26 12:23:32.909+00 REL-000025 matrix Abastecimentos - Abastecimentos por colaborador consumo médio (km/l) mensal ano atual transaction
367 2121 {"table":"vehicle","relationships":[],"type":"table","fields":[{"table":"vehicle","column":"license_plate","type":"STRING","showAt":null,"showInHours":false,"format":null,"daysEvaluatedColumns":null},{"table":"vehicle","column":"name","type":"STRING","showAt":null,"showInHours":false,"format":null,"daysEvaluatedColumns":null}],"filters":[],"aggregates":[],"preview":false,"orderBy":[],"groupBy":[]} 2022-09-29 13:38:33.925+00 2022-09-29 13:38:33.944+00 514 514 REL-002121 table Veículos ativos - apagar depois vehicle