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":"column","categories":"tire.subsidiary_id","values":[{"column":"_formula.quantidade por filial","rawColumn":"_formula.quantidade por filial","axis":0,"summarizer":"formula","isMainValue":true}],"legend":{"enabled":true},"show_values":{"enabled":true},"use_diferent_color":{},"stacked_column":{"enabled":false},"filters":{"showOnlyFirstRecords":false,"showAllRecords":true,"recordsToShow":null}} 202 560 {"table":"tire_life","relationships":["tire"],"type":"table","fields":[{"table":"tire","column":"subsidiary_id","type":"INTEGER","showAt":null,"showInHours":false,"format":null,"daysEvaluatedColumns":null},{"table":"_formula","column":"quantidade por filial","type":"formula","query":"COUNT(DISTINCT tire_life.tire_id)","showAt":null,"showInHours":false,"format":null,"daysEvaluatedColumns":null,"relatedTables":[{"table":"tire_life"}]},{"table":"tire","column":"tire_brand_id","type":"INTEGER","showAt":null,"showInHours":false,"format":null,"daysEvaluatedColumns":null},{"table":"tire","column":"name","type":"STRING","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","column":"tire_dimension_id","type":"INTEGER","showAt":null,"showInHours":false,"format":null,"daysEvaluatedColumns":null},{"table":"tire_life","column":"current_vehicle_id","type":"INTEGER","showAt":null,"showInHours":false,"format":null,"daysEvaluatedColumns":null},{"table":"tire","column":"current_tire_position","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}],"filters":[{"field":"tire.status","operator":"$ne","condition":"AND","value":["discarded"],"variableValue":null,"variableValueType":null,"variableValueTranslated":null,"conditionType":"fixed","references":null,"format":"list:tireStatus","type":"STRING","isFixedPeriod":false,"isDatePeriod":false,"isDynamicPeriod":false,"isNotInTable":false,"translated":null,"lineNumber":1}],"aggregates":[{"table":"tire","column":"subsidiary_id","group":true,"sum":false,"avg":false,"max":false,"min":false,"stddev":false,"translated":"Filial","id":"tire.subsidiary_id"}],"preview":false,"orderBy":[{"table":"tire","column":"subsidiary_id","isHeaderColumn":true,"desc":true}],"groupBy":[],"hideDetails":false} 2022-08-15 19:25:15.785+00 2022-08-15 19:25:49.169+00 77 77 77 REL-000560 table Mostra a quantidade de pneus que tem em cada filial Quantidade de pneus por filial tire_life
{"type":"column","categories":"vehicle.state_id","values":[{"column":"_formula.qt","rawColumn":"_formula.qt","summarizer":"formula","axis":0,"isMainValue":true}],"legend":{"enabled":true}} 1 593 {"table":"vehicle","relationships":[],"type":"table","fields":[{"table":"vehicle","column":"state_id","type":"INTEGER","showAt":null,"showInHours":false,"format":null,"daysEvaluatedColumns":null},{"table":"_formula","column":"qt","type":"formula","query":"COUNT(DISTINCT vehicle.id)","showAt":null,"showInHours":false,"format":null,"daysEvaluatedColumns":null,"relatedTables":[{"table":"vehicle"}]},{"table":"vehicle","column":"license_plate","type":"STRING","showAt":null,"showInHours":false,"format":null,"daysEvaluatedColumns":null},{"table":"vehicle","column":"city_id","type":"INTEGER","showAt":null,"showInHours":false,"format":null,"daysEvaluatedColumns":null}],"filters":[],"aggregates":[{"table":"vehicle","column":"state_id","group":true,"sum":false,"avg":false,"max":false,"min":false,"stddev":false}],"preview":false,"orderBy":[{"table":"vehicle","column":"state_id","isHeaderColumn":true,"desc":true}],"groupBy":[],"hideDetails":true} 2022-08-17 13:34:22.121+00 2022-08-17 13:41:50.185+00 2022-08-17 13:41:50.18+00 376 376 376 376 REL-000593 table 1 vehicle
268 3109 {"table":"vehicle","relationships":["group","modelversion","cost_center","model"],"type":"table","fields":[{"table":"vehicle","column":"license_plate","type":"STRING","showAt":null,"showInHours":false,"format":null,"daysEvaluatedColumns":null},{"table":"vehicle","column":"cf_611","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_379","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_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":"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":"cf_36","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":"vehicle","column":"chassis_number","type":"STRING","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":"vehicle_group_id","type":"INTEGER","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":"cf_663","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_by_id","type":"INTEGER","showAt":null,"showInHours":false,"format":null,"daysEvaluatedColumns":null},{"table":"vehicle","column":"created_at","type":"DATE","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_611","operator":"not_empty","condition":"AND","value":null,"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.license_plate","operator":"not_empty","condition":"AND","value":null,"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},{"field":"vehicle.cf_34","operator":"not_empty","condition":"AND","value":null,"variableValue":null,"variableValueType":null,"variableValueTranslated":null,"conditionType":"fixed","references":null,"format":null,"type":"STRING","isFixedPeriod":false,"isDatePeriod":false,"isDynamicPeriod":false,"isNotInTable":false,"translated":null,"lineNumber":10}],"aggregates":[],"preview":false,"orderBy":[],"groupBy":[]} 2022-11-01 17:52:48.853+00 2022-11-01 17:52:50.758+00 870 870 REL-003109 table relatório para verificar veículos e semirreboques ativos RELATÓRIO ANALITICO VEICULOS v7 vehicle
136 728 {"table":"transaction","relationships":[],"type":"table","fields":[{"table":"transaction","column":"date","type":"DATE","showAt":null,"showInHours":false,"format":null,"daysEvaluatedColumns":null,"translated":"Data"},{"table":"transaction","column":"supplier_id","type":"INTEGER","showAt":null,"showInHours":false,"format":null,"daysEvaluatedColumns":null,"translated":"Fornecedor"},{"table":"transaction","column":"expense_id","type":"INTEGER","showAt":null,"showInHours":false,"format":null,"daysEvaluatedColumns":null,"translated":"Despesa"},{"table":"transaction","column":"item_id","type":"INTEGER","showAt":null,"showInHours":false,"format":null,"daysEvaluatedColumns":null,"translated":"Item"},{"table":"transaction","column":"unit_value","type":"DECIMAL","showAt":null,"showInHours":false,"format":"Money","daysEvaluatedColumns":null,"translated":"Valor unitário"},{"table":"transaction","column":"final_value","type":"DECIMAL","showAt":null,"showInHours":false,"format":"Money","daysEvaluatedColumns":null,"translated":"Valor total"}],"filters":[{"field":"transaction.item_id","operator":"equal","condition":"AND","value":[3010],"references":"item","format":null,"type":"INTEGER","variableValue":null,"variableValueType":null,"conditionType":"fixed","isFixedPeriod":false,"isDynamicPeriod":false,"isNotInTable":false,"isDatePeriod":false,"translated":null},{"field":"transaction.date","operator":"dynamic_period","condition":"AND","value":"this_month:this_month","references":null,"format":null,"type":"DATE","variableValue":null,"variableValueType":null,"conditionType":"fixed","isFixedPeriod":false,"isDynamicPeriod":true,"isNotInTable":false,"isDatePeriod":false,"translated":null},{"field":"transaction.expense_id","operator":"not_empty","condition":"AND","value":null,"references":"expense","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":"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:05.456+00 2022-08-18 20:12:16.895+00 376 376 376 REL-000728 table Mostra somente as compras de pneus do mês atua Compra de pneus do Mês atual transaction
1 626 {"table":"employee","relationships":["user"],"type":"table","fields":[{"table":"employee","column":"name","type":"STRING","showAt":null,"showInHours":false,"format":null,"daysEvaluatedColumns":null},{"table":"employee","column":"user_id","type":"INTEGER","showAt":null,"showInHours":false,"format":null,"daysEvaluatedColumns":null},{"table":"user","column":"profile_id","type":"INTEGER","showAt":null,"showInHours":false,"format":null,"daysEvaluatedColumns":null},{"table":"user","column":"user_name","type":"STRING","showAt":null,"showInHours":false,"format":null,"daysEvaluatedColumns":null},{"table":"user","column":"created_at","type":"DATE","showAt":null,"showInHours":false,"format":null,"daysEvaluatedColumns":null},{"table":"user","column":"last_login_date","type":"DATE","showAt":null,"showInHours":false,"format":null,"daysEvaluatedColumns":null}],"filters":[{"field":"user.is_support","operator":"equal","condition":"AND","value":false,"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":1},{"field":"user.profile_id","operator":"equal","condition":"AND","value":[37],"variableValue":null,"variableValueType":null,"variableValueTranslated":null,"conditionType":"fixed","references":"profile","format":null,"type":"INTEGER","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 14:39:17.809+00 2022-08-17 19:54:54.959+00 514 514 514 REL-000626 table Usuários - Colaboradores x usuários employee
2 4712 {"table":"service_order","relationships":["vehicle"],"type":"table","fields":[{"table":"service_order","column":"vehicle_id","type":"INTEGER","showAt":null,"showInHours":false,"format":null,"daysEvaluatedColumns":null},{"table":"service_order","column":"name","type":"STRING","showAt":null,"showInHours":false,"format":null,"daysEvaluatedColumns":null},{"table":"service_order","column":"service_start_date","type":"DATE","showAt":null,"showInHours":false,"format":null,"daysEvaluatedColumns":null},{"table":"service_order","column":"service_finish_date","type":"DATE","showAt":null,"showInHours":false,"format":null,"daysEvaluatedColumns":null},{"table":"service_order","column":"vehicle_down_hours","type":"DECIMAL","showAt":null,"showInHours":false,"format":null,"daysEvaluatedColumns":null},{"table":"_formula","column":"Qtd OS's","type":"formula","query":"COUNT(DISTINCT service_order.id)","showAt":null,"showInHours":false,"format":null,"daysEvaluatedColumns":null},{"table":"_formula","column":"MTTR (Em horas)","type":"formula","query":"SUM(service_order.vehicle_down_hours)/COUNT(DISTINCT service_order.id)","showAt":null,"showInHours":false,"format":null,"daysEvaluatedColumns":null},{"table":"_formula","column":"Qtd Veículos","type":"formula","query":"COUNT(DISTINCT service_order.vehicle_id)","showAt":null,"showInHours":false,"format":null,"daysEvaluatedColumns":null},{"table":"_formula","column":"Dias Avaliados","type":"formula","query":"DAYS_EVALUATED(service_order.service_finish_date)*COUNT(DISTINCT service_order.vehicle_id)","showAt":null,"showInHours":false,"format":null,"daysEvaluatedColumns":["service_order.service_finish_date"]},{"table":"_formula","column":"Dias parados do veículo","type":"formula","query":"DATE_DIFF('days', service_order.service_start_date, service_order.service_finish_date)","showAt":null,"showInHours":false,"format":null,"daysEvaluatedColumns":null},{"table":"_formula","column":"MTBF (Em dias)","type":"formula","query":"CASE WHEN SUM(service_order.vehicle_down_hours)/24 > DAYS_EVALUATED(service_order.service_finish_date)*COUNT(DISTINCT service_order.vehicle_id) THEN NULL ELSE ((DAYS_EVALUATED(service_order.service_finish_date)*COUNT(DISTINCT service_order.vehicle_id))-(SUM(service_order.vehicle_down_hours)/24))/COUNT(DISTINCT service_order.id) END","showAt":null,"showInHours":false,"format":null,"daysEvaluatedColumns":["service_order.service_finish_date","service_order.service_finish_date"]},{"table":"_formula","column":"Disponibilidade (%)","type":"formula","query":"CASE WHEN SUM(service_order.vehicle_down_hours)/24 > DAYS_EVALUATED(service_order.service_finish_date)*COUNT(DISTINCT service_order.vehicle_id) THEN NULL ELSE ((DAYS_EVALUATED(service_order.service_finish_date)*COUNT(DISTINCT service_order.vehicle_id))-(SUM(service_order.vehicle_down_hours)/24))*100/(DAYS_EVALUATED(service_order.service_finish_date)*COUNT(DISTINCT service_order.vehicle_id)) END","showAt":null,"showInHours":false,"format":null,"daysEvaluatedColumns":["service_order.service_finish_date","service_order.service_finish_date","service_order.service_finish_date"]}],"filters":[{"field":"service_order.service_finish_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,"fixed":true,"isNotInTable":false,"usedInFormulas":["_formula.Dias Avaliados","_formula.MTBF (Em dias)","_formula.Disponibilidade (%)","_formula.Disponibilidade (%) ","_formula.Dias Paradas do Veículo - Limitado","_formula.Horas paradas do veículo - Limitado","_formula.MTTR (Em horas)","_formula.MTTR (Em horas - Individual limitado)","_formula.MTBF (Em dias)"],"translated":null,"lineNumber":1},{"field":"service_order.service_finish_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,"fixed":true,"isNotInTable":false,"usedInFormulas":["_formula.Dias Avaliados","_formula.MTBF (Em dias)","_formula.Disponibilidade (%)","_formula.Disponibilidade (%) ","_formula.Dias Paradas do Veículo - Limitado","_formula.Horas paradas do veículo - Limitado","_formula.MTTR (Em horas)","_formula.MTTR (Em horas - Individual limitado)","_formula.MTBF (Em dias)"],"translated":null,"lineNumber":1},{"field":"service_order.type","operator":"equal","condition":"AND","value":["corrective"],"variableValue":null,"variableValueType":null,"variableValueTranslated":null,"conditionType":"fixed","references":null,"format":"list:serviceOrderTypes","type":"STRING","isFixedPeriod":false,"isDatePeriod":false,"isDynamicPeriod":false,"translated":null,"lineNumber":2},{"field":"service_order.status","operator":"equal","condition":"AND","value":["waiting_nf","finished"],"variableValue":null,"variableValueType":null,"variableValueTranslated":null,"conditionType":"fixed","references":null,"format":"list:serviceOrderStatus","type":"STRING","isFixedPeriod":false,"isDatePeriod":false,"isDynamicPeriod":false,"translated":null,"lineNumber":3},{"field":"vehicle.cf_379","operator":"$ne","condition":"AND","value":["SEMIRREBOQUE","REBOQUE","PASSEIO"],"variableValue":null,"variableValueType":null,"variableValueTranslated":null,"conditionType":"fixed","references":null,"format":null,"type":"STRING","isFixedPeriod":false,"isDatePeriod":false,"isDynamicPeriod":false,"isNotInTable":false,"translated":null,"lineNumber":4}],"aggregates":[{"table":"service_order","column":"vehicle_id","group":true,"sum":false,"avg":false,"max":false,"min":false},{"table":"service_order","column":"vehicle_down_hours","group":false,"sum":false,"avg":false,"max":false,"min":false}],"preview":false,"orderBy":[{"table":"service_order","column":"service_start_date","isHeaderColumn":true,"desc":true}],"groupBy":[]} 2023-03-03 12:06:15.665+00 2023-03-03 12:06:15.701+00 870 870 REL-004712 table Indicadores MTTR , MTBF e Disponibilidade baseado em: Ordens de serviço corretiva terminadas no período informado. MTBF - "Mean Time Between Failures" ou Tempo Médio Entre Falhas MTBF = (Tempo total disponível – Tempo perdido) / Número de paradas MTTR - "Mean Time To Repair" ou Tempo Médio de Reparo MTTR = Tempo total de reparo / Quantidade de falhas MTTR = Tempo perdido / Número de paradas Disponibilidade (Pela corretiva) = MTBF/(MTBF + MTTR) Disponibilidade (Pela corretiva) = (Tempo total disponível – Tempo perdido) /Tempo total disponível Observações: Falhas = Ordens de serviço corretivas Número de paradas = Quantidade de ordens de serviço corretivas. Tempo total de reparo ou Tempo perdido = Tempo da ordem de serviço do início ao fim. Os indicadores MTBF e Disponibilidade individualmente serão 0 sempre que o tempo perdido for igual ou maior que o período avaliado. Indicador - MTTR , MTBF e Disponibilidade U30d - Corretivas jan/2023 service_order
{"type":"column","categories":"user.profile_id","values":[{"column":"_formula.Qtde.","rawColumn":"_formula.Qtde.","summarizer":"formula","axis":0,"isMainValue":true}],"legend":{"enabled":true}} 1 627 {"table":"user","relationships":[],"type":"table","fields":[{"table":"user","column":"profile_id","type":"INTEGER","showAt":null,"showInHours":false,"format":null,"daysEvaluatedColumns":null},{"table":"user","column":"name","type":"STRING","showAt":null,"showInHours":false,"format":null,"daysEvaluatedColumns":null},{"table":"user","column":"user_name","type":"STRING","showAt":null,"showInHours":false,"format":null,"daysEvaluatedColumns":null},{"table":"_formula","column":"Qtde.","type":"formula","query":"COUNT(DISTINCT user.id)","showAt":null,"showInHours":false,"format":null,"daysEvaluatedColumns":null,"relatedTables":[{"table":"user"}]}],"filters":[{"field":"user.is_support","operator":"equal","condition":"AND","value":false,"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":1},{"field":"user.profile_id","operator":"equal","condition":"AND","value":[37],"variableValue":null,"variableValueType":null,"variableValueTranslated":null,"conditionType":"fixed","references":"profile","format":null,"type":"INTEGER","isFixedPeriod":false,"isDatePeriod":false,"isDynamicPeriod":false,"isNotInTable":false,"translated":null,"lineNumber":2}],"aggregates":[{"table":"user","column":"profile_id","group":true,"sum":false,"avg":false,"max":false,"min":false,"stddev":false}],"preview":false,"orderBy":[{"table":"user","column":"name","isHeaderColumn":true,"desc":false}],"groupBy":[]} 2022-08-17 14:58:54.794+00 2022-08-17 19:52:12.844+00 2022-08-17 19:52:12.839+00 514 514 514 514 REL-000627 table Usuários - Motorista / Checklist user
1 661 {"table":"vehicle","relationships":["employee","subsidiary","group","model"],"type":"table","fields":[{"table":"vehicle","column":"vehicle_model_version_id","type":"INTEGER","showAt":null,"showInHours":false,"format":null,"daysEvaluatedColumns":null},{"table":"vehicle","column":"motorized","type":"BOOLEAN","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":"name","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":"version_identification","type":"STRING","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":"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":"cf_34","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_70","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_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_37","type":"STRING","showAt":null,"showInHours":false,"format":null,"daysEvaluatedColumns":null},{"table":"vehicle","column":"cf_108","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":3}],"aggregates":[],"preview":false,"orderBy":[],"groupBy":[]} 2022-08-17 19:53:27.2+00 2022-08-17 19:57:15.865+00 376 376 376 REL-000661 table Cadastro dos veiculos vehicle
{"type":"column","categories":"vehicle.motorized","values":[{"column":"_formula.Quantidade","rawColumn":"_formula.Quantidade","axis":0,"summarizer":"formula","isMainValue":true}],"legend":{"enabled":false},"show_values":{"enabled":true},"use_diferent_color":{"enabled":false},"stacked_column":{"enabled":false},"filters":{"showOnlyFirstRecords":false,"showAllRecords":true,"recordsToShow":null}} 1 694 {"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":"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":"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}],"filters":[{"field":"vehicle.status","operator":"equal","condition":"AND","value":["active","inactive"],"variableValue":null,"variableValueType":null,"variableValueTranslated":null,"conditionType":"fixed","references":null,"format":"list:vehicleStatus","type":"STRING","isDatePeriod":false,"translated":null,"lineNumber":1}],"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-08-18 17:28:27.897+00 2022-08-18 17:29:01.719+00 376 376 376 REL-000694 table Cadastro de veiculo ativos vehicle
{"type":"column","categories":"transaction.vehicle_id","values":[{"column":"transaction.real_consumption","rawColumn":"transaction.real_consumption__avg__","axis":0,"summarizer":"avg","isMainValue":true}],"legend":{"enabled":true},"filters":{"showOnlyFirstRecords":false,"showAllRecords":true,"recordsToShow":null},"show_values":{"enabled":true}} 433 2701 {"table":"transaction","relationships":["vehicle"],"type":"matrix","fields":[{"table":"transaction","column":"date","type":"DATE","date_config":["month","year"],"showAt":{"inner":true,"total":true},"showInHours":false,"format":null,"daysEvaluatedColumns":null,"is_full_period":false},{"table":"transaction","column":"real_consumption","type":"DECIMAL","summarizers":{"sum":false,"avg":true,"max":false,"min":false},"showAt":{"inner":true,"total":true},"showInHours":false,"format":null,"daysEvaluatedColumns":null},{"table":"transaction","column":"vehicle_id","type":"INTEGER","showAt":{"inner":true,"total":true},"showInHours":false,"format":null,"daysEvaluatedColumns":null}],"filters":[{"field":"transaction.register_type","operator":"equal","condition":"AND","value":["Abastecimento"],"variableValue":null,"variableValueType":null,"variableValueTranslated":null,"conditionType":"fixed","references":null,"format":"list:transactionRegisterTypes","type":"STRING","isFixedPeriod":false,"isDatePeriod":false,"isDynamicPeriod":false,"isNotInTable":false,"translated":null,"lineNumber":1},{"field":"transaction.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":2},{"field":"transaction.real_consumption","operator":"$gt","condition":"AND","value":0.01,"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":3},{"field":"vehicle.cf_34","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":4},{"field":"vehicle.cf_142","operator":"equal","condition":"AND","value":"SCANIA","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":5}],"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":"real_consumption","group":false,"sum":false,"avg":true,"max":false,"min":false},{"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"}],"preview":false,"orderBy":[{"table":"transaction","column":"date","isHeaderColumn":true,"desc":false}],"groupBy":[]} 2022-10-25 13:39:11.405+00 2022-10-25 13:39:11.51+00 870 870 REL-002701 matrix Consumo médio por veículo marca VOLVO Consumo médio por frota (SCANIA) transaction