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":"ct_34.cf_648","values":[{"column":"ct_34.cf_655","rawColumn":"ct_34.cf_655__avg__","axis":0,"summarizer":"avg","isMainValue":true}],"legend":{"enabled":true},"filters":{"showOnlyFirstRecords":false,"showAllRecords":true,"recordsToShow":null},"show_values":{"enabled":true}} 433 3291 {"table":"ct_34","relationships":[],"type":"matrix","fields":[{"table":"ct_34","column":"cf_648","type":"STRING","showAt":{"inner":true,"total":true},"showInHours":false,"format":null,"daysEvaluatedColumns":null},{"table":"ct_34","column":"cf_649","type":"STRING","showAt":{"inner":true,"total":true},"showInHours":false,"format":null,"daysEvaluatedColumns":null},{"table":"ct_34","column":"cf_655","type":"DECIMAL","summarizers":{"sum":false,"avg":true,"max":false,"min":false},"showAt":{"inner":true,"total":true},"showInHours":false,"format":null,"daysEvaluatedColumns":null},{"table":"ct_34","column":"cf_646","type":"DECIMAL","showAt":{"inner":true,"total":true},"showInHours":false,"format":null,"daysEvaluatedColumns":null}],"filters":[{"field":"ct_34.created_at","operator":"$gte","condition":"AND","value":"2022-11-16T03: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":1},{"field":"ct_34.created_at","operator":"$lte","condition":"AND","value":"2024-01-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":1},{"field":"ct_34.cf_646","operator":"equal","condition":"AND","value":11,"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":2},{"field":"ct_34.cf_656","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":3},{"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":4}],"aggregates":[{"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_649","group":true,"sum":null,"avg":null,"max":null,"min":null,"matrix_type":"vertical","translated":"placa","id":"ct_34.cf_649"},{"table":"ct_34","column":"cf_655","group":false,"sum":false,"avg":true,"max":false,"min":false},{"table":"ct_34","column":"cf_646","group":true,"sum":null,"avg":null,"max":null,"min":null,"matrix_type":"horizontal"}],"preview":false,"orderBy":[{"table":"ct_34","column":"cf_646","isHeaderColumn":true,"desc":false}],"groupBy":[]} 2022-11-16 18:31:52.244+00 2022-12-07 12:05:49.467+00 870 870 870 REL-003291 matrix Mostra a média referente o mês anterior por frota. MÉDIAS FROTA GERAL (SCANIA) ct_34
2 4819 {"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":"_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":5},{"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":5},{"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":6},{"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":7},{"field":"vehicle.cf_379","operator":"$ne","condition":"AND","value":["SEMIRREBOQUE","REBOQUE","PASSEIO","UTILITARIO"],"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}],"aggregates":[],"preview":false,"orderBy":[],"groupBy":[]} 2023-03-06 14:16:08.727+00 2023-03-06 14:16:08.745+00 870 870 REL-004819 table Indicadores 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 - Disponibilidade - Corretivas 012023 service_order
{"type":"column","categories":"ct_34.cf_648","values":[{"column":"ct_34.cf_655","rawColumn":"ct_34.cf_655__avg__","axis":0,"summarizer":"avg","isMainValue":true}],"legend":{"enabled":true},"filters":{"showOnlyFirstRecords":false,"showAllRecords":true,"recordsToShow":null},"show_values":{"enabled":true}} 433 3287 {"table":"ct_34","relationships":[],"type":"matrix","fields":[{"table":"ct_34","column":"cf_648","type":"STRING","showAt":{"inner":true,"total":true},"showInHours":false,"format":null,"daysEvaluatedColumns":null},{"table":"ct_34","column":"cf_649","type":"STRING","showAt":{"inner":true,"total":true},"showInHours":false,"format":null,"daysEvaluatedColumns":null},{"table":"ct_34","column":"cf_655","type":"DECIMAL","summarizers":{"sum":false,"avg":true,"max":false,"min":false},"showAt":{"inner":true,"total":true},"showInHours":false,"format":null,"daysEvaluatedColumns":null},{"table":"ct_34","column":"cf_646","type":"DECIMAL","showAt":{"inner":true,"total":true},"showInHours":false,"format":null,"daysEvaluatedColumns":null}],"filters":[{"field":"ct_34.created_at","operator":"$gte","condition":"AND","value":"2022-11-16T03: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":1},{"field":"ct_34.created_at","operator":"$lte","condition":"AND","value":"2024-01-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":1},{"field":"ct_34.cf_646","operator":"equal","condition":"AND","value":11,"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":2},{"field":"ct_34.cf_656","operator":"equal","condition":"AND","value":"VOLKSWAGEN","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":3},{"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":4}],"aggregates":[{"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_649","group":true,"sum":null,"avg":null,"max":null,"min":null,"matrix_type":"vertical","translated":"placa","id":"ct_34.cf_649"},{"table":"ct_34","column":"cf_655","group":false,"sum":false,"avg":true,"max":false,"min":false},{"table":"ct_34","column":"cf_646","group":true,"sum":null,"avg":null,"max":null,"min":null,"matrix_type":"horizontal"}],"preview":false,"orderBy":[{"table":"ct_34","column":"cf_646","isHeaderColumn":true,"desc":false}],"groupBy":[]} 2022-11-16 18:25:38.827+00 2022-12-07 12:05:22.334+00 870 870 870 REL-003287 matrix Mostra a média referente o mês anterior por frota. MÉDIAS FROTA GERAL (VOLKSWAGEN) ct_34
{"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},"show_values":{"enabled":true},"use_diferent_color":{"enabled":false},"stacked_column":{"enabled":false},"filters":{"showOnlyFirstRecords":false,"showAllRecords":true,"recordsToShow":null}} 433 2695 {"table":"ct_34","relationships":[],"type":"matrix","fields":[{"table":"ct_34","column":"cf_656","type":"STRING","showAt":{"inner":true,"total":true},"showInHours":false,"format":null,"daysEvaluatedColumns":null},{"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_658","type":"STRING","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}],"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":3}],"aggregates":[{"table":"ct_34","column":"cf_656","group":true,"sum":null,"avg":null,"max":null,"min":null,"matrix_type":"vertical","translated":"marca","id":"ct_34.cf_656"},{"table":"ct_34","column":"cf_654","group":false,"sum":true,"avg":false,"max":false,"min":false},{"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"},{"table":"ct_34","column":"cf_647","group":true,"sum":null,"avg":null,"max":null,"min":null,"matrix_type":"horizontal"}],"preview":false,"orderBy":[{"table":"ct_34","column":"cf_647","isHeaderColumn":true,"desc":false},{"table":"ct_34","column":"cf_656","isHeaderColumn":true,"desc":false}],"groupBy":[]} 2022-10-25 13:14:58.994+00 2022-10-25 14:02:46.7+00 2022-10-25 14:02:46.692+00 870 870 870 870 REL-002695 matrix Relatório de emissões de CO2 referente ano 2021 e 2022 TOTAL Emissão CO2 ct_34
{"type":"column","categories":"service_order.forecast_finish_date","values":[{"column":"_formula.QDE","rawColumn":"_formula.QDE","summarizer":"formula","axis":0,"isMainValue":true}],"legend":{"enabled":false},"filters":{"showOnlyFirstRecords":false,"showAllRecords":true,"recordsToShow":null},"show_values":{"enabled":true}} 400 3250 {"table":"service_order","relationships":["vehicle"],"type":"table","fields":[{"table":"service_order","column":"forecast_finish_date","type":"DATE","date_config":["day","month","year"],"showAt":null,"showInHours":false,"format":null,"daysEvaluatedColumns":null,"is_full_period":false},{"table":"service_order","column":"name","type":"STRING","showAt":null,"showInHours":false,"format":null,"daysEvaluatedColumns":null},{"table":"_formula","column":"QDE","type":"formula","query":"COUNT(DISTINCT service_order.id) + 0","showAt":null,"showInHours":false,"format":null,"daysEvaluatedColumns":null,"relatedTables":[{"table":"service_order"}]}],"filters":[{"field":"service_order.status","operator":"equal","condition":"AND","value":["in_progress"],"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":1},{"field":"service_order.forecast_finish_date","operator":"more_than","condition":"AND","value":{"daysInPeriod":"1","frequencyInPeriod":"days"},"variableValue":null,"variableValueType":null,"variableValueTranslated":null,"conditionType":"fixed","references":null,"format":null,"type":"DATE","isFixedPeriod":false,"isDatePeriod":true,"isDynamicPeriod":false,"isNotInTable":false,"translated":null,"lineNumber":2},{"field":"service_order.cf_578","operator":"equal","condition":"AND","value":["Rastreador"],"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":3}],"aggregates":[{"table":"service_order","column":"forecast_finish_date","group":true,"sum":false,"avg":false,"max":false,"min":false,"stddev":false,"translated":"Previsão de término","id":"service_order.forecast_finish_date"}],"preview":false,"orderBy":[{"table":"_formula","column":"QDE","isHeaderColumn":true,"desc":true}],"groupBy":[]} 2022-11-16 13:32:49.834+00 2022-11-16 13:32:52.796+00 870 870 REL-003250 table Quantidade de ordens de serviços rastreadores em andamento atrasadas de liberação. QDE. OS RASTREADOR em atraso service_order
{"type":"column","categories":"transaction.vehicle_id","values":[{"column":"transaction.traveled_distance","rawColumn":"transaction.traveled_distance__sum__","axis":0,"summarizer":"sum","isMainValue":true}],"legend":{"enabled":true},"show_values":{"enabled":true},"use_diferent_color":{"enabled":false},"stacked_column":{"enabled":false},"filters":{"showOnlyFirstRecords":false,"showAllRecords":true,"recordsToShow":null}} 433 2692 {"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":"traveled_distance","type":"DECIMAL","summarizers":{"sum":true,"avg":false,"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},{"table":"_formula","column":"QDE. FROTAS","type":"formula","query":"COUNT(DISTINCT vehicle.id)","showAt":{"inner":true,"total":true},"showInHours":false,"format":null,"daysEvaluatedColumns":null,"relatedTables":[{"table":"vehicle"}]}],"filters":[{"field":"transaction.vehicle_id","operator":"not_empty","condition":"AND","value":null,"variableValue":null,"variableValueType":null,"variableValueTranslated":null,"conditionType":"fixed","references":"vehicle","format":null,"type":"INTEGER","isFixedPeriod":false,"isDatePeriod":false,"isDynamicPeriod":false,"translated":null,"lineNumber":6},{"field":"vehicle.motorized","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":7},{"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":8},{"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":9},{"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":10}],"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":"traveled_distance","group":false,"sum":true,"avg":false,"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 12:43:15.205+00 2022-10-25 14:03:58.373+00 2022-10-25 14:03:58.356+00 870 870 870 870 REL-002692 matrix Mostra a distância percorrida por frota no mês atual KM RODADO POR FROTA (VOLVO) transaction
{"type":"column","categories":"ct_34.cf_648","values":[{"column":"ct_34.cf_655","rawColumn":"ct_34.cf_655__avg__","axis":0,"summarizer":"avg","isMainValue":true}],"legend":{"enabled":true},"filters":{"showOnlyFirstRecords":false,"showAllRecords":true,"recordsToShow":null},"show_values":{"enabled":true}} 433 3288 {"table":"ct_34","relationships":[],"type":"matrix","fields":[{"table":"ct_34","column":"cf_648","type":"STRING","showAt":{"inner":true,"total":true},"showInHours":false,"format":null,"daysEvaluatedColumns":null},{"table":"ct_34","column":"cf_649","type":"STRING","showAt":{"inner":true,"total":true},"showInHours":false,"format":null,"daysEvaluatedColumns":null},{"table":"ct_34","column":"cf_655","type":"DECIMAL","summarizers":{"sum":false,"avg":true,"max":false,"min":false},"showAt":{"inner":true,"total":true},"showInHours":false,"format":null,"daysEvaluatedColumns":null},{"table":"ct_34","column":"cf_646","type":"DECIMAL","showAt":{"inner":true,"total":true},"showInHours":false,"format":null,"daysEvaluatedColumns":null}],"filters":[{"field":"ct_34.created_at","operator":"$gte","condition":"AND","value":"2022-11-16T03: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":1},{"field":"ct_34.created_at","operator":"$lte","condition":"AND","value":"2024-01-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":1},{"field":"ct_34.cf_656","operator":"equal","condition":"AND","value":"VOLKSWAGEN","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":2},{"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":3},{"field":"ct_34.cf_648","operator":"equal","condition":"AND","value":"505","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":"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_649","group":true,"sum":null,"avg":null,"max":null,"min":null,"matrix_type":"vertical","translated":"placa","id":"ct_34.cf_649"},{"table":"ct_34","column":"cf_655","group":false,"sum":false,"avg":true,"max":false,"min":false},{"table":"ct_34","column":"cf_646","group":true,"sum":null,"avg":null,"max":null,"min":null,"matrix_type":"horizontal","translated":"mês","id":"ct_34.cf_646"}],"preview":false,"orderBy":[{"table":"ct_34","column":"cf_646","isHeaderColumn":true,"desc":false}],"groupBy":[]} 2022-11-16 18:27:39.962+00 2022-11-16 18:27:40.11+00 870 870 REL-003288 matrix Mostra a média individual frota no ano. MÉDIAS INDIVIDUAL (VOLKSWAGEN) ct_34
{"type":"column","categories":"ct_34.cf_648","values":[{"column":"ct_34.cf_654","rawColumn":"ct_34.cf_654__sum__","summarizer":"sum","axis":0,"isMainValue":true}],"legend":{"enabled":true},"filters":{"showOnlyFirstRecords":false,"showAllRecords":true,"recordsToShow":null},"show_values":{"enabled":true}} 433 3292 {"table":"ct_34","relationships":[],"type":"matrix","fields":[{"table":"ct_34","column":"cf_648","type":"STRING","showAt":{"inner":true,"total":true},"showInHours":false,"format":null,"daysEvaluatedColumns":null},{"table":"ct_34","column":"cf_649","type":"STRING","showAt":{"inner":true,"total":true},"showInHours":false,"format":null,"daysEvaluatedColumns":null},{"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}],"filters":[{"field":"ct_34.created_at","operator":"$gte","condition":"AND","value":"2022-11-16T03: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":1},{"field":"ct_34.created_at","operator":"$lte","condition":"AND","value":"2024-01-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":1},{"field":"ct_34.cf_656","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":2},{"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":3}],"aggregates":[{"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_649","group":true,"sum":null,"avg":null,"max":null,"min":null,"matrix_type":"vertical","translated":"placa","id":"ct_34.cf_649"},{"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"}],"preview":false,"orderBy":[{"table":"ct_34","column":"cf_647","isHeaderColumn":true,"desc":false}],"groupBy":[]} 2022-11-16 18:32:25.144+00 2022-11-16 18:32:25.308+00 870 870 REL-003292 matrix Mostra o total de emissão de CO2 no ano. TOTAL EMISSÃO CO2 ( SCANIA) ct_34
{"type":"column","categories":"ct_34.cf_648","values":[{"column":"ct_34.cf_655","rawColumn":"ct_34.cf_655__avg__","axis":0,"summarizer":"avg","isMainValue":true}],"legend":{"enabled":true},"show_values":{"enabled":true},"use_diferent_color":{"enabled":false},"stacked_column":{"enabled":false},"filters":{"showOnlyFirstRecords":false,"showAllRecords":true,"recordsToShow":null}} 433 2694 {"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":"traveled_distance","type":"DECIMAL","summarizers":{"sum":true,"avg":false,"max":false,"min":false},"showAt":{"inner":true,"total":true},"showInHours":false,"format":null,"daysEvaluatedColumns":null},{"table":"_formula","column":"QDE. FROTAS","type":"formula","query":"COUNT(DISTINCT vehicle.id)","showAt":{"inner":true,"total":true},"showInHours":false,"format":null,"daysEvaluatedColumns":null,"relatedTables":[{"table":"vehicle"}]},{"table":"transaction","column":"vehicle_id","type":"INTEGER","showAt":{"inner":true,"total":true},"showInHours":false,"format":null,"daysEvaluatedColumns":null}],"filters":[{"field":"transaction.vehicle_id","operator":"not_empty","condition":"AND","value":null,"variableValue":null,"variableValueType":null,"variableValueTranslated":null,"conditionType":"fixed","references":"vehicle","format":null,"type":"INTEGER","isFixedPeriod":false,"isDatePeriod":false,"isDynamicPeriod":false,"translated":null,"lineNumber":11},{"field":"vehicle.motorized","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":12},{"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":13},{"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":14},{"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":16}],"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":"traveled_distance","group":false,"sum":true,"avg":false,"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:10:01.175+00 2022-11-16 18:11:23.559+00 870 870 870 REL-002694 matrix Mostra a distância percorrida por frota no mês atual KM RODADO FROTA (VOLVO) transaction
268 3810 {"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_36","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_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":"updated_by_id","type":"INTEGER","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}],"filters":[{"field":"vehicle.status","operator":"equal","condition":"AND","value":["inactive"],"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":1}],"aggregates":[],"preview":false,"orderBy":[],"groupBy":[]} 2022-12-13 17:02:38.22+00 2022-12-13 17:02:38.254+00 870 870 REL-003810 table relatório para verificar veículos INATIVOS RELATÓRIO ANALITICO VEICULOS INATIVOS vehicle