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":"vehicle.cf_141","values":[{"column":"transaction.final_value","rawColumn":"transaction.final_value__sum__","axis":0,"summarizer":"sum","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}} 235 2258 {"table":"transaction","relationships":["expense"],"type":"table","fields":[{"table":"transaction","column":"date","type":"DATE","date_config":["month","year"],"showAt":null,"showInHours":false,"format":null,"daysEvaluatedColumns":null,"is_full_period":false},{"table":"transaction","column":"invoice","type":"STRING","showAt":null,"showInHours":false,"format":null,"daysEvaluatedColumns":null},{"table":"expense","column":"vehicle_id","type":"INTEGER","showAt":null,"showInHours":false,"format":null,"daysEvaluatedColumns":null},{"table":"transaction","column":"quantity","type":"DECIMAL","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.supplier_id","operator":"equal","condition":"AND","value":[2290],"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":3},{"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,"isNotInTable":false,"translated":null,"lineNumber":4}],"aggregates":[{"table":"transaction","column":"final_value","group":false,"sum":true,"avg":false,"max":false,"min":false,"stddev":false},{"table":"transaction","column":"date","group":true,"sum":false,"avg":false,"max":false,"min":false,"stddev":false}],"preview":false,"orderBy":[],"groupBy":[]} 2022-09-30 13:37:19.515+00 2022-09-30 14:09:52.029+00 870 870 870 REL-002258 table Mostra somente o pedágio consumido por placas de frotas na Move Mais por mês Valor por mês de frotas Move Mais transaction
1 1884 {"table":"service_order","relationships":[],"type":"table","fields":[{"table":"service_order","column":"vehicle_id","type":"INTEGER","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}],"filters":[],"aggregates":[{"table":"service_order","column":"vehicle_id","group":true,"sum":false,"avg":false,"max":false,"min":false,"stddev":false}],"preview":false,"orderBy":[],"groupBy":[]} 2022-09-26 20:18:58.123+00 2022-09-26 20:18:58.224+00 376 376 REL-001884 table não apagar , serve evidência para nosso time Sofit , corrigir a fórmula relatório de teste de formula service_order
{"type":"bar","categories":"vehicle.cf_36","values":[{"column":"_formula.QDE. TIPO","rawColumn":"_formula.QDE. TIPO","summarizer":"formula","axis":0,"isMainValue":true}],"legend":{"enabled":false},"filters":{"showOnlyFirstRecords":false,"showAllRecords":true,"recordsToShow":null},"show_values":{"enabled":true}} 268 5184 {"table":"vehicle","relationships":[],"type":"matrix","fields":[{"table":"_formula","column":"QDE. TIPO","type":"formula","query":"COUNT(DISTINCT vehicle.id)","showAt":{"inner":true,"total":true},"showInHours":false,"format":null,"daysEvaluatedColumns":null,"relatedTables":[{"table":"vehicle"}]},{"table":"vehicle","column":"cf_379","type":"STRING","showAt":{"inner":true,"total":true},"showInHours":false,"format":null,"daysEvaluatedColumns":null},{"table":"vehicle","column":"cf_36","type":"STRING","showAt":{"inner":true,"total":true},"showInHours":false,"format":null,"daysEvaluatedColumns":null},{"table":"vehicle","column":"cf_611","type":"STRING","showAt":{"inner":true,"total":true},"showInHours":false,"format":null,"daysEvaluatedColumns":null},{"table":"vehicle","column":"license_plate","type":"STRING","showAt":{"inner":true,"total":true},"showInHours":false,"format":null,"daysEvaluatedColumns":null},{"table":"vehicle","column":"cf_142","type":"STRING","showAt":{"inner":true,"total":true},"showInHours":false,"format":null,"daysEvaluatedColumns":null},{"table":"vehicle","column":"cf_141","type":"STRING","showAt":{"inner":true,"total":true},"showInHours":false,"format":null,"daysEvaluatedColumns":null},{"table":"vehicle","column":"fabrication_year","type":"INTEGER","showAt":{"inner":true,"total":true},"showInHours":false,"format":null,"daysEvaluatedColumns":null},{"table":"vehicle","column":"model_year","type":"INTEGER","showAt":{"inner":true,"total":true},"showInHours":false,"format":null,"daysEvaluatedColumns":null},{"table":"vehicle","column":"current_odometer","type":"DECIMAL","showAt":{"inner":true,"total":true},"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":5},{"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":6}],"aggregates":[{"table":"vehicle","column":"cf_379","group":true,"sum":null,"avg":null,"max":null,"min":null,"matrix_type":"vertical","translated":"Tipo de Grupo","id":"vehicle.cf_379"},{"table":"vehicle","column":"cf_36","group":true,"sum":null,"avg":null,"max":null,"min":null,"matrix_type":"horizontal","translated":"Classificação","id":"vehicle.cf_36"},{"table":"vehicle","column":"cf_611","group":true,"sum":null,"avg":null,"max":null,"min":null,"matrix_type":"vertical"},{"table":"vehicle","column":"license_plate","group":true,"sum":null,"avg":null,"max":null,"min":null,"matrix_type":"vertical"},{"table":"vehicle","column":"cf_142","group":true,"sum":null,"avg":null,"max":null,"min":null,"matrix_type":"vertical"},{"table":"vehicle","column":"cf_141","group":true,"sum":null,"avg":null,"max":null,"min":null,"matrix_type":"vertical"},{"table":"vehicle","column":"fabrication_year","group":true,"sum":null,"avg":null,"max":null,"min":null,"matrix_type":"vertical"},{"table":"vehicle","column":"model_year","group":true,"sum":null,"avg":null,"max":null,"min":null,"matrix_type":"vertical"},{"table":"vehicle","column":"current_odometer","group":true,"sum":null,"avg":null,"max":null,"min":null,"matrix_type":"vertical"}],"preview":false,"orderBy":[{"table":"vehicle","column":"cf_36","isHeaderColumn":true,"desc":false}],"groupBy":[]} 2023-09-06 15:02:37.331+00 2023-09-06 15:02:37.355+00 1668 1668 REL-005184 matrix Quantidade de veículos por tipo QDE POR TIPOS CAVALOS.hodometro vehicle
{"type":"bar","categories":"vehicle.cf_142","values":[{"column":"transaction.traveled_distance","rawColumn":"transaction.traveled_distance__sum__","axis":0,"summarizer":"sum","isMainValue":true}],"legend":{"enabled":true},"filters":{"showOnlyFirstRecords":false,"showAllRecords":true,"recordsToShow":null},"show_values":{"enabled":true}} 433 2696 {"table":"transaction","relationships":["vehicle"],"type":"matrix","fields":[{"table":"transaction","column":"date","type":"DATE","date_config":["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":"vehicle","column":"cf_142","type":"STRING","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":17},{"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":18},{"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":20},{"field":"transaction.date","operator":"$gte","condition":"AND","value":"2021-01-01T03:00:00.000Z","variableValue":null,"variableValueType":null,"variableValueTranslated":null,"conditionType":"fixed","references":null,"format":null,"type":"DATE","isFixedPeriod":true,"isDatePeriod":false,"isDynamicPeriod":false,"isNotInTable":false,"translated":null,"lineNumber":22},{"field":"transaction.date","operator":"$lte","condition":"AND","value":"2023-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":22}],"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":"vehicle","column":"cf_142","group":true,"sum":null,"avg":null,"max":null,"min":null,"matrix_type":"vertical","translated":"Marca RG LOG","id":"vehicle.cf_142"}],"preview":false,"orderBy":[{"table":"transaction","column":"date","isHeaderColumn":true,"desc":false}],"groupBy":[]} 2022-10-25 13:21:34.273+00 2022-10-25 14:02:26.541+00 2022-10-25 14:02:26.534+00 870 870 870 870 REL-002696 matrix distância percorrida por marca no ano de 2021 e 2022 TOTAL KM RODADO (GERAL) transaction
{"type":"column","categories":"service_order.vehicle_id","values":[{"column":"_formula.Dias parados do veículo","rawColumn":"_formula.Dias parados do veículo","axis":0,"summarizer":"formula","isMainValue":true}],"legend":{"enabled":true},"show_values":{"enabled":true},"use_diferent_color":{"enabled":false},"stacked_column":{"enabled":false},"filters":{"showOnlyFirstRecords":true,"showAllRecords":false,"recordsToShow":10}} 1 1882 {"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":"sub_60_days:this_day","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","preventive"],"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":[]} 2022-09-26 19:35:40.827+00 2022-09-26 19:41:34.766+00 111 111 111 REL-001882 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 U60d - Corretiva/Preventiva service_order
{"type":"bar","categories":"ct_34.cf_656","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}} 268 2086 {"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_646","type":"DECIMAL","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}],"filters":[{"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":1}],"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_646","group":true,"sum":null,"avg":null,"max":null,"min":null,"matrix_type":"horizontal","translated":"mês","id":"ct_34.cf_646"},{"table":"ct_34","column":"cf_654","group":false,"sum":true,"avg":false,"max":false,"min":false}],"preview":false,"orderBy":[{"table":"ct_34","column":"cf_646","isHeaderColumn":true,"desc":false},{"table":"ct_34","column":"cf_656","isHeaderColumn":true,"desc":false}],"groupBy":[]} 2022-09-28 19:15:31.576+00 2022-10-25 12:04:44.111+00 376 870 376 REL-002086 matrix Emissão CO2 ano 2022 ct_34
1 1952 {"table":"vehicle_hitch","relationships":["truck","trailer"],"type":"table","fields":[{"table":"vehicle_hitch","column":"name","type":"STRING","showAt":null,"showInHours":false,"format":null,"daysEvaluatedColumns":null},{"table":"vehicle_hitch","column":"truck_id","type":"INTEGER","showAt":null,"showInHours":false,"format":null,"daysEvaluatedColumns":null},{"table":"vehicle_hitch","column":"trailer_id","type":"INTEGER","showAt":null,"showInHours":false,"format":null,"daysEvaluatedColumns":null},{"table":"vehicle_hitch","column":"start_date","type":"DATE","showAt":null,"showInHours":false,"format":null,"daysEvaluatedColumns":null},{"table":"vehicle_hitch","column":"finish_date","type":"DATE","showAt":null,"showInHours":false,"format":null,"daysEvaluatedColumns":null}],"filters":[],"aggregates":[],"preview":false,"orderBy":[],"groupBy":[]} 2022-09-27 13:55:53.873+00 2022-09-27 13:55:53.885+00 376 376 REL-001952 table mostra o engate do cavalo e da carreta Controle de implemento vehicle_hitch
{"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 2773 {"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":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-10-25 18:46:39.312+00 2022-10-25 18:46:40.046+00 870 870 REL-002773 table Quantidade de ordens de serviços em andamento atrasadas de liberação. QDE. OS em atraso service_order
{"type":"column","categories":"service_order.forecast_finish_date","values":[{"column":"_formula.QDE","rawColumn":"_formula.QDE","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}} 400 2223 {"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":9}],"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-09-29 19:29:26.004+00 2022-09-29 19:54:47.526+00 870 870 870 REL-002223 table Relatório de previsão de ordens de serviços em andamento. Graf. previsao OS em Andamento V2 service_order
{"type":"column","categories":"transaction.date","values":[{"column":"transaction.final_value","rawColumn":"transaction.final_value__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}} 268 2839 {"table":"transaction","relationships":["item"],"type":"matrix","fields":[{"table":"item","column":"type","type":"STRING","showAt":{"inner":true,"total":true},"showInHours":false,"format":"list:itemTypes","daysEvaluatedColumns":null},{"table":"transaction","column":"date","type":"DATE","date_config":["month","year"],"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}],"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":1},{"field":"transaction.date","operator":"$gte","condition":"AND","value":"2022-07-01T03:00:00.000Z","variableValue":null,"variableValueType":null,"variableValueTranslated":null,"conditionType":"fixed","references":null,"format":null,"type":"DATE","isFixedPeriod":true,"isDatePeriod":false,"isDynamicPeriod":false,"isNotInTable":false,"translated":null,"lineNumber":2},{"field":"transaction.date","operator":"$lte","condition":"AND","value":"2022-10-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":2}],"aggregates":[{"table":"item","column":"type","group":true,"sum":null,"avg":null,"max":null,"min":null,"matrix_type":"vertical"},{"table":"transaction","column":"date","group":true,"sum":null,"avg":null,"max":null,"min":null,"matrix_type":"horizontal"},{"table":"transaction","column":"final_value","group":false,"sum":true,"avg":false,"max":false,"min":false}],"preview":false,"orderBy":[{"table":"transaction","column":"date","isHeaderColumn":true,"desc":false},{"table":"item","column":"type","isHeaderColumn":true,"desc":false}],"groupBy":[]} 2022-10-26 10:38:33.149+00 2022-10-26 10:43:46.295+00 870 870 870 REL-002839 matrix Despesas consolidadas últimos 3 meses Despesas - Consolidadas transaction