| | | | | 2 | 4480 | {"table":"transaction","relationships":["item","vehicle"],"type":"table","fields":[{"table":"vehicle","column":"cf_611","type":"STRING","showAt":null,"showInHours":false,"format":null,"daysEvaluatedColumns":null},{"table":"transaction","column":"date","type":"DATE","showAt":null,"showInHours":false,"format":null,"daysEvaluatedColumns":null},{"table":"transaction","column":"type","type":"STRING","showAt":null,"showInHours":false,"format":"list:transactionTypes","daysEvaluatedColumns":null},{"table":"item","column":"type","type":"STRING","showAt":null,"showInHours":false,"format":"list:itemTypes","daysEvaluatedColumns":null},{"table":"transaction","column":"final_value","type":"DECIMAL","showAt":null,"showInHours":false,"format":"Money","daysEvaluatedColumns":null}],"filters":[{"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":1}],"aggregates":[],"preview":false,"orderBy":[],"groupBy":[]} | 2023-02-22 11:20:15.351+00 | 2023-02-22 11:28:17.691+00 | | 870 | 870 | | 870 | REL-004480 | table | Relatório de Resultado por veículos 2023 | Relatório de Resultado por veículos 2023 | transaction |
| | | | {"type":"column","categories":"item.type","values":[{"column":"transaction.final_value","rawColumn":"transaction.final_value__sum__","summarizer":"sum","axis":0,"isMainValue":true}],"legend":{"enabled":true}} | 2 | 4579 | {"table":"transaction","relationships":["vehicle","service_order","item"],"type":"matrix","fields":[{"table":"vehicle","column":"cf_611","type":"STRING","showAt":{"inner":true,"total":true},"showInHours":false,"format":null,"daysEvaluatedColumns":null},{"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":"transaction","column":"distance","type":"DECIMAL","summarizers":{"sum":true,"avg":false,"max":false,"min":false},"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}],"filters":[{"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,"fixed":false,"isNotInTable":false,"translated":null,"lineNumber":1},{"field":"service_order.status","operator":"equal","condition":"AND","value":[],"variableValue":null,"variableValueType":null,"variableValueTranslated":null,"conditionType":"fixed","references":null,"format":"list:serviceOrderStatus","type":"STRING","isFixedPeriod":false,"isDatePeriod":false,"isDynamicPeriod":false,"isNotInTable":false,"translated":null,"lineNumber":2}],"aggregates":[{"table":"vehicle","column":"cf_611","group":true,"sum":null,"avg":null,"max":null,"min":null,"matrix_type":"vertical"},{"table":"transaction","column":"final_value","group":false,"sum":true,"avg":false,"max":false,"min":false},{"table":"transaction","column":"distance","group":false,"sum":true,"avg":false,"max":false,"min":false},{"table":"item","column":"type","group":true,"sum":null,"avg":null,"max":null,"min":null,"matrix_type":"horizontal"}],"preview":false,"orderBy":[{"table":"item","column":"type","isHeaderColumn":true,"desc":false}],"groupBy":[]} | 2023-02-22 18:25:25.774+00 | 2023-02-22 19:18:17.202+00 | | 177 | 177 | | 177 | REL-004579 | matrix | | Teste suporte | transaction |
| | | | | 2 | 4546 | {"table":"service_order","relationships":["vehicle"],"type":"table","fields":[{"table":"service_order","column":"vehicle_id","type":"INTEGER","showAt":null,"showInHours":false,"format":null,"daysEvaluatedColumns":null,"translated":"Veículo"},{"table":"service_order","column":"name","type":"STRING","showAt":null,"showInHours":false,"format":null,"daysEvaluatedColumns":null,"translated":"Nome"},{"table":"service_order","column":"service_start_date","type":"DATE","showAt":null,"showInHours":false,"format":null,"daysEvaluatedColumns":null,"translated":"Data de início do serviço"},{"table":"service_order","column":"service_finish_date","type":"DATE","showAt":null,"showInHours":false,"format":null,"daysEvaluatedColumns":null,"translated":"Data de término do serviço"},{"table":"service_order","column":"vehicle_down_hours","type":"DECIMAL","showAt":null,"showInHours":false,"format":null,"daysEvaluatedColumns":null,"translated":"Horas paradas do veículo"},{"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":"dynamic_period","condition":"AND","value":"last_month:last_month","references":null,"format":null,"type":"DATE","variableValue":null,"variableValueType":null,"conditionType":"fixed","isFixedPeriod":false,"isDynamicPeriod":true,"isNotInTable":false,"isDatePeriod":false,"translated":null,"fixed":true,"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)"]},{"field":"service_order.type","operator":"equal","condition":"AND","value":["corrective"],"references":null,"format":"list:serviceOrderTypes","type":"STRING","variableValue":null,"variableValueType":null,"conditionType":"fixed","isFixedPeriod":false,"isDynamicPeriod":false,"isDatePeriod":false,"translated":null},{"field":"service_order.status","operator":"equal","condition":"AND","value":["waiting_nf","finished"],"references":null,"format":"list:serviceOrderStatus","type":"STRING","variableValue":null,"variableValueType":null,"conditionType":"fixed","isFixedPeriod":false,"isDynamicPeriod":false,"isDatePeriod":false,"translated":null}],"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}],"hideDetails":true,"groupBy":[],"having":[]} | 2023-02-22 13:55:37.213+00 | 2023-02-22 13:55:37.234+00 | | 870 | | | 870 | REL-004546 | 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 - Corretiva | service_order |
| | | | {"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}} | 268 | 4513 | {"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":"distance","type":"DECIMAL","summarizers":{"sum":true,"avg":false,"max":false,"min":false},"showAt":{"inner":true,"total":true},"showInHours":false,"format":null,"daysEvaluatedColumns":null}],"filters":[{"field":"transaction.type","operator":"equal","condition":"AND","value":["expense"],"variableValue":null,"variableValueType":null,"variableValueTranslated":null,"conditionType":"fixed","references":null,"format":"list:transactionTypes","type":"STRING","isDatePeriod":false,"translated":null,"lineNumber":9},{"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":10},{"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":11},{"field":"item.type","operator":"$ne","condition":"AND","value":["Despesa de Viagem"],"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":12}],"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":"distance","group":false,"sum":true,"avg":false,"max":false,"min":false}],"preview":false,"orderBy":[{"table":"item","column":"type","isHeaderColumn":true,"desc":false}],"groupBy":[]} | 2023-02-22 11:50:23.044+00 | 2023-02-22 16:56:51.618+00 | | 870 | 177 | | 870 | REL-004513 | matrix | Despesas - Custos totais mensais por veiculo 2023 | Despesas - Custos totais mensais por veiculo 2023 | transaction |
| | | | | 565 | 4612 | {"table":"transaction","relationships":[],"type":"table","fields":[{"table":"transaction","column":"date","type":"DATE","showAt":null,"showInHours":false,"format":null,"daysEvaluatedColumns":null},{"table":"transaction","column":"vehicle_id","type":"INTEGER","showAt":null,"showInHours":false,"format":null,"daysEvaluatedColumns":null},{"table":"transaction","column":"supplier_id","type":"INTEGER","showAt":null,"showInHours":false,"format":null,"daysEvaluatedColumns":null},{"table":"transaction","column":"item_id","type":"INTEGER","showAt":null,"showInHours":false,"format":null,"daysEvaluatedColumns":null},{"table":"transaction","column":"doc_number","type":"STRING","showAt":null,"showInHours":false,"format":null,"daysEvaluatedColumns":null},{"table":"transaction","column":"final_value","type":"DECIMAL","showAt":null,"showInHours":false,"format":"Money","daysEvaluatedColumns":null},{"table":"transaction","column":"invoice_due_date","type":"DATE","showAt":null,"showInHours":false,"format":null,"daysEvaluatedColumns":null}],"filters":[{"field":"transaction.supplier_id","operator":"equal","condition":"AND","value":[898],"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":1}],"aggregates":[{"table":"transaction","column":"final_value","group":false,"sum":true,"avg":false,"max":false,"min":false,"stddev":false}],"preview":false,"orderBy":[],"groupBy":[]} | 2023-02-23 19:44:50.647+00 | 2023-02-23 19:44:50.671+00 | | 177 | | | 177 | REL-004612 | table | | Despesas faturas Scania | transaction |
| | | | | 2 | 4645 | {"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":"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,"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":4},{"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":5},{"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":6},{"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":7}],"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-02-28 12:14:53.359+00 | 2023-02-28 12:14:53.391+00 | | 870 | | | 870 | REL-004645 | 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 | service_order |