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 56 {"type":"donut","categories":"vehicle.motorized","values":[{"column":"_formula.Quantidade","rawColumn":"_formula.Quantidade","summarizer":"formula","axis":0,"isMainValue":true}],"legend":{"enabled":false}} 1 31 {"table":"vehicle","relationships":["employee","subsidiary","group","model"],"type":"table","fields":[{"table":"vehicle","column":"motorized","type":"BOOLEAN","showAt":null,"format":null},{"table":"vehicle","column":"disponibility","type":"STRING","showAt":null,"format":"list:vehicleDisponibility"},{"table":"vehicle","column":"name","type":"STRING","showAt":null,"format":null},{"table":"vehicle","column":"license_plate","type":"STRING","showAt":null,"format":null},{"table":"vehicle","column":"subsidiary_id","type":"INTEGER","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":"chassis_number","type":"STRING","showAt":null,"format":null},{"table":"vehicle","column":"renavam","type":"STRING","showAt":null,"format":null},{"table":"_formula","column":"Quantidade","type":"formula","query":"COUNT(vehicle.id)","showAt":null,"format":null}],"filters":[{"field":"vehicle.status","operator":"equal","condition":"AND","value":["active"],"references":null,"format":"list:vehicleStatus","type":"STRING"}],"aggregates":[{"table":"vehicle","column":"motorized","group":true,"sum":false,"avg":false,"max":false,"min":false,"translated":"Motorizado","id":"vehicle.motorized"}],"preview":false,"orderBy":[]} 2016-06-29 21:23:34.039+00 2017-10-13 12:33:05.608+00 REL-000031 table Cadastros - Inventário da frota - Veículos ativos vehicle
1 127 {"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 47 {"table":"transaction","relationships":["item"],"type":"matrix","fields":[{"table":"transaction","column":"date","type":"DATE","date_config":["month","year"],"showAt":{"inner":true,"total":true},"format":null,"is_full_period":false,"translated":"Data"},{"table":"transaction","column":"vehicle_id","type":"INTEGER","showAt":{"inner":true,"total":true},"format":null,"translated":"Veículo"},{"table":"transaction","column":"final_value","type":"DECIMAL","summarizers":{"sum":true,"avg":false,"max":false,"min":false},"showAt":{"inner":true,"total":true},"format":"Money","translated":"Valor total"}],"filters":[{"field":"transaction.date","operator":"dynamic_period","condition":"AND","value":"last_month:last_month","references":null,"format":null,"type":"DATE","isFixedPeriod":false,"isDynamicPeriod":true},{"field":"transaction.vehicle_id","operator":"not_empty","condition":"AND","value":null,"references":"vehicle","format":null,"type":"INTEGER","isFixedPeriod":false,"isDynamicPeriod":false},{"field":"transaction.item_id","operator":"not_empty","condition":"AND","value":null,"references":"item","format":null,"type":"INTEGER","isFixedPeriod":false,"isDynamicPeriod":false},{"field":"item.cost_type","operator":"equal","condition":"AND","value":["pneu"],"references":null,"format":"list:transactionCostTypes","type":"STRING","isFixedPeriod":false,"isDynamicPeriod":false}],"aggregates":[{"table":"transaction","column":"date","group":true,"sum":null,"avg":null,"max":null,"min":null,"matrix_type":"horizontal","translated":"Data","id":"transaction.date"},{"table":"transaction","column":"vehicle_id","group":true,"sum":null,"avg":null,"max":null,"min":null,"matrix_type":"vertical","translated":"Veículo","id":"transaction.vehicle_id"},{"table":"transaction","column":"final_value","group":false,"sum":true,"avg":false,"max":false,"min":false}],"preview":false,"orderBy":[{"table":"transaction","column":"date","isHeaderColumn":true,"desc":false}]} 2017-11-07 17:11:50.505+00 2018-06-29 13:04:49.895+00 1 1 REL-000047 matrix Infográfico - Pneus por veículo mês anterior transaction
{"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 4778 {"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}],"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":8},{"field":"vehicle.cf_379","operator":"equal","condition":"AND","value":["LEVE"],"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":9}],"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"}],"preview":false,"orderBy":[{"table":"vehicle","column":"cf_36","isHeaderColumn":true,"desc":false}],"groupBy":[]} 2023-03-06 12:14:44.103+00 2023-03-06 12:14:44.128+00 870 870 REL-004778 matrix Quantidade de veículos por tipo LEVE QDE POR TIPOS LEVES vehicle
1 116 {"type":"column","categories":"tire.current_vehicle_id","values":[{"column":"_formula.Quantidade","rawColumn":"_formula.Quantidade","summarizer":"formula","axis":0,"isMainValue":true}],"legend":{"enabled":true}} 1 35 {"table":"tire","relationships":[],"type":"table","fields":[{"table":"tire","column":"current_vehicle_id","type":"INTEGER","showAt":null,"format":null},{"table":"tire","column":"name","type":"STRING","showAt":null,"format":null},{"table":"tire","column":"current_tire_position","type":"STRING","showAt":null,"format":null},{"table":"_formula","column":"Quantidade","type":"formula","query":"COUNT(tire.id)","showAt":null,"format":null}],"filters":[{"field":"tire.status","operator":"equal","condition":"AND","value":["in_activity"],"references":null,"format":"list:tireStatus","type":"STRING","isFixedPeriod":false,"isDynamicPeriod":false}],"aggregates":[{"table":"tire","column":"current_vehicle_id","group":true,"sum":false,"avg":false,"max":false,"min":false}],"preview":false,"orderBy":[{"table":"tire","column":"current_tire_position","isHeaderColumn":true,"desc":false}]} 2017-10-17 11:01:55.931+00 2017-10-17 11:01:55.931+00 1 1 REL-000035 table Pneus - Veículos e seus pneus tire
1 124 1 42 {"table":"pendency","relationships":[],"type":"table","fields":[{"table":"pendency","column":"vehicle_id","type":"INTEGER","showAt":null,"format":null},{"table":"pendency","column":"name","type":"STRING","showAt":null,"format":null},{"table":"pendency","column":"type","type":"STRING","showAt":null,"format":"list:pendencyTypes"},{"table":"pendency","column":"item_id","type":"INTEGER","showAt":null,"format":null},{"table":"pendency","column":"due_date","type":"DATE","showAt":null,"format":null},{"table":"pendency","column":"due_km","type":"DECIMAL","showAt":null,"format":null}],"filters":[{"field":"pendency.closed_date","operator":"empty","condition":"AND","value":null,"references":null,"format":null,"type":"DATE","isFixedPeriod":false,"isDynamicPeriod":false}],"aggregates":[{"table":"pendency","column":"vehicle_id","group":true,"sum":false,"avg":false,"max":false,"min":false}],"preview":false,"orderBy":[{"table":"pendency","column":"due_date","isHeaderColumn":true,"desc":false}]} 2017-10-31 19:35:27.102+00 2017-10-31 19:35:27.102+00 1 1 REL-000042 table Pendências - Pendências ativas por veículo pendency
1 118 1 38 {"table":"transaction","relationships":[],"type":"table","fields":[{"table":"transaction","column":"vehicle_id","type":"INTEGER","showAt":null,"format":null,"translated":"Veículo"},{"table":"transaction","column":"date","type":"DATE","showAt":null,"format":null,"translated":"Data"},{"table":"transaction","column":"odometer","type":"DECIMAL","showAt":null,"format":null,"translated":"Hodômetro"},{"table":"transaction","column":"movement_type","type":"STRING","showAt":null,"format":"list:tireMovementType","translated":"Tipo de movimentação de pneu"},{"table":"transaction","column":"tire_id","type":"INTEGER","showAt":null,"format":null,"translated":"Pneu"},{"table":"transaction","column":"destination_position","type":"STRING","showAt":null,"format":null,"translated":"Posição de destino"},{"table":"transaction","column":"destination_status","type":"STRING","showAt":null,"format":"list:tireStatus","translated":"Situação de destino"}],"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.vehicle_id","operator":"not_empty","condition":"AND","value":null,"references":"vehicle","format":null,"type":"INTEGER","isFixedPeriod":false,"isDynamicPeriod":false},{"field":"transaction.movement_type","operator":"not_empty","condition":"AND","value":null,"references":null,"format":"list:tireMovementType","type":"STRING","isFixedPeriod":false,"isDynamicPeriod":false}],"aggregates":[{"table":"transaction","column":"vehicle_id","group":true,"sum":false,"avg":false,"max":false,"min":false}],"preview":false,"orderBy":[{"table":"transaction","column":"date","isHeaderColumn":true,"desc":false}]} 2017-10-17 11:09:53.422+00 2018-01-30 19:05:14.701+00 1 1 REL-000038 table Histórico das movimentações de pneus por veículo, nos últimos 60 dias. Pneus - Histórico das movimentações de pneus por veículo U60d transaction
1 138 1 60 {"table":"fine","relationships":[],"type":"table","fields":[{"table":"fine","column":"name","type":"STRING","showAt":null,"format":null},{"table":"fine","column":"ait","type":"STRING","showAt":null,"format":null},{"table":"fine","column":"vehicle_id","type":"INTEGER","showAt":null,"format":null},{"table":"fine","column":"status","type":"STRING","showAt":null,"format":"list:fineStatus"},{"table":"fine","column":"infringement_date","type":"DATE","showAt":null,"format":null},{"table":"fine","column":"fine_qualification_id","type":"INTEGER","showAt":null,"format":null},{"table":"fine","column":"nic_ait","type":"STRING","showAt":null,"format":null},{"table":"fine","column":"has_nic","type":"BOOLEAN","showAt":null,"format":null},{"table":"fine","column":"created_at","type":"DATE","showAt":null,"format":null},{"table":"fine","column":"created_by_id","type":"INTEGER","showAt":null,"format":null},{"table":"fine","column":"updated_at","type":"DATE","showAt":null,"format":null},{"table":"fine","column":"updated_by_id","type":"INTEGER","showAt":null,"format":null}],"filters":[],"aggregates":[],"preview":false,"orderBy":[{"table":"fine","column":"created_at","isHeaderColumn":true,"desc":false}]} 2018-02-14 11:41:13.501+00 2019-03-07 12:59:40.208+00 1 1 REL-000060 table Pela criação e atualização Infrações - Listagem das infrações fine
1 159 {"type":"column","categories":"tire_life.tire_id","values":[{"column":"tire_life.durability_cost","rawColumn":"tire_life.durability_cost__sum__","summarizer":"sum","axis":0,"isMainValue":true}],"legend":{"enabled":true}} 1 80 {"table":"tire_life","relationships":[],"type":"table","fields":[{"table":"tire_life","column":"tire_id","type":"INTEGER","showAt":null,"showInHours":false,"format":null,"daysEvaluatedColumns":null},{"table":"tire_life","column":"life","type":"INTEGER","showAt":null,"showInHours":false,"format":null,"daysEvaluatedColumns":null},{"table":"tire_life","column":"initial_cost","type":"DECIMAL","showAt":null,"showInHours":false,"format":null,"daysEvaluatedColumns":null},{"table":"tire_life","column":"repair_cost","type":"DECIMAL","showAt":null,"showInHours":false,"format":null,"daysEvaluatedColumns":null},{"table":"tire_life","column":"life_total_cost","type":"DECIMAL","showAt":null,"showInHours":false,"format":null,"daysEvaluatedColumns":null},{"table":"tire_life","column":"covered_distance","type":"DECIMAL","showAt":null,"showInHours":false,"format":null,"daysEvaluatedColumns":null},{"table":"tire_life","column":"durability_cost","type":"DECIMAL","showAt":null,"showInHours":false,"format":null,"daysEvaluatedColumns":null},{"table":"_formula","column":"Custo do Km Rodado x 1000 (Total do Pneu)","type":"formula","query":"SUM(tire_life.life_total_cost) / SUM(tire_life.covered_distance)","showAt":null,"showInHours":false,"format":null,"daysEvaluatedColumns":null}],"filters":[],"aggregates":[{"table":"tire_life","column":"durability_cost","group":false,"sum":true,"avg":false,"max":false,"min":false},{"table":"tire_life","column":"tire_id","group":true,"sum":false,"avg":false,"max":false,"min":false}],"preview":false,"orderBy":[]} 2019-07-02 19:09:52.809+00 2019-07-02 19:09:52.862+00 1 1 REL-000080 table Pneus - Custo do Km Rodado por Vida tire_life
1 119 {"type":"bar","categories":"transaction.employee_id","values":[{"column":"transaction.distance","rawColumn":"transaction.distance__sum__","summarizer":"sum","axis":0,"isMainValue":true}],"legend":{"enabled":false}} 1 41 {"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 (l/h)","type":"formula","query":"SUM(transaction.quantity) / SUM(transaction.distance)","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":["l/h"],"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}]} 2017-10-26 11:52:47.203+00 2017-10-26 12:25:44.693+00 1 1 REL-000041 table Abastecimentos - Abastecimentos por colaborador consumo médio (l/h) últimos 60 dias transaction
1 144 1 65 {"table":"transaction","relationships":[],"type":"table","fields":[{"table":"transaction","column":"supplier_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":"vehicle_id","type":"INTEGER","showAt":null,"format":null},{"table":"transaction","column":"item_id","type":"INTEGER","showAt":null,"format":null},{"table":"transaction","column":"quantity","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":"last_month:last_month","references":null,"format":null,"type":"DATE","isFixedPeriod":false,"isDynamicPeriod":true},{"field":"transaction.type","operator":"equal","condition":"AND","value":["expense"],"references":null,"format":"list:transactionTypes","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":"transaction.vehicle_id","operator":"not_empty","condition":"AND","value":null,"references":"vehicle","format":null,"type":"INTEGER","isFixedPeriod":false,"isDynamicPeriod":false},{"field":"transaction.register_type","operator":"$ne","condition":"AND","value":["Abastecimento"],"references":null,"format":"list:transactionRegisterTypes","type":"STRING","isFixedPeriod":false,"isDynamicPeriod":false}],"aggregates":[{"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}]} 2018-04-03 13:34:59.733+00 2018-04-03 13:34:59.734+00 1 1 REL-000065 table Custos total detalhado de todas as despesas, exceto abastecimentos. Despesas - custo por fornecedor mês anterior exceto abastecimentos - detalhado transaction