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 60 {"type":"column","categories":"route.name","values":[{"column":"trip.total_income","rawColumn":"trip.total_income__sum__","summarizer":"sum","axis":0,"isMainValue":true}],"legend":{"enabled":true}} 1 2 {"table":"trip","relationships":["route","employee","vehicle"],"type":"table","fields":[{"table":"route","column":"name","type":"STRING","showAt":null,"format":null},{"table":"trip","column":"id","type":"INTEGER","showAt":null,"format":null},{"table":"trip","column":"date","type":"DATE","showAt":null,"format":null},{"table":"vehicle","column":"name","type":"STRING","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.margin) / SUM(trip.distance)","showAt":null,"format":null}],"filters":[{"field":"trip.status","operator":"equal","condition":"AND","value":["Terminada"],"references":null,"format":"list:tripStatus","type":"STRING"}],"aggregates":[{"table":"route","column":"name","group":true,"sum":false,"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":"total_cost","group":false,"sum":true,"avg":false,"max":false,"min":false},{"table":"trip","column":"total_income","group":false,"sum":true,"avg":false,"max":false,"min":false}],"preview":false,"orderBy":[]} 2016-06-29 21:23:34.066+00 2017-10-13 12:39:32.62+00 REL-000002 table Viagens - DRE das viagens terminadas por rota trip
1 62 1 11 {"table":"trip","relationships":["employee","route","vehicle"],"type":"table","fields":[{"table":"trip","column":"status","type":"STRING","showAt":null,"format":"list:tripStatus"},{"table":"trip","column":"id","type":"INTEGER","showAt":null,"format":null},{"table":"trip","column":"date","type":"DATE","showAt":null,"format":null},{"table":"vehicle","column":"name","type":"STRING","showAt":null,"format":null},{"table":"employee","column":"name","type":"STRING","showAt":null,"format":null},{"table":"route","column":"name","type":"STRING","showAt":null,"format":null}],"filters":[{"field":"trip.status","operator":"$ne","condition":"AND","value":["Terminada"],"references":null,"format":"list:tripStatus","type":"STRING"}],"aggregates":[{"table":"trip","column":"status","group":true,"sum":false,"avg":false,"max":false,"min":false}],"preview":false,"orderBy":[]} 2016-06-29 21:23:34.077+00 2017-10-13 12:39:45.814+00 REL-000011 table Viagens - Viagens abertas por situação trip
1 73 {"type":"column","categories":"trip.date","values":[{"column":"trip.total_income","rawColumn":"trip.total_income__sum__","summarizer":"sum","axis":0,"isMainValue":true}],"legend":{"enabled":true}} 1 28 {"table":"trip","relationships":["route"],"type":"matrix","fields":[{"table":"trip","column":"date","type":"DATE","date_config":["month","year"],"showAt":{"inner":true,"total":true},"format":null},{"table":"route","column":"name","type":"STRING","showAt":{"inner":true,"total":true},"format":null},{"table":"trip","column":"total_income","type":"DECIMAL","summarizers":{"sum":true,"avg":false,"max":false,"min":false},"showAt":{"inner":true,"total":true},"format":"Money"},{"table":"trip","column":"total_cost","type":"DECIMAL","summarizers":{"sum":true,"avg":false,"max":false,"min":false},"showAt":{"inner":true,"total":true},"format":"Money"},{"table":"trip","column":"margin","type":"DECIMAL","summarizers":{"sum":true,"avg":false,"max":false,"min":false},"showAt":{"inner":true,"total":true},"format":"Money"},{"table":"_formula","column":"Qtd de viagens","type":"formula","query":"COUNT(trip.id)","showAt":{"inner":true,"total":true},"format":null}],"filters":[{"field":"trip.status","operator":"equal","condition":"AND","value":["Terminada"],"references":null,"format":"list:tripStatus","type":"STRING"}],"aggregates":[{"table":"trip","column":"date","group":true,"sum":null,"avg":null,"max":null,"min":null,"matrix_type":"horizontal"},{"table":"route","column":"name","group":true,"sum":null,"avg":null,"max":null,"min":null,"matrix_type":"vertical"},{"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}],"preview":false,"orderBy":[{"table":"trip","column":"date","isHeaderColumn":true,"desc":false}]} 2016-06-29 21:23:34.11+00 2017-10-13 12:51:07.209+00 REL-000028 matrix Viagens - DRE mensal das viagens terminadas por rota trip
1 66 1 17 {"table":"transaction","relationships":["item"],"type":"matrix","fields":[{"table":"item","column":"cost_type","type":"STRING","format":"list:transactionCostTypes","showAt":{"inner":true,"total":true},"translated":"Tipo de custo"},{"table":"transaction","column":"date","type":"DATE","date_config":["month","year"],"format":null,"showAt":{"inner":true,"total":true},"translated":"Data"},{"table":"_formula","column":"Custo por Km Rodado","type":"formula","query":"SUM(transaction.final_value)","format":null,"customReportAgg":"sum","showAt":{"inner":true,"total":true}},{"table":"transaction","column":"final_value","type":"DECIMAL","summarizers":{"sum":true,"avg":false,"max":false,"min":false},"format":"Money","showAt":{"inner":true,"total":true},"translated":"Valor total"},{"table":"transaction","column":"traveled_distance","type":"DECIMAL","summarizers":{"sum":true,"avg":false,"max":false,"min":false},"format":null,"showAt":{"inner":false,"total":true},"translated":"Distância percorrida"}],"filters":[{"field":"transaction.date","operator":"dynamic_period","condition":"AND","value":"last_month:last_month","references":null,"format":null,"type":"DATE","isFixedPeriod":false,"isDynamicPeriod":true,"isNotInTable":false},{"field":"transaction.type","operator":"$ne","condition":"AND","value":["revenue"],"references":null,"format":"list:transactionTypes","type":"STRING","isNotInTable":false},{"field":"transaction.item_id","operator":"not_empty","condition":"AND","value":null,"references":"item","format":null,"type":"INTEGER","isFixedPeriod":false,"isDynamicPeriod":false,"isNotInTable":false}],"aggregates":[{"table":"item","column":"cost_type","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":"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}],"preview":false,"orderBy":[{"table":"transaction","column":"date","isHeaderColumn":true,"desc":false}],"isCustomReport":true,"customReportQueries":["kmCost"]} 2016-06-29 21:23:34.086+00 2020-04-15 14:13:05.837+00 REL-000017 matrix Despesas - Custos por km rodado por tipo de custo no mês anterior transaction
{"type":"bar","categories":"transaction.vehicle_id","values":[{"column":"transaction.final_value","rawColumn":"transaction.final_value__sum__","axis":0,"summarizer":"sum","isMainValue":true}],"legend":{"enabled":true},"show_values":{"enabled":true},"use_diferent_color":{"enabled":false},"stacked_column":{"enabled":false},"filters":{"showOnlyFirstRecords":false,"showAllRecords":true,"recordsToShow":null}} 103 393 {"table":"transaction","relationships":["item","vehicle"],"type":"table","fields":[{"table":"transaction","column":"vehicle_id","type":"INTEGER","showAt":null,"showInHours":false,"format":null,"daysEvaluatedColumns":null},{"table":"transaction","column":"expense_id","type":"INTEGER","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":"transaction","column":"date","type":"DATE","showAt":null,"showInHours":false,"format":null,"daysEvaluatedColumns":null},{"table":"transaction","column":"unit_value","type":"DECIMAL","showAt":null,"showInHours":false,"format":"Money","daysEvaluatedColumns":null},{"table":"item","column":"name","type":"STRING","showAt":null,"showInHours":false,"format":null,"daysEvaluatedColumns":null},{"table":"transaction","column":"final_value","type":"DECIMAL","showAt":null,"showInHours":false,"format":"Money","daysEvaluatedColumns":null},{"table":"item","column":"sub_system_id","type":"INTEGER","showAt":null,"showInHours":false,"format":null,"daysEvaluatedColumns":null},{"table":"transaction","column":"supplier_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":"transaction","column":"employee_id","type":"INTEGER","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.type","operator":"equal","condition":"AND","value":["expense"],"variableValue":null,"variableValueType":null,"variableValueTranslated":null,"conditionType":"fixed","references":null,"format":"list:transactionTypes","type":"STRING","isDatePeriod":false,"translated":null,"lineNumber":3},{"field":"item.sub_system_id","operator":"$ne","condition":"AND","value":[43,35,34,47,39],"variableValue":null,"variableValueType":null,"variableValueTranslated":null,"conditionType":"fixed","references":"sub_system","format":null,"type":"INTEGER","isFixedPeriod":false,"isDatePeriod":false,"isDynamicPeriod":false,"isNotInTable":false,"translated":null,"lineNumber":4},{"field":"transaction.item_id","operator":"$ne","condition":"AND","value":[2021],"variableValue":null,"variableValueType":null,"variableValueTranslated":null,"conditionType":"fixed","references":"item","format":null,"type":"INTEGER","isFixedPeriod":false,"isDatePeriod":false,"isDynamicPeriod":false,"isNotInTable":false,"translated":null,"lineNumber":5}],"aggregates":[{"table":"transaction","column":"final_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,"stddev":false,"translated":"Veículo","id":"transaction.vehicle_id"}],"preview":false,"orderBy":[{"table":"transaction","column":"date","isHeaderColumn":true,"desc":true}],"groupBy":[],"hideDetails":true} 2022-08-05 19:48:23.138+00 2024-02-01 20:40:04.831+00 77 1568 77 REL-000393 table Mostra os custos que temos com mão de obra e peças Custo por peça transaction
1 61 {"type":"column","categories":"fine.driver_id","values":[{"column":"fine.penalty_total_amount","rawColumn":"fine.penalty_total_amount__sum__","summarizer":"sum","axis":0,"isMainValue":true}],"legend":{"enabled":true}} 1 13 {"table":"fine","relationships":["driver","vehicle","fine_qualification"],"type":"table","fields":[{"table":"fine","column":"driver_id","type":"INTEGER","showAt":null,"format":null},{"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":"infringement_date","type":"DATE","showAt":null,"format":null},{"table":"fine","column":"fine_qualification_id","type":"INTEGER","showAt":null,"format":null},{"table":"fine","column":"penalty_total_amount","type":"DECIMAL","showAt":null,"format":"Money"},{"table":"fine_qualification","column":"description","type":"STRING","showAt":null,"format":null}],"filters":[],"aggregates":[{"table":"fine","column":"driver_id","group":true,"sum":false,"avg":false,"max":false,"min":false},{"table":"fine","column":"penalty_total_amount","group":false,"sum":true,"avg":false,"max":false,"min":false}],"preview":false,"orderBy":[{"table":"fine","column":"infringement_date","isHeaderColumn":true,"desc":true}]} 2016-06-29 21:23:34.066+00 2018-03-06 13:05:28.533+00 REL-000013 table Infrações - Infrações por colaborador fine
1 129 {"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 51 {"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},{"table":"transaction","column":"vehicle_id","type":"INTEGER","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":"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.movement_type","operator":"empty","condition":"AND","value":null,"references":null,"format":"list:tireMovementType","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":"item.type","operator":"$ne","condition":"AND","value":["Combustivel","Lubrificante","Mao de Obra/Servico","Pneu","Manutencao"],"references":null,"format":"list:itemTypes","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:20:39.916+00 2018-11-07 09:52:55.623+00 1 1 REL-000051 matrix Infográfico - Outros por veículo mês anterior transaction
1 103 {"type":"column","categories":"transaction.date","values":[{"column":"transaction.final_value","rawColumn":"transaction.final_value__sum__","summarizer":"sum","axis":0,"isMainValue":true}],"legend":{"enabled":true}} 1 14 {"table":"transaction","relationships":["service_order"],"type":"matrix","fields":[{"table":"service_order","column":"type","type":"STRING","showAt":{"inner":true,"total":true},"format":"list:serviceOrderTypes"},{"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":"date","type":"DATE","date_config":["month","year"],"showAt":{"inner":true,"total":true},"format":null}],"filters":[{"field":"transaction.service_order_id","operator":"$ne","condition":"AND","value":null,"references":"service_order","format":null,"type":"INTEGER"},{"field":"transaction.final_value","operator":"$gte","condition":"AND","value":0.01,"references":null,"format":null,"type":"DECIMAL"}],"aggregates":[{"table":"service_order","column":"type","group":true,"sum":null,"avg":null,"max":null,"min":null,"matrix_type":"vertical"},{"table":"transaction","column":"final_value","group":false,"sum":true,"avg":false,"max":false,"min":false},{"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}]} 2016-07-04 18:04:47.052+00 2017-10-13 12:37:52.487+00 REL-000014 matrix Ordens de serviço - Custos mensal preventivos x corretivos transaction
1 115 1 33 {"table":"transaction","relationships":[],"type":"table","fields":[{"table":"transaction","column":"item_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":"service_order_id","type":"INTEGER","showAt":null,"format":null},{"table":"transaction","column":"date","type":"DATE","showAt":null,"format":null},{"table":"transaction","column":"warehouse_id","type":"INTEGER","showAt":null,"format":null},{"table":"transaction","column":"quantity","type":"DECIMAL","showAt":null,"format":null},{"table":"transaction","column":"stock_balance","type":"DECIMAL","showAt":null,"format":null},{"table":"transaction","column":"unit_value","type":"DECIMAL","showAt":null,"format":"Money"},{"table":"transaction","column":"final_value","type":"DECIMAL","showAt":null,"format":"Money"}],"filters":[{"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.stock_movement_type","operator":"equal","condition":"AND","value":["stock_exit"],"references":null,"format":"list:stockMovementTypes","type":"STRING","isFixedPeriod":false,"isDynamicPeriod":false}],"aggregates":[{"table":"transaction","column":"item_id","group":true,"sum":false,"avg":false,"max":false,"min":false}],"preview":false,"orderBy":[{"table":"transaction","column":"date","isHeaderColumn":true,"desc":true}]} 2017-10-13 12:59:14.067+00 2018-12-11 17:27:05.254+00 1 1 REL-000033 table Auditoria das saídas de estoque por itens nos últimos 60 dias Estoque - Auditoria das saídas de estoque por itens - U60d transaction
1 156 1 79 {"table":"transaction","relationships":["vehicle"],"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},{"table":"_formula","column":"Abastecimentos","type":"formula","query":"SUM(transaction.fuel_supplies)","showAt":null,"format":"money"},{"table":"_formula","column":"Manutenção","type":"formula","query":"SUM(transaction.maintenance)","showAt":null,"format":"money"},{"table":"_formula","column":"Pneus","type":"formula","query":"SUM(transaction.tires)","showAt":null,"format":"money"},{"table":"_formula","column":"Outros","type":"formula","query":"SUM(transaction.others)","showAt":null,"format":"money"}],"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, 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:35.623+00 2019-01-24 19:42:23.657+00 2 2 REL-000079 table Receitas x Tipos de custo mensais transaction