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_649","values":[{"column":"ct_34.cf_654","rawColumn":"ct_34.cf_654__sum__","axis":0,"summarizer":"sum","isMainValue":true}],"legend":{"enabled":true},"filters":{"showOnlyFirstRecords":false,"showAllRecords":true,"recordsToShow":null},"show_values":{"enabled":true}} 1 1918 {"table":"ct_34","relationships":[],"type":"table","fields":[{"table":"ct_34","column":"cf_649","type":"STRING","showAt":null,"showInHours":false,"format":null,"daysEvaluatedColumns":null},{"table":"ct_34","column":"cf_646","type":"DECIMAL","showAt":null,"showInHours":false,"format":null,"daysEvaluatedColumns":null},{"table":"ct_34","column":"cf_650","type":"STRING","showAt":null,"showInHours":false,"format":null,"daysEvaluatedColumns":null},{"table":"ct_34","column":"cf_651","type":"STRING","showAt":null,"showInHours":false,"format":null,"daysEvaluatedColumns":null},{"table":"ct_34","column":"cf_654","type":"DECIMAL","showAt":null,"showInHours":false,"format":null,"daysEvaluatedColumns":null},{"table":"ct_34","column":"subsidiary_id","type":"INTEGER","showAt":null,"showInHours":false,"format":null,"daysEvaluatedColumns":null},{"table":"ct_34","column":"cf_662","type":"STRING","showAt":null,"showInHours":false,"format":"attachment","daysEvaluatedColumns":null},{"table":"ct_34","column":"id","type":"INTEGER","showAt":null,"showInHours":false,"format":null,"daysEvaluatedColumns":null},{"table":"ct_34","column":"cf_645","type":"STRING","showAt":null,"showInHours":false,"format":null,"daysEvaluatedColumns":null},{"table":"ct_34","column":"cf_658","type":"STRING","showAt":null,"showInHours":false,"format":null,"daysEvaluatedColumns":null},{"table":"ct_34","column":"cf_647","type":"DECIMAL","showAt":null,"showInHours":false,"format":null,"daysEvaluatedColumns":null},{"table":"ct_34","column":"name","type":"STRING","showAt":null,"showInHours":false,"format":null,"daysEvaluatedColumns":null},{"table":"ct_34","column":"cf_653","type":"DECIMAL","showAt":null,"showInHours":false,"format":null,"daysEvaluatedColumns":null},{"table":"ct_34","column":"cf_652","type":"STRING","showAt":null,"showInHours":false,"format":null,"daysEvaluatedColumns":null},{"table":"ct_34","column":"cf_659","type":"STRING","showAt":null,"showInHours":false,"format":null,"daysEvaluatedColumns":null},{"table":"ct_34","column":"cf_648","type":"STRING","showAt":null,"showInHours":false,"format":null,"daysEvaluatedColumns":null},{"table":"ct_34","column":"cf_656","type":"STRING","showAt":null,"showInHours":false,"format":null,"daysEvaluatedColumns":null},{"table":"ct_34","column":"cf_657","type":"STRING","showAt":null,"showInHours":false,"format":null,"daysEvaluatedColumns":null},{"table":"ct_34","column":"created_by_id","type":"INTEGER","showAt":null,"showInHours":false,"format":null,"daysEvaluatedColumns":null},{"table":"ct_34","column":"updated_by_id","type":"INTEGER","showAt":null,"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":9}],"aggregates":[{"table":"ct_34","column":"cf_649","group":true,"sum":false,"avg":false,"max":false,"min":false,"stddev":false,"translated":"placa","id":"ct_34.cf_649"},{"table":"ct_34","column":"cf_654","group":false,"sum":true,"avg":false,"max":false,"min":false,"stddev":false}],"preview":false,"orderBy":[{"table":"ct_34","column":"cf_646","isHeaderColumn":true,"desc":false}],"groupBy":[]} 2022-09-27 12:32:06.532+00 2022-09-27 12:32:07.773+00 376 376 REL-001918 table Medidas Co2 ano 2022 ct_34
1 1646 {"table":"vehicle","relationships":[],"type":"table","fields":[{"table":"vehicle","column":"license_plate","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":"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":"steppes_quantity","type":"INTEGER","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":5}],"aggregates":[],"preview":false,"orderBy":[],"groupBy":[]} 2022-09-21 17:28:11.213+00 2022-09-21 18:00:17.211+00 376 376 376 REL-001646 table Quantidade de estepe vehicle
{"type":"column","categories":"transaction.invoice","values":[{"column":"transaction.final_value","rawColumn":"transaction.final_value__sum__","axis":0,"summarizer":"sum","isMainValue":true}],"legend":{"enabled":false},"filters":{"showOnlyFirstRecords":false,"showAllRecords":true,"recordsToShow":null},"show_values":{"enabled":true}} 235 2260 {"table":"transaction","relationships":[],"type":"table","fields":[{"table":"transaction","column":"invoice","type":"STRING","showAt":null,"showInHours":false,"format":null,"daysEvaluatedColumns":null},{"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":"vehicle_id","type":"INTEGER","showAt":null,"showInHours":false,"format":null,"daysEvaluatedColumns":null},{"table":"transaction","column":"unit_value","type":"DECIMAL","showAt":null,"showInHours":false,"format":"Money","daysEvaluatedColumns":null},{"table":"transaction","column":"final_value","type":"DECIMAL","showAt":null,"showInHours":false,"format":"Money","daysEvaluatedColumns":null}],"filters":[{"field":"transaction.supplier_id","operator":"equal","condition":"AND","value":[1422,1421],"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":2}],"aggregates":[{"table":"transaction","column":"final_value","group":false,"sum":true,"avg":false,"max":false,"min":false,"stddev":false},{"table":"transaction","column":"invoice","group":true,"sum":false,"avg":false,"max":false,"min":false,"stddev":false,"translated":"Fatura","id":"transaction.invoice"}],"preview":false,"orderBy":[{"table":"transaction","column":"date","isHeaderColumn":true,"desc":true}],"groupBy":[]} 2022-09-30 13:54:56.465+00 2022-10-24 19:57:21.597+00 2022-10-24 19:57:21.594+00 870 870 870 870 REL-002260 table Relatório de pedágio Sem Parar por fatura Pedágio Sem Parar por fatura transaction
{"type":"column","categories":"vehicle.cf_34","values":[{"column":"_formula.qtd","rawColumn":"_formula.qtd","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}} 1 2707 {"table":"vehicle","relationships":[],"type":"table","fields":[{"table":"vehicle","column":"cf_34","type":"STRING","showAt":null,"showInHours":false,"format":null,"daysEvaluatedColumns":null},{"table":"_formula","column":"qtd","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}],"filters":[],"aggregates":[{"table":"vehicle","column":"cf_34","group":true,"sum":false,"avg":false,"max":false,"min":false,"stddev":false,"translated":"Propriedade","id":"vehicle.cf_34"}],"preview":false,"orderBy":[{"table":"vehicle","column":"cf_34","isHeaderColumn":true,"desc":true}],"groupBy":[],"hideDetails":true} 2022-10-25 13:48:52.127+00 2022-10-25 13:48:55.359+00 376 376 376 REL-002707 table Quantidade por propriedade vehicle
1 1883 {"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":"sub_30_days:this_day","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":1},{"field":"service_order.type","operator":"equal","condition":"AND","value":["preventive"],"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":"service_order.vehicle_down_days","operator":"$gte","condition":"AND","value":3,"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},{"field":"vehicle.vehicle_group_id","operator":"equal","condition":"AND","value":[248],"variableValue":null,"variableValueType":null,"variableValueTranslated":null,"conditionType":"fixed","references":"vehicle_group","format":null,"type":"INTEGER","isFixedPeriod":false,"isDatePeriod":false,"isDynamicPeriod":false,"isNotInTable":false,"translated":null,"lineNumber":5}],"aggregates":[{"table":"service_order","column":"vehicle_id","group":true,"sum":false,"avg":false,"max":false,"min":false,"translated":"Veículo","id":"service_order.vehicle_id"},{"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":[]} 2022-09-26 19:46:23.895+00 2022-09-26 20:16:42.549+00 111 376 111 REL-001883 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 Cavalo service_order
301 1951 {"table":"checklist_reply","relationships":["checklist"],"type":"table","fields":[{"table":"checklist","column":"vehicle_id","type":"INTEGER","showAt":null,"showInHours":false,"format":null,"daysEvaluatedColumns":null},{"table":"checklist_reply","column":"name","type":"STRING","showAt":null,"showInHours":false,"format":null,"daysEvaluatedColumns":null},{"table":"checklist","column":"fuel_level","type":"STRING","showAt":null,"showInHours":false,"format":null,"daysEvaluatedColumns":null},{"table":"checklist_reply","column":"start_date","type":"DATE","showAt":null,"showInHours":false,"format":null,"daysEvaluatedColumns":null},{"table":"checklist_reply","column":"end_date","type":"DATE","showAt":null,"showInHours":false,"format":null,"daysEvaluatedColumns":null},{"table":"checklist","column":"execution_time","type":"DECIMAL","showAt":null,"showInHours":true,"format":null,"daysEvaluatedColumns":null},{"table":"checklist_reply","column":"checklist_group_item_id","type":"INTEGER","showAt":null,"showInHours":false,"format":null,"daysEvaluatedColumns":null},{"table":"checklist_reply","column":"defective","type":"BOOLEAN","showAt":null,"showInHours":false,"format":null,"daysEvaluatedColumns":null},{"table":"checklist_reply","column":"checklist_group_option_id","type":"INTEGER","showAt":null,"showInHours":false,"format":null,"daysEvaluatedColumns":null},{"table":"checklist","column":"employee_id","type":"INTEGER","showAt":null,"showInHours":false,"format":null,"daysEvaluatedColumns":null},{"table":"checklist","column":"executor_ids","type":"JSON","showAt":null,"showInHours":false,"format":"association:employee","daysEvaluatedColumns":null},{"table":"checklist","column":"service_order_id","type":"INTEGER","showAt":null,"showInHours":false,"format":null,"daysEvaluatedColumns":null},{"table":"checklist_reply","column":"observation","type":"TEXT","showAt":null,"showInHours":false,"format":null,"daysEvaluatedColumns":null},{"table":"checklist","column":"gate_appointment_id","type":"INTEGER","showAt":null,"showInHours":false,"format":null,"daysEvaluatedColumns":null}],"filters":[{"field":"checklist_reply.defective","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":1}],"aggregates":[{"table":"checklist","column":"vehicle_id","group":true,"sum":false,"avg":false,"max":false,"min":false,"stddev":false}],"preview":false,"orderBy":[],"groupBy":[]} 2022-09-27 13:50:05.189+00 2022-09-27 13:50:13.521+00 376 376 REL-001951 table Checklist reprovado checklist_reply
{"type":"column","categories":"vehicle.vehicle_group_id","values":[{"column":"_formula.Anos de uso","rawColumn":"_formula.Anos de uso","axis":0,"summarizer":"formula","isMainValue":true}],"legend":{"enabled":true},"show_values":{"enabled":true},"use_diferent_color":{},"stacked_column":{"enabled":true},"filters":{"showOnlyFirstRecords":false,"showAllRecords":true,"recordsToShow":null}} 1 1680 {"table":"vehicle","relationships":[],"type":"table","fields":[{"table":"vehicle","column":"vehicle_group_id","type":"INTEGER","showAt":null,"showInHours":false,"format":null,"daysEvaluatedColumns":null},{"table":"vehicle","column":"license_plate","type":"STRING","showAt":null,"showInHours":false,"format":null,"daysEvaluatedColumns":null},{"table":"_formula","column":"Anos de uso","type":"formula","query":"2022 - AVG(vehicle.fabrication_year)","showAt":null,"showInHours":false,"format":null,"daysEvaluatedColumns":null,"relatedTables":[{"table":"vehicle"}]},{"table":"vehicle","column":"fabrication_year","type":"INTEGER","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":1}],"aggregates":[{"table":"vehicle","column":"vehicle_group_id","group":true,"sum":false,"avg":false,"max":false,"min":false,"stddev":false,"translated":"Grupo de veículo","id":"vehicle.vehicle_group_id"},{"table":"vehicle","column":"fabrication_year","group":false,"sum":false,"avg":true,"max":false,"min":false,"stddev":false}],"preview":false,"orderBy":[],"groupBy":[]} 2022-09-21 18:51:08.579+00 2022-09-21 18:51:08.593+00 376 376 REL-001680 table Idade média em 2022 vehicle
1 1679 {"table":"vehicle","relationships":[],"type":"table","fields":[{"table":"vehicle","column":"vehicle_group_id","type":"INTEGER","showAt":null,"showInHours":false,"format":null,"daysEvaluatedColumns":null},{"table":"vehicle","column":"license_plate","type":"STRING","showAt":null,"showInHours":false,"format":null,"daysEvaluatedColumns":null},{"table":"vehicle","column":"fabrication_year","type":"INTEGER","showAt":null,"showInHours":false,"format":null,"daysEvaluatedColumns":null},{"table":"_formula","column":"Quantidade","type":"formula","query":"COUNT(DISTINCT vehicle.id)","showAt":null,"showInHours":false,"format":null,"daysEvaluatedColumns":null,"relatedTables":[{"table":"vehicle"}]},{"table":"_formula","column":"Idade média","type":"formula","query":"2022 - AVG(vehicle.fabrication_year)","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":13}],"aggregates":[{"table":"vehicle","column":"vehicle_group_id","group":true,"sum":false,"avg":false,"max":false,"min":false,"stddev":false,"translated":"Grupo de veículo","id":"vehicle.vehicle_group_id"},{"table":"vehicle","column":"fabrication_year","group":false,"sum":false,"avg":false,"max":false,"min":false,"stddev":false}],"preview":false,"orderBy":[{"table":"vehicle","column":"vehicle_group_id","isHeaderColumn":true,"desc":true}],"groupBy":[]} 2022-09-21 18:47:47.853+00 2022-09-21 18:51:36.87+00 2022-09-21 18:51:36.802+00 376 376 376 376 REL-001679 table Para idade média , necessário mudar o ano . 1111 vehicle
{"type":"column","categories":"vehicle.cf_36","values":[{"column":"transaction.final_value","rawColumn":"transaction.final_value__sum__","axis":0,"summarizer":"sum","isMainValue":true}],"legend":{"enabled":false},"filters":{"showOnlyFirstRecords":false,"showAllRecords":true,"recordsToShow":null},"show_values":{"enabled":true}} 235 2262 {"table":"transaction","relationships":["expense","vehicle"],"type":"table","fields":[{"table":"vehicle","column":"cf_36","type":"STRING","showAt":null,"showInHours":false,"format":null,"daysEvaluatedColumns":null},{"table":"vehicle","column":"cf_34","type":"STRING","showAt":null,"showInHours":false,"format":null,"daysEvaluatedColumns":null},{"table":"vehicle","column":"cf_141","type":"STRING","showAt":null,"showInHours":false,"format":null,"daysEvaluatedColumns":null},{"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":1},{"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":2}],"aggregates":[{"table":"transaction","column":"final_value","group":false,"sum":true,"avg":false,"max":false,"min":false,"stddev":false},{"table":"vehicle","column":"cf_36","group":true,"sum":false,"avg":false,"max":false,"min":false,"stddev":false},{"table":"vehicle","column":"cf_34","group":true,"sum":false,"avg":false,"max":false,"min":false,"stddev":false}],"preview":false,"orderBy":[],"groupBy":[]} 2022-09-30 14:11:44.875+00 2022-10-24 20:06:19.812+00 2022-10-24 20:06:19.809+00 870 870 870 870 REL-002262 table Mostra somente o pedágio consumido por placas de frotas na Move Mais por classificação Valor por classificação de frotas Move Mais transaction
1 1747 {"table":"ct_67","relationships":[],"type":"table","fields":[{"table":"ct_67","column":"cf_696","type":"STRING","showAt":null,"showInHours":false,"format":null,"daysEvaluatedColumns":null,"translated":"Veículo "},{"table":"ct_67","column":"cf_697","type":"DATE","showAt":null,"showInHours":false,"format":"Date","daysEvaluatedColumns":null,"translated":"Data "},{"table":"ct_67","column":"cf_700","type":"DECIMAL","showAt":null,"showInHours":false,"format":null,"daysEvaluatedColumns":null,"translated":"Hodômetro Final (km)"},{"table":"ct_67","column":"cf_699","type":"DECIMAL","showAt":null,"showInHours":false,"format":null,"daysEvaluatedColumns":null,"translated":"Hodômetro Inicial (km) "},{"table":"ct_67","column":"cf_701","type":"DECIMAL","showAt":null,"showInHours":false,"format":null,"daysEvaluatedColumns":null,"translated":"Km percorrido"},{"table":"ct_67","column":"created_at","type":"DATE","showAt":null,"showInHours":false,"format":null,"daysEvaluatedColumns":null,"translated":" Data de criação"},{"table":"ct_67","column":"name","type":"STRING","showAt":null,"showInHours":false,"format":null,"daysEvaluatedColumns":null,"translated":"Nome"}],"filters":[{"field":"ct_67.cf_697","operator":"dynamic_period","condition":"AND","value":"sub_7_days:this_day","references":null,"format":null,"type":"DATE","variableValue":null,"variableValueType":null,"conditionType":"fixed","isFixedPeriod":false,"isDynamicPeriod":true,"isNotInTable":false,"isDatePeriod":false,"daysInPeriod":null,"frequencyInPeriod":null,"translated":null}],"aggregates":[],"preview":false,"orderBy":[],"groupBy":[],"having":[]} 2022-09-22 20:01:39.428+00 2022-09-22 20:01:39.451+00 376 376 REL-001747 table Mostra o km importador do rastreador Hodômetro da Sascar U7 ct_67