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
{"type":"donut","categories":"vehicle.motorized","values":[{"column":"_formula.Quantidade","rawColumn":"_formula.Quantidade","summarizer":"formula","axis":0,"isMainValue":true}],"legend":{"enabled":false}} 1 1334 {"table":"vehicle","relationships":["employee","subsidiary","group","model"],"type":"table","fields":[{"table":"vehicle","column":"motorized","type":"BOOLEAN","showAt":null,"showInHours":false,"format":null,"daysEvaluatedColumns":null},{"table":"vehicle","column":"disponibility","type":"STRING","showAt":null,"showInHours":false,"format":"list:vehicleDisponibility","daysEvaluatedColumns":null},{"table":"vehicle","column":"name","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":"subsidiary_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","column":"chassis_number","type":"STRING","showAt":null,"showInHours":false,"format":null,"daysEvaluatedColumns":null},{"table":"vehicle","column":"renavam","type":"STRING","showAt":null,"showInHours":false,"format":null,"daysEvaluatedColumns":null},{"table":"_formula","column":"Quantidade","type":"formula","query":"COUNT(vehicle.id)","showAt":null,"showInHours":false,"format":null,"daysEvaluatedColumns":null},{"table":"vehicle","column":"model_identification","type":"STRING","showAt":null,"showInHours":false,"format":null,"daysEvaluatedColumns":null},{"table":"vehicle","column":"version_identification","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","isDatePeriod":false,"translated":null,"lineNumber":2}],"aggregates":[{"table":"vehicle","column":"motorized","group":true,"sum":false,"avg":false,"max":false,"min":false,"translated":"Motorizado","id":"vehicle.motorized"}],"preview":false,"orderBy":[],"groupBy":[]} 2022-09-15 13:51:26.981+00 2022-09-15 13:54:30.951+00 870 870 870 REL-001334 table teste Cadastros - Frotas vehicle
1 72 {"type":"column","categories":"trip.date","values":[{"column":"trip.distance","rawColumn":"trip.distance__sum__","summarizer":"sum","axis":0,"isMainValue":true}],"legend":{"enabled":true}} 1 7 {"table":"trip","relationships":["employee"],"type":"matrix","fields":[{"table":"employee","column":"name","type":"STRING","showAt":{"inner":true,"total":false},"format":null},{"table":"trip","column":"date","type":"DATE","date_config":["month","year"],"showAt":{"inner":true,"total":false},"format":null},{"table":"trip","column":"distance","type":"DECIMAL","summarizers":{"sum":true,"avg":false,"max":false,"min":false},"showAt":{"inner":true,"total":false},"format":null},{"table":"trip","column":"fuel_quantity","type":"DECIMAL","summarizers":{"sum":true,"avg":false,"max":false,"min":false},"showAt":{"inner":true,"total":false},"format":null},{"table":"_formula","column":"Média (km/l)","type":"formula","query":"SUM(trip.distance) / SUM(trip.fuel_quantity)","showAt":{"inner":true,"total":false},"format":null},{"table":"_formula","column":"Qtd de viagens","type":"formula","query":"COUNT(trip.id)","showAt":{"inner":true,"total":false},"format":null}],"filters":[{"field":"trip.status","operator":"equal","condition":"AND","value":["Terminada"],"references":null,"format":"list:tripStatus","type":"STRING"}],"aggregates":[{"table":"employee","column":"name","group":true,"sum":null,"avg":null,"max":null,"min":null,"matrix_type":"vertical"},{"table":"trip","column":"date","group":true,"sum":null,"avg":null,"max":null,"min":null,"matrix_type":"horizontal"},{"table":"trip","column":"distance","group":false,"sum":true,"avg":false,"max":false,"min":false},{"table":"trip","column":"fuel_quantity","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:39:15.464+00 REL-000007 matrix Viagens - Consumo mensal das viagens terminadas por colaborador (média km/l) trip
1 52 {"type":"column","categories":"transaction.supplier_id","values":[{"column":"transaction.quantity","rawColumn":"transaction.quantity__sum__","summarizer":"sum","axis":0,"isMainValue":true}],"legend":{"enabled":false}} 1 24 {"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"},{"table":"_formula","column":"Valor unitário médio (R$/L)","type":"formula","query":"SUM(transaction.final_value) / 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}],"aggregates":[{"table":"transaction","column":"supplier_id","group":true,"sum":false,"avg":false,"max":false,"min":false,"translated":"Fornecedor","id":"transaction.supplier_id"},{"table":"transaction","column":"final_value","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}]} 2016-06-29 21:23:34.017+00 2018-03-23 13:50:40.656+00 REL-000024 table Abastecimentos - Abastecimentos por fornecedor (valor médio do litro) últimos 60 dias transaction
1 122 {"type":"column","categories":"transaction.date","values":[{"column":"_formula.Consumo médio (l/h)","rawColumn":"_formula.Consumo médio (l/h)","axis":0,"summarizer":"formula","isMainValue":true}],"legend":{"enabled":true}} 1 48 {"table":"transaction","relationships":["vehicle"],"type":"matrix","fields":[{"table":"transaction","column":"vehicle_id","type":"INTEGER","showAt":{"inner":true,"total":true},"format":null},{"table":"transaction","column":"date","type":"DATE","date_config":["month","year"],"showAt":{"inner":true,"total":true},"format":null,"is_full_period":false},{"table":"transaction","column":"quantity","type":"DECIMAL","summarizers":{"sum":true,"avg":false,"max":false,"min":false},"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":"_formula","column":"Consumo médio (l/h)","type":"formula","query":"SUM(transaction.quantity) / SUM(transaction.distance)","showAt":{"inner":true,"total":true},"format":null},{"table":"transaction","column":"final_value","type":"DECIMAL","summarizers":{"sum":true,"avg":false,"max":false,"min":false},"showAt":{"inner":true,"total":true},"format":"Money"}],"filters":[{"field":"transaction.date","operator":"dynamic_period","condition":"AND","value":"this_year:this_year","references":null,"format":null,"type":"DATE","isFixedPeriod":false,"isDynamicPeriod":true},{"field":"transaction.register_type","operator":"equal","condition":"AND","value":["Abastecimento"],"references":null,"format":"list:transactionRegisterTypes","type":"STRING","isFixedPeriod":false,"isDynamicPeriod":false},{"field":"transaction.item_id","operator":"not_empty","condition":"AND","value":null,"references":"item","format":null,"type":"INTEGER","isFixedPeriod":false,"isDynamicPeriod":false},{"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":"vehicle_id","group":true,"sum":null,"avg":null,"max":null,"min":null,"matrix_type":"vertical"},{"table":"transaction","column":"date","group":true,"sum":null,"avg":null,"max":null,"min":null,"matrix_type":"horizontal"},{"table":"transaction","column":"quantity","group":false,"sum":true,"avg":false,"max":false,"min":false},{"table":"transaction","column":"distance","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 12:15:48.985+00 2018-12-07 10:48:34.971+00 1 1 REL-000048 matrix Abastecimentos - Abastecimentos por veículo consumo médio (l/h) mensal ano atual transaction
1 67 1 4 {"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":"this_year:this_year","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.087+00 2020-04-15 14:11:25.255+00 REL-000004 matrix Despesas - Custos por km rodado por tipo de custo no ano atual transaction
1 1031 {"table":"tire","relationships":[],"type":"table","fields":[{"table":"tire","column":"name","type":"STRING","showAt":null,"showInHours":false,"format":null,"daysEvaluatedColumns":null},{"table":"tire","column":"status","type":"STRING","showAt":null,"showInHours":false,"format":"list:tireStatus","daysEvaluatedColumns":null},{"table":"tire","column":"subsidiary_id","type":"INTEGER","showAt":null,"showInHours":false,"format":null,"daysEvaluatedColumns":null},{"table":"tire","column":"tire_brand_id","type":"INTEGER","showAt":null,"showInHours":false,"format":null,"daysEvaluatedColumns":null},{"table":"tire","column":"tire_dimension_id","type":"INTEGER","showAt":null,"showInHours":false,"format":null,"daysEvaluatedColumns":null},{"table":"tire","column":"tire_drawing_id","type":"INTEGER","showAt":null,"showInHours":false,"format":null,"daysEvaluatedColumns":null},{"table":"tire","column":"start_control_date","type":"DATE","showAt":null,"showInHours":false,"format":null,"daysEvaluatedColumns":null},{"table":"_formula","column":"Qtde.","type":"formula","query":"COUNT(DISTINCT tire.id)","showAt":null,"showInHours":false,"format":null,"daysEvaluatedColumns":null,"relatedTables":[{"table":"tire"}]}],"filters":[],"aggregates":[],"preview":false,"orderBy":[{"table":"tire","column":"status","isHeaderColumn":true,"desc":true}],"groupBy":[]} 2022-09-01 20:45:07.707+00 2022-09-02 14:17:44.048+00 77 514 77 REL-001031 table Lista de pneus - Cadastros tire
1 121 {"type":"column","categories":"transaction.date","values":[{"column":"transaction.quantity","rawColumn":"transaction.quantity__sum__","summarizer":"sum","axis":0,"isMainValue":true}],"legend":{"enabled":true}} 1 46 {"table":"transaction","relationships":["vehicle"],"type":"matrix","fields":[{"table":"transaction","column":"employee_id","type":"INTEGER","showAt":{"inner":true,"total":true},"format":null},{"table":"transaction","column":"date","type":"DATE","date_config":["month","year"],"showAt":{"inner":true,"total":true},"format":null,"is_full_period":false},{"table":"transaction","column":"quantity","type":"DECIMAL","summarizers":{"sum":true,"avg":false,"max":false,"min":false},"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":"_formula","column":"Consumo médio (l/h)","type":"formula","query":"SUM(transaction.quantity) / SUM(transaction.distance)","showAt":{"inner":true,"total":true},"format":null}],"filters":[{"field":"transaction.date","operator":"dynamic_period","condition":"AND","value":"this_year:this_year","references":null,"format":null,"type":"DATE","isFixedPeriod":false,"isDynamicPeriod":true},{"field":"transaction.register_type","operator":"equal","condition":"AND","value":["Abastecimento"],"references":null,"format":"list:transactionRegisterTypes","type":"STRING","isFixedPeriod":false,"isDynamicPeriod":false},{"field":"transaction.item_id","operator":"not_empty","condition":"AND","value":null,"references":"item","format":null,"type":"INTEGER","isFixedPeriod":false,"isDynamicPeriod":false},{"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":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":"quantity","group":false,"sum":true,"avg":false,"max":false,"min":false},{"table":"transaction","column":"distance","group":false,"sum":true,"avg":false,"max":false,"min":false}],"preview":false,"orderBy":[{"table":"transaction","column":"date","isHeaderColumn":true,"desc":false}]} 2017-10-26 12:10:33.396+00 2017-10-26 12:25:26.465+00 1 1 REL-000046 matrix Abastecimentos - Abastecimentos por colaborador consumo médio (l/h) mensal ano atual transaction
1 55 1 5 {"table":"employee","relationships":["role"],"type":"table","fields":[{"table":"employee","column":"name","type":"STRING","showAt":null,"format":null},{"table":"employee","column":"subsidiary_id","type":"INTEGER","showAt":null,"format":null},{"table":"employee","column":"cost_center_id","type":"INTEGER","showAt":null,"format":null},{"table":"employee","column":"employee_role_id","type":"INTEGER","showAt":null,"format":null},{"table":"employee","column":"registration_num","type":"STRING","showAt":null,"format":null},{"table":"employee","column":"habilitation_num","type":"STRING","showAt":null,"format":null},{"table":"employee","column":"habilitation_category","type":"STRING","showAt":null,"format":"list:habilitationCategories"},{"table":"employee","column":"habilitation_due_date","type":"DATE","showAt":null,"format":null}],"filters":[{"field":"employee.active","operator":"equal","condition":"AND","value":true,"references":null,"format":null,"type":"BOOLEAN"}],"aggregates":[],"preview":false,"orderBy":[{"table":"employee","column":"name","isHeaderColumn":true,"desc":true}]} 2016-06-29 21:23:34.03+00 2017-10-13 12:44:24.553+00 REL-000005 table Cadastros - Listagem dos colaboradores ativos employee
{"type":"column","categories":"item.type","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 4679 {"table":"transaction","relationships":["item","vehicle"],"type":"matrix","fields":[{"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":"vehicle","column":"cf_611","type":"STRING","showAt":{"inner":true,"total":true},"showInHours":false,"format":null,"daysEvaluatedColumns":null},{"table":"item","column":"type","type":"STRING","showAt":{"inner":true,"total":true},"showInHours":false,"format":"list:itemTypes","daysEvaluatedColumns":null},{"table":"transaction","column":"item_description","type":"TEXT","showAt":{"inner":true,"total":true},"showInHours":false,"format":null,"daysEvaluatedColumns":null},{"table":"transaction","column":"type","type":"STRING","showAt":{"inner":true,"total":true},"showInHours":false,"format":"list:transactionTypes","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":5},{"field":"transaction.date","operator":"$gte","condition":"AND","value":"2023-01-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":6},{"field":"transaction.date","operator":"$lte","condition":"AND","value":"2023-02-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":6},{"field":"vehicle.cf_379","operator":"$ne","condition":"AND","value":["SEMIRREBOQUE"],"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":7},{"field":"item.type","operator":"equal","condition":"AND","value":["Imposto e Taxa","Pedagio"],"variableValue":null,"variableValueType":null,"variableValueTranslated":null,"conditionType":"fixed","references":null,"format":"list:itemTypes","type":"STRING","isFixedPeriod":false,"isDatePeriod":false,"isDynamicPeriod":false,"isNotInTable":false,"translated":null,"lineNumber":8}],"aggregates":[{"table":"transaction","column":"final_value","group":false,"sum":true,"avg":false,"max":false,"min":false},{"table":"vehicle","column":"cf_611","group":true,"sum":null,"avg":null,"max":null,"min":null,"matrix_type":"vertical"},{"table":"item","column":"type","group":true,"sum":null,"avg":null,"max":null,"min":null,"matrix_type":"horizontal"},{"table":"transaction","column":"item_description","group":true,"sum":null,"avg":null,"max":null,"min":null,"matrix_type":"vertical"},{"table":"transaction","column":"type","group":true,"sum":null,"avg":null,"max":null,"min":null,"matrix_type":"vertical"}],"preview":false,"orderBy":[{"table":"item","column":"type","isHeaderColumn":true,"desc":false}],"groupBy":[]} 2023-03-01 14:00:21.645+00 2023-03-01 14:02:44.177+00 870 870 870 REL-004679 matrix Despesas com mensalidade e taxa de substituição entrar na conta de pedágio não em Impostos e Taxas Despesas com mensalidade Move Mais transaction
1 113 1 39 {"table":"stock_entry_item","relationships":["stock_entry"],"type":"table","fields":[{"table":"stock_entry_item","column":"item_id","type":"INTEGER","showAt":null,"format":null},{"table":"stock_entry_item","column":"stock_entry_id","type":"INTEGER","showAt":null,"format":null},{"table":"stock_entry_item","column":"date","type":"DATE","showAt":null,"format":null},{"table":"stock_entry_item","column":"warehouse_id","type":"INTEGER","showAt":null,"format":null},{"table":"stock_entry_item","column":"quantity","type":"DECIMAL","showAt":null,"format":null},{"table":"stock_entry_item","column":"stock_balance","type":"DECIMAL","showAt":null,"format":null},{"table":"stock_entry_item","column":"unit_value","type":"DECIMAL","showAt":null,"format":"Money"},{"table":"stock_entry_item","column":"final_value","type":"DECIMAL","showAt":null,"format":"Money"}],"filters":[{"field":"stock_entry_item.date","operator":"dynamic_period","condition":"AND","value":"sub_60_days:this_day","references":null,"format":null,"type":"DATE","isFixedPeriod":false,"isDynamicPeriod":true}],"aggregates":[{"table":"stock_entry_item","column":"item_id","group":true,"sum":false,"avg":false,"max":false,"min":false}],"preview":false,"orderBy":[{"table":"stock_entry_item","column":"item_id","isHeaderColumn":true,"desc":true}]} 2017-10-13 12:11:42.426+00 2018-11-20 12:59:29.703+00 1 1 REL-000039 table Auditoria das entradas de estoque por itens nos últimos 60 dias Estoque - Auditoria das entradas de estoque por itens - U60d stock_entry_item