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 257 {"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":"type","type":"STRING","showAt":null,"showInHours":false,"format":"list:serviceOrderTypes","daysEvaluatedColumns":null},{"table":"service_order","column":"created_at","type":"DATE","showAt":null,"showInHours":false,"format":null,"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":"service_finish_date","type":"DATE","showAt":null,"showInHours":false,"format":null,"daysEvaluatedColumns":null},{"table":"service_order","column":"vehicle_down_days","type":"DECIMAL","showAt":null,"showInHours":false,"format":null,"daysEvaluatedColumns":null},{"table":"service_order","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":"service_order","column":"problem_description","type":"TEXT","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":"observation","type":"TEXT","showAt":null,"showInHours":false,"format":null,"daysEvaluatedColumns":null},{"table":"service_order","column":"checklist_id","type":"INTEGER","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":"created_by_id","type":"INTEGER","showAt":null,"showInHours":false,"format":null,"daysEvaluatedColumns":null}],"filters":[],"aggregates":[{"table":"service_order","column":"total_cost","group":false,"sum":true,"avg":false,"max":false,"min":false,"stddev":false}],"preview":false,"orderBy":[{"table":"service_order","column":"type","isHeaderColumn":true,"desc":false}],"groupBy":[]} 2022-07-28 19:57:58.045+00 2024-03-04 15:02:27.784+00 210 276 210 REL-000257 table Relatorio de Ordem de Serviço total service_order
268 1472 {"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":7},{"field":"vehicle.cf_379","operator":"equal","condition":"AND","value":["PASSEIO"],"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":8}],"aggregates":[],"preview":false,"orderBy":[],"groupBy":[]} 2022-09-19 14:21:02.683+00 2022-09-19 14:21:02.707+00 870 870 REL-001472 table relatório para verificar veículos ativos RELATÓRIO ANALITICO SOMENTE PASSEIOS vehicle
{"type":"column","categories":"vehicle_hitch.truck_id","values":[{"column":"vehicle_hitch.finish_odometer","rawColumn":"vehicle_hitch.finish_odometer__sum__","summarizer":"sum","axis":0,"isMainValue":true}],"legend":{"enabled":true}} 2 290 {"table":"vehicle_hitch","relationships":[],"type":"table","fields":[{"table":"vehicle_hitch","column":"truck_id","type":"INTEGER","showAt":null,"showInHours":false,"format":null,"daysEvaluatedColumns":null},{"table":"vehicle_hitch","column":"start_date","type":"DATE","showAt":null,"showInHours":false,"format":null,"daysEvaluatedColumns":null},{"table":"vehicle_hitch","column":"finish_date","type":"DATE","showAt":null,"showInHours":false,"format":null,"daysEvaluatedColumns":null},{"table":"vehicle_hitch","column":"trailer_id","type":"INTEGER","showAt":null,"showInHours":false,"format":null,"daysEvaluatedColumns":null},{"table":"vehicle_hitch","column":"finish_odometer","type":"DECIMAL","showAt":null,"showInHours":false,"format":null,"daysEvaluatedColumns":null},{"table":"vehicle_hitch","column":"start_odometer","type":"DECIMAL","showAt":null,"showInHours":false,"format":null,"daysEvaluatedColumns":null},{"table":"vehicle_hitch","column":"name","type":"STRING","showAt":null,"showInHours":false,"format":null,"daysEvaluatedColumns":null}],"filters":[],"aggregates":[{"table":"vehicle_hitch","column":"truck_id","group":true,"sum":false,"avg":false,"max":false,"min":false,"stddev":false},{"table":"vehicle_hitch","column":"start_odometer","group":false,"sum":true,"avg":false,"max":false,"min":false,"stddev":false},{"table":"vehicle_hitch","column":"finish_odometer","group":false,"sum":true,"avg":false,"max":false,"min":false,"stddev":false}],"preview":false,"orderBy":[],"groupBy":[]} 2022-07-29 19:34:32.058+00 2022-07-29 19:35:17.77+00 210 210 210 REL-000290 table Relatorio de Engate e desengate vehicle_hitch
{"type":"column","categories":"deduct.subsidiary_id","values":[{"column":"deduct.total_value","rawColumn":"deduct.total_value__sum__","summarizer":"sum","axis":0,"isMainValue":true}],"legend":{"enabled":true}} 1 291 {"table":"deduct","relationships":[],"type":"table","fields":[{"table":"deduct","column":"subsidiary_id","type":"INTEGER","showAt":null,"showInHours":false,"format":null,"daysEvaluatedColumns":null},{"table":"deduct","column":"start_date","type":"DATE","showAt":null,"showInHours":false,"format":null,"daysEvaluatedColumns":null},{"table":"deduct","column":"employee_id","type":"INTEGER","showAt":null,"showInHours":false,"format":null,"daysEvaluatedColumns":null},{"table":"deduct","column":"status","type":"STRING","showAt":null,"showInHours":false,"format":"list:deductStatus","daysEvaluatedColumns":null},{"table":"deduct","column":"parcels_number","type":"INTEGER","showAt":null,"showInHours":false,"format":null,"daysEvaluatedColumns":null},{"table":"deduct","column":"observation","type":"TEXT","showAt":null,"showInHours":false,"format":null,"daysEvaluatedColumns":null},{"table":"deduct","column":"parcels_created","type":"BOOLEAN","showAt":null,"showInHours":false,"format":null,"daysEvaluatedColumns":null},{"table":"deduct","column":"total_value","type":"DECIMAL","showAt":null,"showInHours":false,"format":"Money","daysEvaluatedColumns":null}],"filters":[],"aggregates":[{"table":"deduct","column":"total_value","group":false,"sum":true,"avg":false,"max":false,"min":false,"stddev":false},{"table":"deduct","column":"subsidiary_id","group":true,"sum":false,"avg":false,"max":false,"min":false,"stddev":false}],"preview":false,"orderBy":[],"groupBy":[]} 2022-07-29 20:00:06.264+00 2022-07-29 20:00:06.406+00 210 210 REL-000291 table Relatorio de Desconto em folha deduct
1 104 1 3 {"table":"transaction","relationships":["item","service_order","vehicle","vehicle_maintenance_plan_service"],"type":"table","fields":[{"table":"vehicle_maintenance_plan_service","column":"vehicle_maintenance_plan_id","type":"INTEGER","showAt":null,"showInHours":false,"format":null,"daysEvaluatedColumns":null},{"table":"transaction","column":"item_id","type":"INTEGER","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":"service_order","column":"service_finish_date","type":"DATE","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":"foreseen_counter","type":"DECIMAL","showAt":null,"showInHours":false,"format":null,"daysEvaluatedColumns":null},{"table":"transaction","column":"preventive_efficiency","type":"STRING","showAt":null,"showInHours":false,"format":"list:preventiveEfficiency","daysEvaluatedColumns":null},{"table":"transaction","column":"foreseen_counter_diff","type":"DECIMAL","showAt":null,"showInHours":false,"format":null,"daysEvaluatedColumns":null},{"table":"transaction","column":"foreseen_date","type":"DATE","showAt":null,"showInHours":false,"format":null,"daysEvaluatedColumns":null},{"table":"transaction","column":"foreseen_date_diff","type":"DECIMAL","showAt":null,"showInHours":false,"format":null,"daysEvaluatedColumns":null},{"table":"service_order","column":"origin","type":"STRING","showAt":null,"showInHours":false,"format":"list:serviceOrderOrigins","daysEvaluatedColumns":null}],"filters":[{"field":"item.type","operator":"equal","condition":"AND","value":["Mao de Obra/Servico"],"variableValue":null,"variableValueType":null,"variableValueTranslated":null,"conditionType":"fixed","references":null,"format":"list:itemTypes","type":"STRING","isDatePeriod":false,"translated":null,"lineNumber":1},{"field":"transaction.veh_maint_plan_ser_id","operator":"not_empty","condition":"AND","value":null,"variableValue":null,"variableValueType":null,"variableValueTranslated":null,"conditionType":"fixed","references":"vehicle_maintenance_plan_service","format":null,"type":"INTEGER","isFixedPeriod":false,"isDatePeriod":false,"isDynamicPeriod":false,"translated":null,"lineNumber":2}],"aggregates":[{"table":"vehicle_maintenance_plan_service","column":"vehicle_maintenance_plan_id","group":true,"sum":false,"avg":false,"max":false,"min":false}],"preview":false,"orderBy":[{"table":"service_order","column":"service_finish_date","isHeaderColumn":true,"desc":true}],"groupBy":[]} 2016-07-04 18:05:05.524+00 2022-07-31 05:05:53.137+00 REL-000003 table Este relatório serve para acompanhar a eficiência do plano de manutenção. Planos de manutenção - Históricos dos serviços feitos do plano de manutenção (Eficiência) transaction
2 292 {"table":"vehicle_casualty","relationships":[],"type":"table","fields":[{"table":"vehicle_casualty","column":"vehicle_id","type":"INTEGER","showAt":null,"showInHours":false,"format":null,"daysEvaluatedColumns":null},{"table":"vehicle_casualty","column":"created_at","type":"DATE","showAt":null,"showInHours":false,"format":null,"daysEvaluatedColumns":null},{"table":"vehicle_casualty","column":"employee_id","type":"INTEGER","showAt":null,"showInHours":false,"format":null,"daysEvaluatedColumns":null},{"table":"vehicle_casualty","column":"vehicle_casualty_type_id","type":"INTEGER","showAt":null,"showInHours":false,"format":null,"daysEvaluatedColumns":null},{"table":"vehicle_casualty","column":"deduct_observation","type":"STRING","showAt":null,"showInHours":false,"format":null,"daysEvaluatedColumns":null},{"table":"vehicle_casualty","column":"observation_third_party_involved","type":"STRING","showAt":null,"showInHours":false,"format":null,"daysEvaluatedColumns":null},{"table":"vehicle_casualty","column":"description","type":"STRING","showAt":null,"showInHours":false,"format":null,"daysEvaluatedColumns":null},{"table":"vehicle_casualty","column":"state_id","type":"INTEGER","showAt":null,"showInHours":false,"format":null,"daysEvaluatedColumns":null},{"table":"vehicle_casualty","column":"city_id","type":"INTEGER","showAt":null,"showInHours":false,"format":null,"daysEvaluatedColumns":null},{"table":"vehicle_casualty","column":"name","type":"STRING","showAt":null,"showInHours":false,"format":null,"daysEvaluatedColumns":null},{"table":"vehicle_casualty","column":"culprit","type":"STRING","showAt":null,"showInHours":false,"format":"list:vehicleCasualtyCulprit","daysEvaluatedColumns":null},{"table":"vehicle_casualty","column":"situation","type":"STRING","showAt":null,"showInHours":false,"format":"list:vehicleCasualtySituation","daysEvaluatedColumns":null},{"table":"vehicle_casualty","column":"budget_amount","type":"DECIMAL","showAt":null,"showInHours":false,"format":"Money","daysEvaluatedColumns":null}],"filters":[],"aggregates":[{"table":"vehicle_casualty","column":"created_at","group":false,"sum":false,"avg":false,"max":false,"min":false,"stddev":false},{"table":"vehicle_casualty","column":"budget_amount","group":false,"sum":true,"avg":false,"max":false,"min":false,"stddev":false}],"preview":false,"orderBy":[],"groupBy":[]} 2022-07-29 20:03:09.672+00 2023-09-28 15:56:01.566+00 210 276 210 REL-000292 table Relatorio de Sinistro vehicle_casualty
268 1473 {"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":9},{"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":10}],"aggregates":[],"preview":false,"orderBy":[],"groupBy":[]} 2022-09-19 14:22:07.652+00 2022-09-19 14:22:07.811+00 870 870 REL-001473 table relatório para verificar veículos ativos RELATÓRIO ANALITICO SOMENTE CARRETAS vehicle
268 1612 {"table":"import_map_process","relationships":[],"type":"table","fields":[{"table":"import_map_process","column":"import_map_id","type":"INTEGER","showAt":null,"showInHours":false,"format":null,"daysEvaluatedColumns":null},{"table":"import_map_process","column":"total_records","type":"INTEGER","showAt":null,"showInHours":false,"format":null,"daysEvaluatedColumns":null},{"table":"import_map_process","column":"status","type":"STRING","showAt":null,"showInHours":false,"format":"list:importMapProcessStatus","daysEvaluatedColumns":null},{"table":"import_map_process","column":"total_errors","type":"INTEGER","showAt":null,"showInHours":false,"format":null,"daysEvaluatedColumns":null},{"table":"import_map_process","column":"created_at","type":"DATE","showAt":null,"showInHours":false,"format":null,"daysEvaluatedColumns":null},{"table":"import_map_process","column":"finish_date","type":"DATE","showAt":null,"showInHours":false,"format":null,"daysEvaluatedColumns":null},{"table":"import_map_process","column":"updated_at","type":"DATE","showAt":null,"showInHours":false,"format":null,"daysEvaluatedColumns":null},{"table":"import_map_process","column":"id","type":"INTEGER","showAt":null,"showInHours":false,"format":null,"daysEvaluatedColumns":null},{"table":"import_map_process","column":"name","type":"STRING","showAt":null,"showInHours":false,"format":null,"daysEvaluatedColumns":null},{"table":"import_map_process","column":"file_name","type":"STRING","showAt":null,"showInHours":false,"format":null,"daysEvaluatedColumns":null},{"table":"import_map_process","column":"inout_process_id","type":"STRING","showAt":null,"showInHours":false,"format":null,"daysEvaluatedColumns":null}],"filters":[{"field":"import_map_process.import_map_id","operator":"equal","condition":"AND","value":[1313],"variableValue":null,"variableValueType":null,"variableValueTranslated":null,"conditionType":"fixed","references":"import_map","format":null,"type":"INTEGER","isFixedPeriod":false,"isDatePeriod":false,"isDynamicPeriod":false,"isNotInTable":false,"translated":null,"lineNumber":1}],"aggregates":[{"table":"import_map_process","column":"import_map_id","group":true,"sum":false,"avg":false,"max":false,"min":false,"stddev":false}],"preview":false,"orderBy":[],"groupBy":[]} 2022-09-21 13:43:27.396+00 2022-09-21 13:43:27.416+00 514 514 REL-001612 table Importação - Relatório de importação import_map_process
1 155 1 72 {"table":"transaction","relationships":[],"type":"table","fields":[{"table":"transaction","column":"date","type":"DATE","showAt":null,"format":null,"date_config":["month","year"],"is_full_period":true},{"table":"_formula","column":"Receitas","type":"formula","showAt":null,"format":"money","query":"SUM(transaction.revenues)"},{"table":"_formula","column":"Despesas","type":"formula","query":"SUM(transaction.expenses)","showAt":null,"format":"money"},{"table":"_formula","column":"Lucro","type":"formula","query":"SUM(transaction.revenues) - SUM(transaction.expenses)","showAt":null,"format":"money"},{"table":"_formula","column":"Margem","type":"formula","query":"(SUM(transaction.revenues) - SUM(transaction.expenses)) / SUM(transaction.revenues)","showAt":null,"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":"date","group":true,"sum":null,"avg":null,"max":null,"min":null}],"preview":false,"orderBy":[{"table":"transaction","column":"date","isHeaderColumn":true,"desc":true}],"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","hideDetails":true} 2018-12-12 17:08:40.575+00 2022-08-03 11:34:11.618+00 2 77 2 REL-000072 table Receitas x Despesas mensais transaction
{"type":"column","categories":"transaction.vehicle_id","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}} 334 2053 {"table":"transaction","relationships":[],"type":"table","fields":[{"table":"transaction","column":"vehicle_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":"item_description","type":"TEXT","showAt":null,"showInHours":false,"format":null,"daysEvaluatedColumns":null},{"table":"transaction","column":"quantity","type":"DECIMAL","showAt":null,"showInHours":false,"format":null,"daysEvaluatedColumns":null},{"table":"transaction","column":"unit_value","type":"DECIMAL","showAt":null,"showInHours":false,"format":"Money","daysEvaluatedColumns":null},{"table":"transaction","column":"final_value","type":"DECIMAL","showAt":null,"showInHours":false,"format":"Money","daysEvaluatedColumns":null},{"table":"transaction","column":"supplier_id","type":"INTEGER","showAt":null,"showInHours":false,"format":null,"daysEvaluatedColumns":null},{"table":"transaction","column":"invoice","type":"STRING","showAt":null,"showInHours":false,"format":null,"daysEvaluatedColumns":null},{"table":"transaction","column":"observation","type":"TEXT","showAt":null,"showInHours":false,"format":null,"daysEvaluatedColumns":null}],"filters":[{"field":"transaction.supplier_id","operator":"equal","condition":"AND","value":[2423],"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}],"aggregates":[{"table":"transaction","column":"vehicle_id","group":true,"sum":false,"avg":false,"max":false,"min":false,"stddev":false,"translated":"Veículo","id":"transaction.vehicle_id"},{"table":"transaction","column":"final_value","group":false,"sum":true,"avg":false,"max":false,"min":false,"stddev":false}],"preview":false,"orderBy":[],"groupBy":[]} 2022-09-28 17:49:47.672+00 2022-09-28 17:49:47.831+00 514 514 REL-002053 table Despesas - Despesas com a fatura (Sascar) transaction