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
268 1591 {"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_663","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":["CAVALO"],"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},{"field":"vehicle.cf_142","operator":"equal","condition":"AND","value":"VOLVO","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":[],"preview":false,"orderBy":[],"groupBy":[]} 2022-09-21 11:36:13.754+00 2022-09-21 11:36:13.814+00 870 870 REL-001591 table relatório para verificar veículos ativos MARCA VOLVO RELATÓRIO ANALITICO SOMENTE VOLVO vehicle
268 1547 {"table":"vehicle","relationships":["group","modelversion","cost_center","model"],"type":"table","fields":[{"table":"vehicle","column":"status","type":"STRING","showAt":null,"showInHours":false,"format":"list:vehicleStatus","daysEvaluatedColumns":null},{"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":[],"aggregates":[],"preview":false,"orderBy":[],"groupBy":[]} 2022-09-20 18:22:03.887+00 2022-09-21 12:54:08.602+00 2022-09-21 12:54:08.596+00 870 870 870 870 REL-001547 table relatório para verificar veículos geral ativos e inativos RELATÓRIO ANALITICO GERAL v1 vehicle
1 628 {"table":"employee","relationships":["role"],"type":"table","fields":[{"table":"employee","column":"name","type":"STRING","showAt":null,"showInHours":false,"format":null,"daysEvaluatedColumns":null},{"table":"employee","column":"employee_role_id","type":"INTEGER","showAt":null,"showInHours":false,"format":null,"daysEvaluatedColumns":null}],"filters":[{"field":"employee.active","operator":"equal","condition":"AND","value":true,"variableValue":null,"variableValueType":null,"variableValueTranslated":null,"conditionType":"fixed","references":null,"format":null,"type":"BOOLEAN","isDatePeriod":false,"translated":null,"lineNumber":1},{"field":"employee.active","operator":"equal","condition":"AND","value":true,"variableValue":null,"variableValueType":null,"variableValueTranslated":null,"conditionType":"fixed","references":null,"format":null,"type":"BOOLEAN","isFixedPeriod":false,"isDatePeriod":false,"isDynamicPeriod":false,"isNotInTable":false,"translated":null,"lineNumber":2}],"aggregates":[],"preview":false,"orderBy":[{"table":"employee","column":"name","isHeaderColumn":true,"desc":false}],"groupBy":[]} 2022-08-17 15:05:32.615+00 2022-08-17 19:52:02.544+00 2022-08-17 19:52:02.54+00 514 514 514 514 REL-000628 table Cadastros - Listagem dos colaboradores 123 employee
{"type":"column","categories":"deduct.employee_id","values":[{"column":"deduct_installment.value","rawColumn":"deduct_installment.value__sum__","axis":0,"summarizer":"sum","isMainValue":true}],"legend":{"enabled":true},"filters":{"showOnlyFirstRecords":false,"showAllRecords":true,"recordsToShow":null},"show_values":{"enabled":true}} 169 494 {"table":"deduct_installment","relationships":["deduct"],"type":"table","fields":[{"table":"deduct","column":"employee_id","type":"INTEGER","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":"parcels_number","type":"INTEGER","showAt":null,"showInHours":false,"format":null,"daysEvaluatedColumns":null},{"table":"deduct_installment","column":"parcel","type":"INTEGER","showAt":null,"showInHours":false,"format":null,"daysEvaluatedColumns":null},{"table":"deduct_installment","column":"has_been_discounted","type":"BOOLEAN","showAt":null,"showInHours":false,"format":null,"daysEvaluatedColumns":null},{"table":"deduct_installment","column":"name","type":"STRING","showAt":null,"showInHours":false,"format":null,"daysEvaluatedColumns":null},{"table":"deduct_installment","column":"value","type":"DECIMAL","showAt":null,"showInHours":false,"format":"Money","daysEvaluatedColumns":null},{"table":"deduct_installment","column":"date","type":"DATE","showAt":null,"showInHours":false,"format":null,"daysEvaluatedColumns":null},{"table":"deduct","column":"origin","type":"STRING","showAt":null,"showInHours":false,"format":"list:deductOrigin","daysEvaluatedColumns":null},{"table":"deduct","column":"observation","type":"TEXT","showAt":null,"showInHours":false,"format":null,"daysEvaluatedColumns":null}],"filters":[{"field":"deduct_installment.date","operator":"dynamic_period","condition":"AND","value":"this_month:this_month","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":3},{"field":"deduct_installment.has_been_discounted","operator":"equal","condition":"AND","value":true,"variableValue":null,"variableValueType":null,"variableValueTranslated":null,"conditionType":"fixed","references":null,"format":null,"type":"BOOLEAN","isFixedPeriod":false,"isDatePeriod":false,"isDynamicPeriod":false,"isNotInTable":false,"translated":null,"lineNumber":4}],"aggregates":[{"table":"deduct","column":"employee_id","group":true,"sum":false,"avg":false,"max":false,"min":false,"stddev":false,"translated":"Colaborador","id":"deduct.employee_id"},{"table":"deduct_installment","column":"value","group":false,"sum":true,"avg":false,"max":false,"min":false,"stddev":false}],"preview":false,"orderBy":[{"table":"deduct_installment","column":"name","isHeaderColumn":true,"desc":true}],"groupBy":[]} 2022-08-10 19:44:57.447+00 2022-08-10 19:46:45.879+00 77 77 77 REL-000494 table Mostra somente os colaboradores e parcelas que foram descontadas no mês atual Desconto em folha do mês atual deduct_installment
1 110 {"type":"column","categories":"transaction.vehicle_id","values":[{"column":"transaction.traveled_distance","rawColumn":"transaction.traveled_distance__sum__","axis":0,"summarizer":"sum","isMainValue":true}],"legend":{"enabled":false}} 1 27 {"table":"transaction","relationships":[],"type":"table","fields":[{"table":"transaction","column":"vehicle_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":"traveled_distance","type":"DECIMAL","showAt":null,"format":null},{"table":"transaction","column":"accumulated_utilization","type":"DECIMAL","showAt":null,"format":null},{"table":"transaction","column":"type","type":"STRING","showAt":null,"format":"list:transactionTypes"},{"table":"transaction","column":"register_type","type":"STRING","showAt":null,"format":"list:transactionRegisterTypes"},{"table":"transaction","column":"expense_id","type":"INTEGER","showAt":null,"format":null},{"table":"transaction","column":"service_order_id","type":"INTEGER","showAt":null,"format":null},{"table":"transaction","column":"gate_appointment_id","type":"INTEGER","showAt":null,"format":null}],"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.odometer","operator":"not_empty","condition":"AND","value":0,"references":null,"format":null,"type":"DECIMAL","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":"traveled_distance","group":false,"sum":true,"avg":false,"max":false,"min":false}],"preview":false,"orderBy":[{"table":"transaction","column":"date","isHeaderColumn":true,"desc":true}],"hideDetails":false} 2017-09-04 20:59:00.403+00 2022-08-11 19:46:18.221+00 1 77 1 REL-000027 table Este relatório irá exibir todos os registros com hodômetro nos últimos 60 dias. Relatório facilitador para a conferência de data/hora e hodômetro incompatíveis com os já existentes. Linha do tempo - Últimos 60 dias transaction
{"type":"column","categories":"ct_34.cf_648","values":[{"column":"ct_34.cf_654","rawColumn":"ct_34.cf_654__sum__","axis":0,"summarizer":"sum","isMainValue":true}],"legend":{"enabled":true},"filters":{"showOnlyFirstRecords":false,"showAllRecords":true,"recordsToShow":null},"show_values":{"enabled":true}} 433 2700 {"table":"ct_34","relationships":[],"type":"matrix","fields":[{"table":"ct_34","column":"cf_654","type":"DECIMAL","summarizers":{"sum":true,"avg":false,"max":false,"min":false},"showAt":{"inner":true,"total":true},"showInHours":false,"format":null,"daysEvaluatedColumns":null},{"table":"ct_34","column":"cf_647","type":"DECIMAL","showAt":{"inner":true,"total":true},"showInHours":false,"format":null,"daysEvaluatedColumns":null},{"table":"ct_34","column":"cf_648","type":"STRING","showAt":{"inner":true,"total":true},"showInHours":false,"format":null,"daysEvaluatedColumns":null},{"table":"ct_34","column":"cf_658","type":"STRING","showAt":{"inner":true,"total":true},"showInHours":false,"format":null,"daysEvaluatedColumns":null}],"filters":[{"field":"ct_34.cf_658","operator":"equal","condition":"AND","value":"RG LOG","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":14},{"field":"ct_34.cf_656","operator":"equal","condition":"AND","value":"IVECO","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":15},{"field":"ct_34.cf_647","operator":"equal","condition":"AND","value":2022,"variableValue":null,"variableValueType":null,"variableValueTranslated":null,"conditionType":"fixed","references":null,"format":null,"type":"DECIMAL","isFixedPeriod":false,"isDatePeriod":false,"isDynamicPeriod":false,"isNotInTable":false,"translated":null,"lineNumber":16}],"aggregates":[{"table":"ct_34","column":"cf_654","group":false,"sum":true,"avg":false,"max":false,"min":false},{"table":"ct_34","column":"cf_647","group":true,"sum":null,"avg":null,"max":null,"min":null,"matrix_type":"horizontal","translated":"ano","id":"ct_34.cf_647"},{"table":"ct_34","column":"cf_648","group":true,"sum":null,"avg":null,"max":null,"min":null,"matrix_type":"vertical","translated":"frota","id":"ct_34.cf_648"},{"table":"ct_34","column":"cf_658","group":true,"sum":null,"avg":null,"max":null,"min":null,"matrix_type":"vertical","translated":"propriedade","id":"ct_34.cf_658"}],"preview":false,"orderBy":[{"table":"ct_34","column":"cf_647","isHeaderColumn":true,"desc":false}],"groupBy":[]} 2022-10-25 13:38:06.521+00 2022-10-25 13:38:06.57+00 870 870 REL-002700 matrix Relatório de emissões de CO2 referente ano 2022 TOTAL Emissão CO2 (IVECO) ct_34
{"type":"column","categories":"transaction.vehicle_id","values":[{"column":"transaction.traveled_distance","rawColumn":"transaction.traveled_distance__sum__","summarizer":"sum","axis":0,"isMainValue":true}],"legend":{"enabled":true}} 1 1100 {"table":"transaction","relationships":["vehicle"],"type":"table","fields":[{"table":"transaction","column":"vehicle_id","type":"INTEGER","showAt":null,"format":null,"translated":"Veículo"},{"table":"transaction","column":"expense_id","type":"INTEGER","showAt":null,"format":null,"translated":"Despesa"},{"table":"transaction","column":"type","type":"STRING","showAt":null,"format":"list:transactionTypes","translated":"Tipo"},{"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":"traveled_distance","type":"DECIMAL","showAt":null,"format":null,"translated":"Distância percorrida"},{"table":"transaction","column":"item_id","type":"INTEGER","showAt":null,"format":null,"translated":"Item"},{"table":"transaction","column":"final_value","type":"DECIMAL","showAt":null,"format":"Money","translated":"Valor total"},{"table":"_formula","column":"Custo por Km Rodado","type":"formula","query":"SUM(transaction.final_value) / SUM(transaction.traveled_distance)","showAt":null,"format":null}],"filters":[{"field":"transaction.date","operator":"dynamic_period","condition":"AND","value":"last_month:this_month","references":null,"format":null,"type":"DATE","variableValue":null,"variableValueType":null,"conditionType":"fixed","isFixedPeriod":false,"isDynamicPeriod":true,"isDatePeriod":false,"translated":null},{"field":"transaction.vehicle_id","operator":"not_empty","condition":"AND","value":null,"references":"vehicle","format":null,"type":"INTEGER","variableValue":null,"variableValueType":null,"conditionType":"fixed","isFixedPeriod":false,"isDynamicPeriod":false,"isDatePeriod":false,"daysInPeriod":null,"frequencyInPeriod":null,"translated":null},{"field":"transaction.type","operator":"$ne","condition":"AND","value":["revenue"],"references":null,"format":"list:transactionTypes","type":"STRING","variableValue":null,"variableValueType":null,"conditionType":"fixed","isFixedPeriod":false,"isDynamicPeriod":false,"isDatePeriod":false,"translated":null},{"field":"vehicle.measurement_unit","operator":"equal","condition":"AND","value":["km"],"references":null,"format":"list:unitMeasure","type":"STRING","variableValue":null,"variableValueType":null,"conditionType":"fixed","isFixedPeriod":false,"isDynamicPeriod":false,"isDatePeriod":false,"translated":null},{"field":"transaction.vehicle_id","operator":"equal","condition":"AND","value":[340],"references":"vehicle","format":null,"type":"INTEGER","variableValue":null,"variableValueType":null,"conditionType":"fixed","isFixedPeriod":false,"isDynamicPeriod":false,"isNotInTable":false,"isDatePeriod":false,"daysInPeriod":null,"frequencyInPeriod":null,"translated":null}],"aggregates":[{"table":"transaction","column":"vehicle_id","group":true,"sum":false,"avg":false,"max":false,"min":false},{"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}],"hideDetails":false,"groupBy":[],"having":[]} 2022-09-05 11:16:20.906+00 2022-09-05 11:16:21.915+00 77 77 REL-001100 table 637 transaction
136 729 {"table":"transaction","relationships":[],"type":"table","fields":[{"table":"transaction","column":"date","type":"DATE","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":"expense_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":"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}],"filters":[{"field":"transaction.item_id","operator":"equal","condition":"AND","value":[3010],"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":1},{"field":"transaction.date","operator":"dynamic_period","condition":"AND","value":"last_month:last_month","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":"final_value","group":false,"sum":true,"avg":false,"max":false,"min":false,"stddev":false}],"preview":false,"orderBy":[{"table":"transaction","column":"date","isHeaderColumn":true,"desc":true}],"groupBy":[]} 2022-08-18 20:10:41.507+00 2022-08-18 20:10:42.906+00 376 376 REL-000729 table Mostra somente as compras de pneus do mês anterior Compra de pneus do Mês anterior transaction
{"type":"column","categories":"vehicle_leasing.leasing_contract_id","values":[{"column":"vehicle_leasing.monthly_value","rawColumn":"vehicle_leasing.monthly_value__sum__","axis":0,"summarizer":"sum","isMainValue":true}],"legend":{"enabled":true},"filters":{"showOnlyFirstRecords":false,"showAllRecords":true,"recordsToShow":null},"show_values":{"enabled":true}} 2 930 {"table":"vehicle_leasing","relationships":["vehicle","leasing_contract"],"type":"table","fields":[{"table":"vehicle_leasing","column":"leasing_contract_id","type":"INTEGER","showAt":null,"showInHours":false,"format":null,"daysEvaluatedColumns":null},{"table":"leasing_contract","column":"supplier_id","type":"INTEGER","showAt":null,"showInHours":false,"format":null,"daysEvaluatedColumns":null},{"table":"vehicle_leasing","column":"cf_445","type":"STRING","showAt":null,"showInHours":false,"format":null,"daysEvaluatedColumns":null},{"table":"vehicle_leasing","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_leasing","column":"monthly_value","type":"DECIMAL","showAt":null,"showInHours":false,"format":"Money","daysEvaluatedColumns":null},{"table":"vehicle_leasing","column":"lease_start_date","type":"DATE","showAt":null,"showInHours":false,"format":null,"daysEvaluatedColumns":null},{"table":"vehicle_leasing","column":"lease_completion_forecast_date","type":"DATE","showAt":null,"showInHours":false,"format":null,"daysEvaluatedColumns":null},{"table":"vehicle_leasing","column":"devolution_date","type":"DATE","showAt":null,"showInHours":false,"format":null,"daysEvaluatedColumns":null},{"table":"vehicle_leasing","column":"observation","type":"STRING","showAt":null,"showInHours":false,"format":null,"daysEvaluatedColumns":null},{"table":"vehicle_leasing","column":"name","type":"STRING","showAt":null,"showInHours":false,"format":null,"daysEvaluatedColumns":null},{"table":"vehicle_leasing","column":"fine_percentage_devolution","type":"DECIMAL","showAt":null,"showInHours":false,"format":"Percentage","daysEvaluatedColumns":null},{"table":"_formula","column":"Veículos p/ contrato","type":"formula","query":"COUNT(DISTINCT vehicle_leasing.vehicle_id)","showAt":null,"showInHours":false,"format":null,"daysEvaluatedColumns":null,"relatedTables":[{"table":"vehicle_leasing"}]}],"filters":[{"field":"vehicle_leasing.leasing_contract_id","operator":"not_empty","condition":"AND","value":null,"variableValue":null,"variableValueType":null,"variableValueTranslated":null,"conditionType":"fixed","references":"leasing_contract","format":null,"type":"INTEGER","isFixedPeriod":false,"isDatePeriod":false,"isDynamicPeriod":false,"isNotInTable":false,"translated":null,"lineNumber":3},{"field":"vehicle_leasing.supplier_id","operator":"equal","condition":"AND","value":[1354],"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":4}],"aggregates":[{"table":"vehicle_leasing","column":"monthly_value","group":false,"sum":true,"avg":false,"max":false,"min":false,"stddev":false},{"table":"vehicle_leasing","column":"leasing_contract_id","group":true,"sum":false,"avg":false,"max":false,"min":false,"stddev":false},{"table":"leasing_contract","column":"supplier_id","group":true,"sum":false,"avg":false,"max":false,"min":false,"stddev":false}],"preview":false,"orderBy":[],"groupBy":[]} 2022-08-31 17:22:56.049+00 2022-08-31 18:55:29.007+00 177 177 177 REL-000930 table Consulta contratos locação vehicle_leasing
1 527 {"table":"supplier","relationships":[],"type":"table","fields":[{"table":"supplier","column":"name","type":"STRING","showAt":null,"showInHours":false,"format":null,"daysEvaluatedColumns":null},{"table":"supplier","column":"social_name","type":"STRING","showAt":null,"showInHours":false,"format":null,"daysEvaluatedColumns":null},{"table":"supplier","column":"cnpj","type":"STRING","showAt":null,"showInHours":false,"format":null,"daysEvaluatedColumns":null},{"table":"supplier","column":"address_city_id","type":"INTEGER","showAt":null,"showInHours":false,"format":null,"daysEvaluatedColumns":null},{"table":"supplier","column":"type","type":"JSON","showAt":null,"showInHours":false,"format":"list:supplierTypes","daysEvaluatedColumns":null},{"table":"supplier","column":"address_state_id","type":"INTEGER","showAt":null,"showInHours":false,"format":null,"daysEvaluatedColumns":null},{"table":"supplier","column":"address","type":"STRING","showAt":null,"showInHours":false,"format":null,"daysEvaluatedColumns":null},{"table":"supplier","column":"address_neighborhood","type":"STRING","showAt":null,"showInHours":false,"format":null,"daysEvaluatedColumns":null},{"table":"supplier","column":"address_num","type":"STRING","showAt":null,"showInHours":false,"format":null,"daysEvaluatedColumns":null}],"filters":[],"aggregates":[],"preview":false,"orderBy":[{"table":"supplier","column":"social_name","isHeaderColumn":true,"desc":false}],"groupBy":[]} 2022-08-11 20:42:34.657+00 2022-08-11 20:45:49.913+00 514 514 514 REL-000527 table Fornecedor - Lista de fornecedores supplier