| | | | | 1 | 1032 | {"table":"employee","relationships":["user"],"type":"table","fields":[{"table":"employee","column":"name","type":"STRING","showAt":null,"showInHours":false,"format":null,"daysEvaluatedColumns":null},{"table":"employee","column":"user_id","type":"INTEGER","showAt":null,"showInHours":false,"format":null,"daysEvaluatedColumns":null},{"table":"user","column":"name","type":"STRING","showAt":null,"showInHours":false,"format":null,"daysEvaluatedColumns":null},{"table":"user","column":"user_name","type":"STRING","showAt":null,"showInHours":false,"format":null,"daysEvaluatedColumns":null}],"filters":[{"field":"employee.user_id","operator":"empty","condition":"AND","value":null,"variableValue":null,"variableValueType":null,"variableValueTranslated":null,"conditionType":"fixed","references":"user","format":null,"type":"INTEGER","isFixedPeriod":false,"isDatePeriod":false,"isDynamicPeriod":false,"isNotInTable":false,"translated":null,"lineNumber":2}],"aggregates":[],"preview":false,"orderBy":[{"table":"employee","column":"name","isHeaderColumn":true,"desc":false}],"groupBy":[]} | 2022-09-01 20:50:40.477+00 | 2022-09-01 20:50:40.507+00 | | 514 | | | 514 | REL-001032 | table | | Usuários sem logins | employee |
| | | | | 268 | 3043 | {"table":"vehicle","relationships":["group","modelversion","cost_center","model"],"type":"table","fields":[{"table":"vehicle","column":"license_plate","type":"STRING","showAt":null,"showInHours":false,"format":null,"daysEvaluatedColumns":null},{"table":"vehicle","column":"cf_611","type":"STRING","showAt":null,"showInHours":false,"format":null,"daysEvaluatedColumns":null},{"table":"vehicle","column":"cf_34","type":"STRING","showAt":null,"showInHours":false,"format":null,"daysEvaluatedColumns":null},{"table":"vehicle","column":"cf_379","type":"STRING","showAt":null,"showInHours":false,"format":null,"daysEvaluatedColumns":null},{"table":"vehicle","column":"cf_734","type":"STRING","showAt":null,"showInHours":false,"format":null,"daysEvaluatedColumns":null},{"table":"vehicle","column":"cf_308","type":"STRING","showAt":null,"showInHours":false,"format":null,"daysEvaluatedColumns":null},{"table":"vehicle","column":"cf_35","type":"STRING","showAt":null,"showInHours":false,"format":null,"daysEvaluatedColumns":null},{"table":"vehicle","column":"cf_142","type":"STRING","showAt":null,"showInHours":false,"format":null,"daysEvaluatedColumns":null},{"table":"vehicle","column":"cf_141","type":"STRING","showAt":null,"showInHours":false,"format":null,"daysEvaluatedColumns":null},{"table":"vehicle","column":"fabrication_year","type":"INTEGER","showAt":null,"showInHours":false,"format":null,"daysEvaluatedColumns":null},{"table":"vehicle","column":"model_year","type":"INTEGER","showAt":null,"showInHours":false,"format":null,"daysEvaluatedColumns":null},{"table":"vehicle","column":"cf_36","type":"STRING","showAt":null,"showInHours":false,"format":null,"daysEvaluatedColumns":null},{"table":"vehicle","column":"renavam","type":"STRING","showAt":null,"showInHours":false,"format":null,"daysEvaluatedColumns":null},{"table":"vehicle","column":"chassis_number","type":"STRING","showAt":null,"showInHours":false,"format":null,"daysEvaluatedColumns":null},{"table":"vehicle","column":"axis_number","type":"STRING","showAt":null,"showInHours":false,"format":null,"daysEvaluatedColumns":null},{"table":"vehicle","column":"vehicle_group_id","type":"INTEGER","showAt":null,"showInHours":false,"format":null,"daysEvaluatedColumns":null},{"table":"vehicle","column":"subsidiary_id","type":"INTEGER","showAt":null,"showInHours":false,"format":null,"daysEvaluatedColumns":null},{"table":"vehicle","column":"cost_center_id","type":"INTEGER","showAt":null,"showInHours":false,"format":null,"daysEvaluatedColumns":null},{"table":"vehicle","column":"cf_663","type":"STRING","showAt":null,"showInHours":false,"format":null,"daysEvaluatedColumns":null},{"table":"vehicle","column":"cf_612","type":"TEXT","showAt":null,"showInHours":false,"format":null,"daysEvaluatedColumns":null},{"table":"vehicle","column":"created_by_id","type":"INTEGER","showAt":null,"showInHours":false,"format":null,"daysEvaluatedColumns":null},{"table":"vehicle","column":"created_at","type":"DATE","showAt":null,"showInHours":false,"format":null,"daysEvaluatedColumns":null}],"filters":[{"field":"vehicle.status","operator":"equal","condition":"AND","value":["active"],"variableValue":null,"variableValueType":null,"variableValueTranslated":null,"conditionType":"fixed","references":null,"format":"list:vehicleStatus","type":"STRING","isFixedPeriod":false,"isDatePeriod":false,"isDynamicPeriod":false,"isNotInTable":false,"translated":null,"lineNumber":1}],"aggregates":[],"preview":false,"orderBy":[],"groupBy":[]} | 2022-11-01 12:59:23.799+00 | 2022-11-01 12:59:23.831+00 | | 870 | | | 870 | REL-003043 | table | relatório para verificar veículos e semirreboques ativos | RELATÓRIO ANALITICO VEICULOS v1 | vehicle |
| | | | | 1 | 392 | {"table":"vehicle","relationships":["employee","subsidiary","group","model"],"type":"table","fields":[{"table":"vehicle","column":"motorized","type":"BOOLEAN","showAt":null,"showInHours":false,"format":null,"daysEvaluatedColumns":null},{"table":"vehicle","column":"name","type":"STRING","showAt":null,"showInHours":false,"format":null,"daysEvaluatedColumns":null},{"table":"vehicle","column":"license_plate","type":"STRING","showAt":null,"showInHours":false,"format":null,"daysEvaluatedColumns":null},{"table":"model","column":"vehicle_brand_id","type":"INTEGER","showAt":null,"showInHours":false,"format":null,"daysEvaluatedColumns":null},{"table":"vehicle","column":"vehicle_model_id","type":"INTEGER","showAt":null,"showInHours":false,"format":null,"daysEvaluatedColumns":null},{"table":"vehicle","column":"vehicle_model_version_id","type":"INTEGER","showAt":null,"showInHours":false,"format":null,"daysEvaluatedColumns":null},{"table":"vehicle","column":"chassis_number","type":"STRING","showAt":null,"showInHours":false,"format":null,"daysEvaluatedColumns":null},{"table":"vehicle","column":"renavam","type":"STRING","showAt":null,"showInHours":false,"format":null,"daysEvaluatedColumns":null},{"table":"_formula","column":"Quantidade","type":"formula","query":"COUNT(vehicle.id)","showAt":null,"showInHours":false,"format":null,"daysEvaluatedColumns":null}],"filters":[{"field":"vehicle.status","operator":"equal","condition":"AND","value":["active"],"variableValue":null,"variableValueType":null,"variableValueTranslated":null,"conditionType":"fixed","references":null,"format":"list:vehicleStatus","type":"STRING","isDatePeriod":false,"translated":null,"lineNumber":1}],"aggregates":[],"preview":false,"orderBy":[],"groupBy":[]} | 2022-08-05 19:07:35.879+00 | 2022-08-05 19:08:22.822+00 | | 77 | 77 | | 77 | REL-000392 | table | Mostra o cadastro os veículos ativos | Veiculos - cadastro | vehicle |
| | | | {"type":"column","categories":"deduct.employee_id","values":[{"column":"deduct.total_value","rawColumn":"deduct.total_value__sum__","axis":0,"summarizer":"sum","isMainValue":true}],"legend":{"enabled":true},"show_values":{"enabled":true},"use_diferent_color":{},"stacked_column":{"enabled":false},"filters":{"showOnlyFirstRecords":false,"showAllRecords":true,"recordsToShow":null}} | 2 | 2976 | {"table":"deduct","relationships":[],"type":"table","fields":[{"table":"deduct","column":"employee_id","type":"INTEGER","showAt":null,"showInHours":false,"format":null,"daysEvaluatedColumns":null},{"table":"deduct","column":"start_date","type":"DATE","showAt":null,"showInHours":false,"format":null,"daysEvaluatedColumns":null},{"table":"deduct","column":"subsidiary_id","type":"INTEGER","showAt":null,"showInHours":false,"format":null,"daysEvaluatedColumns":null},{"table":"deduct","column":"observation","type":"TEXT","showAt":null,"showInHours":false,"format":null,"daysEvaluatedColumns":null},{"table":"deduct","column":"total_value","type":"DECIMAL","showAt":null,"showInHours":false,"format":"Money","daysEvaluatedColumns":null},{"table":"deduct","column":"parcels_number","type":"INTEGER","showAt":null,"showInHours":false,"format":null,"daysEvaluatedColumns":null},{"table":"deduct","column":"parcels_created","type":"BOOLEAN","showAt":null,"showInHours":false,"format":null,"daysEvaluatedColumns":null},{"table":"deduct","column":"name","type":"STRING","showAt":null,"showInHours":false,"format":null,"daysEvaluatedColumns":null},{"table":"deduct","column":"created_at","type":"DATE","showAt":null,"showInHours":false,"format":null,"daysEvaluatedColumns":null},{"table":"deduct","column":"vehicle_casualty_id","type":"INTEGER","showAt":null,"showInHours":false,"format":null,"daysEvaluatedColumns":null},{"table":"deduct","column":"fine_id","type":"INTEGER","showAt":null,"showInHours":false,"format":null,"daysEvaluatedColumns":null},{"table":"deduct","column":"created_by_id","type":"INTEGER","showAt":null,"showInHours":false,"format":null,"daysEvaluatedColumns":null},{"table":"deduct","column":"updated_by_id","type":"INTEGER","showAt":null,"showInHours":false,"format":null,"daysEvaluatedColumns":null}],"filters":[],"aggregates":[{"table":"deduct","column":"employee_id","group":true,"sum":false,"avg":false,"max":false,"min":false,"stddev":false,"translated":"Colaborador","id":"deduct.employee_id"},{"table":"deduct","column":"total_value","group":false,"sum":true,"avg":false,"max":false,"min":false,"stddev":false}],"preview":false,"orderBy":[],"groupBy":[]} | 2022-10-27 14:13:46.738+00 | 2022-10-27 14:13:46.787+00 | | 376 | | | 376 | REL-002976 | table | Mostra os valores que foram descontados do colaborador | Desconto em folha | deduct |
| | | | {"type":"column","categories":"ct_1.cf_842","values":[{"column":"ct_1.cf_841","rawColumn":"ct_1.cf_841__sum__","axis":0,"summarizer":"sum","isMainValue":true}],"legend":{"enabled":true},"show_values":{"enabled":true},"use_diferent_color":{"enabled":false},"stacked_column":{"enabled":true},"filters":{"showOnlyFirstRecords":false,"showAllRecords":true,"recordsToShow":null}} | 4 | 3009 | {"table":"ct_1","relationships":[],"type":"table","fields":[{"table":"ct_1","column":"cf_842","type":"STRING","showAt":null,"showInHours":false,"format":null,"daysEvaluatedColumns":null},{"table":"ct_1","column":"cf_835","type":"STRING","showAt":null,"showInHours":false,"format":null,"daysEvaluatedColumns":null},{"table":"ct_1","column":"cf_836","type":"STRING","showAt":null,"showInHours":false,"format":null,"daysEvaluatedColumns":null},{"table":"ct_1","column":"cf_107","type":"DATE","showAt":null,"showInHours":false,"format":"Date","daysEvaluatedColumns":null},{"table":"ct_1","column":"cf_837","type":"STRING","showAt":null,"showInHours":false,"format":null,"daysEvaluatedColumns":null},{"table":"ct_1","column":"cf_838","type":"STRING","showAt":null,"showInHours":false,"format":null,"daysEvaluatedColumns":null},{"table":"ct_1","column":"cf_839","type":"STRING","showAt":null,"showInHours":false,"format":null,"daysEvaluatedColumns":null},{"table":"ct_1","column":"cf_840","type":"TEXT","showAt":null,"showInHours":false,"format":null,"daysEvaluatedColumns":null},{"table":"ct_1","column":"cf_841","type":"DECIMAL","showAt":null,"showInHours":false,"format":"Money","daysEvaluatedColumns":null},{"table":"ct_1","column":"cf_843","type":"DATE","showAt":null,"showInHours":false,"format":"Date","daysEvaluatedColumns":null},{"table":"ct_1","column":"cf_844","type":"DATE","showAt":null,"showInHours":false,"format":"Date","daysEvaluatedColumns":null},{"table":"ct_1","column":"created_by_id","type":"INTEGER","showAt":null,"showInHours":false,"format":null,"daysEvaluatedColumns":null},{"table":"ct_1","column":"updated_by_id","type":"INTEGER","showAt":null,"showInHours":false,"format":null,"daysEvaluatedColumns":null}],"filters":[],"aggregates":[{"table":"ct_1","column":"cf_842","group":true,"sum":false,"avg":false,"max":false,"min":false,"stddev":false,"translated":"Motorista","id":"ct_1.cf_842"},{"table":"ct_1","column":"cf_841","group":false,"sum":true,"avg":false,"max":false,"min":false,"stddev":false}],"preview":false,"orderBy":[{"table":"ct_1","column":"cf_107","isHeaderColumn":true,"desc":true}],"groupBy":[]} | 2022-10-27 19:37:22.377+00 | 2022-10-27 19:38:17.042+00 | | 376 | 376 | | 376 | REL-003009 | table | Mostra os valores descontados do motoristas de infrações geradas. | Multas descontada pelo RH | ct_1 |
| | 1 | 107 | {"type":"column","categories":"transaction.supplier_id","values":[{"column":"transaction.final_value","rawColumn":"transaction.final_value__sum__","summarizer":"sum","axis":0,"isMainValue":true}],"legend":{"enabled":true}} | 1 | 23 | {"table":"transaction","relationships":[],"type":"table","fields":[{"table":"transaction","column":"supplier_id","type":"INTEGER","showAt":null,"format":null},{"table":"transaction","column":"doc_number","type":"STRING","showAt":null,"format":null},{"table":"transaction","column":"vehicle_id","type":"INTEGER","showAt":null,"format":null},{"table":"transaction","column":"service_order_id","type":"INTEGER","showAt":null,"format":null},{"table":"transaction","column":"date","type":"DATE","showAt":null,"format":null},{"table":"transaction","column":"item_id","type":"INTEGER","showAt":null,"format":null},{"table":"transaction","column":"final_value","type":"DECIMAL","showAt":null,"format":"Money"}],"filters":[{"field":"transaction.date","operator":"dynamic_period","condition":"AND","value":"this_month:this_month","references":null,"format":null,"type":"DATE","isFixedPeriod":false,"isDynamicPeriod":true},{"field":"transaction.service_order_id","operator":"not_empty","condition":"AND","value":null,"references":"service_order","format":null,"type":"INTEGER","isFixedPeriod":false,"isDynamicPeriod":false}],"aggregates":[{"table":"transaction","column":"final_value","group":false,"sum":true,"avg":false,"max":false,"min":false},{"table":"transaction","column":"supplier_id","group":true,"sum":false,"avg":false,"max":false,"min":false}],"preview":false,"orderBy":[{"table":"transaction","column":"date","isHeaderColumn":true,"desc":true}],"hideDetails":false} | 2016-07-04 18:06:10.493+00 | 2022-08-05 19:33:35.575+00 | | | 77 | | | REL-000023 | table | | Ordens de serviço - Custos por fornecedor no mês atual | transaction |
| | | | | 2 | 1033 | {"table":"tire","relationships":[],"type":"table","fields":[{"table":"tire","column":"name","type":"STRING","showAt":null,"showInHours":false,"format":null,"daysEvaluatedColumns":null},{"table":"tire","column":"tire_brand_id","type":"INTEGER","showAt":null,"showInHours":false,"format":null,"daysEvaluatedColumns":null},{"table":"tire","column":"tire_dimension_id","type":"INTEGER","showAt":null,"showInHours":false,"format":null,"daysEvaluatedColumns":null},{"table":"tire","column":"structure","type":"STRING","showAt":null,"showInHours":false,"format":"list:tireStructures","daysEvaluatedColumns":null},{"table":"tire","column":"status","type":"STRING","showAt":null,"showInHours":false,"format":"list:tireStatus","daysEvaluatedColumns":null},{"table":"tire","column":"subsidiary_id","type":"INTEGER","showAt":null,"showInHours":false,"format":null,"daysEvaluatedColumns":null},{"table":"tire","column":"current_life","type":"INTEGER","showAt":null,"showInHours":false,"format":null,"daysEvaluatedColumns":null},{"table":"tire","column":"tire_drawing_id","type":"INTEGER","showAt":null,"showInHours":false,"format":null,"daysEvaluatedColumns":null},{"table":"tire","column":"start_control_date","type":"DATE","showAt":null,"showInHours":false,"format":null,"daysEvaluatedColumns":null},{"table":"tire","column":"initial_cost","type":"DECIMAL","showAt":null,"showInHours":false,"format":null,"daysEvaluatedColumns":null},{"table":"tire","column":"supplier_id","type":"INTEGER","showAt":null,"showInHours":false,"format":null,"daysEvaluatedColumns":null},{"table":"tire","column":"start_control_use","type":"DECIMAL","showAt":null,"showInHours":false,"format":null,"daysEvaluatedColumns":null},{"table":"tire","column":"dot","type":"STRING","showAt":null,"showInHours":false,"format":null,"daysEvaluatedColumns":null}],"filters":[{"field":"tire.created_at","operator":"$gte","condition":"AND","value":"2022-09-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":1},{"field":"tire.created_at","operator":"$lte","condition":"AND","value":"2022-09-02T02: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":"tire.created_by_id","operator":"equal","condition":"AND","value":[177],"variableValue":null,"variableValueType":null,"variableValueTranslated":null,"conditionType":"fixed","references":"user","format":null,"type":"INTEGER","isFixedPeriod":false,"isDatePeriod":false,"isDynamicPeriod":false,"isNotInTable":false,"translated":null,"lineNumber":2}],"aggregates":[],"preview":false,"orderBy":[],"groupBy":[]} | 2022-09-01 21:47:55.985+00 | 2022-09-01 21:47:56.006+00 | | 177 | | | 177 | REL-001033 | table | | Pneus cadastrados - Filial Corderópolis | tire |
| | | | {"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},"filters":{"showOnlyFirstRecords":false,"showAllRecords":true,"recordsToShow":null},"show_values":{"enabled":true}} | 433 | 2699 | {"table":"ct_34","relationships":[],"type":"matrix","fields":[{"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},{"table":"ct_34","column":"cf_648","type":"STRING","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}],"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":11},{"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":12},{"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":13}],"aggregates":[{"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","translated":"ano","id":"ct_34.cf_647"},{"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_658","group":true,"sum":null,"avg":null,"max":null,"min":null,"matrix_type":"vertical","translated":"propriedade","id":"ct_34.cf_658"}],"preview":false,"orderBy":[{"table":"ct_34","column":"cf_647","isHeaderColumn":true,"desc":false}],"groupBy":[]} | 2022-10-25 13:37:42.031+00 | 2022-10-25 13:37:42.043+00 | | 870 | | | 870 | REL-002699 | matrix | Relatório de emissões de CO2 referente ano 2022 | TOTAL Emissão CO2 (VOLKSWAGEN) | ct_34 |
| | 1 | 59 | {"type":"column","categories":"item.type","values":[{"column":"transaction.final_value","rawColumn":"transaction.final_value__sum__","summarizer":"sum","axis":0,"isMainValue":true}],"legend":{"enabled":true}} | 1 | 21 | {"table":"transaction","relationships":["item","vehicle"],"type":"table","fields":[{"table":"item","column":"type","type":"STRING","showAt":null,"format":"list:itemTypes"},{"table":"transaction","column":"expense_id","type":"INTEGER","showAt":null,"format":null},{"table":"vehicle","column":"name","type":"STRING","showAt":null,"format":null},{"table":"transaction","column":"date","type":"DATE","showAt":null,"format":null},{"table":"item","column":"name","type":"STRING","showAt":null,"format":null},{"table":"transaction","column":"final_value","type":"DECIMAL","showAt":null,"format":"Money"}],"filters":[{"field":"transaction.type","operator":"equal","condition":"AND","value":["expense"],"references":null,"format":"list:transactionTypes","type":"STRING"}],"aggregates":[{"table":"item","column":"type","group":true,"sum":false,"avg":false,"max":false,"min":false},{"table":"transaction","column":"final_value","group":false,"sum":true,"avg":false,"max":false,"min":false}],"preview":false,"orderBy":[{"table":"item","column":"type","isHeaderColumn":false,"desc":false},{"table":"transaction","column":"date","isHeaderColumn":true,"desc":true}],"hideDetails":false} | 2016-06-29 21:23:34.06+00 | 2022-09-27 13:44:22.276+00 | | | 376 | | | REL-000021 | table | | Despesas - Custos totais por tipo de item | transaction |
| | | | {"type":"bar","categories":"vehicle.cf_36","values":[{"column":"_formula.QDE. TIPO","rawColumn":"_formula.QDE. TIPO","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}} | 268 | 1435 | {"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}],"filters":[],"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"}],"preview":false,"orderBy":[{"table":"vehicle","column":"cf_36","isHeaderColumn":true,"desc":false}],"groupBy":[]} | 2022-09-18 15:03:21.578+00 | 2022-09-21 11:39:06.31+00 | 2022-09-21 11:39:06.304+00 | 870 | 870 | 870 | 870 | REL-001435 | matrix | Quantidade de veículos por tipo | QDE POR TIPO | vehicle |