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_36","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":true},"stacked_column":{"enabled":false},"filters":{"showOnlyFirstRecords":false,"showAllRecords":true,"recordsToShow":null}} 235 2606 {"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":"final_value","type":"DECIMAL","summarizers":{"sum":true,"avg":false,"max":false,"min":false},"showAt":{"inner":true,"total":true},"showInHours":false,"format":"Money","daysEvaluatedColumns":null},{"table":"vehicle","column":"cf_36","type":"STRING","showAt":{"inner":true,"total":true},"showInHours":false,"format":null,"daysEvaluatedColumns":null}],"filters":[{"field":"transaction.supplier_id","operator":"equal","condition":"AND","value":[1422,1421,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":12},{"field":"transaction.date","operator":"dynamic_period","condition":"AND","value":"this_year:this_year","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}],"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":"final_value","group":false,"sum":true,"avg":false,"max":false,"min":false},{"table":"vehicle","column":"cf_36","group":true,"sum":null,"avg":null,"max":null,"min":null,"matrix_type":"vertical","translated":"Classificação","id":"vehicle.cf_36"}],"preview":false,"orderBy":[{"table":"transaction","column":"date","isHeaderColumn":true,"desc":false}],"groupBy":[]} 2022-10-24 16:29:28.272+00 2022-10-24 20:02:53.812+00 2022-10-24 20:02:53.809+00 870 870 870 870 REL-002606 matrix Gastos com pedágios acumulado no ano de 2022 Gastos com Pedágio acumulado transaction
{"type":"column","categories":"transaction.date","values":[{"column":"transaction.final_value","rawColumn":"transaction.final_value__sum__","axis":0,"summarizer":"sum","isMainValue":true}],"legend":{"enabled":true},"filters":{"showOnlyFirstRecords":false,"showAllRecords":true,"recordsToShow":null},"show_values":{"enabled":true}} 235 2605 {"table":"transaction","relationships":[],"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":"final_value","type":"DECIMAL","summarizers":{"sum":true,"avg":false,"max":false,"min":false},"showAt":{"inner":true,"total":true},"showInHours":false,"format":"Money","daysEvaluatedColumns":null},{"table":"transaction","column":"item_id","type":"INTEGER","showAt":{"inner":true,"total":true},"showInHours":false,"format":null,"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":9},{"field":"transaction.date","operator":"dynamic_period","condition":"AND","value":"this_year:this_year","variableValue":null,"variableValueType":null,"variableValueTranslated":null,"conditionType":"fixed","references":null,"format":null,"type":"DATE","isFixedPeriod":false,"isDatePeriod":false,"isDynamicPeriod":true,"isNotInTable":false,"translated":null,"lineNumber":10}],"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":"final_value","group":false,"sum":true,"avg":false,"max":false,"min":false},{"table":"transaction","column":"item_id","group":true,"sum":null,"avg":null,"max":null,"min":null,"matrix_type":"vertical","translated":"Item","id":"transaction.item_id"}],"preview":false,"orderBy":[{"table":"transaction","column":"date","isHeaderColumn":true,"desc":false}],"groupBy":[]} 2022-10-24 16:21:31.998+00 2022-10-24 20:03:10.36+00 2022-10-24 20:03:10.352+00 870 870 870 870 REL-002605 matrix Gastos com pedágios acumulado no ano de 2022 (MOVE MAIS) Gastos com Pedágio acumulado (MOVE MAIS)) transaction
{"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},"show_values":{"enabled":true},"use_diferent_color":{"enabled":true},"stacked_column":{"enabled":false},"filters":{"showOnlyFirstRecords":false,"showAllRecords":true,"recordsToShow":null}} 235 2604 {"table":"transaction","relationships":[],"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":"final_value","type":"DECIMAL","summarizers":{"sum":true,"avg":false,"max":false,"min":false},"showAt":{"inner":true,"total":true},"showInHours":false,"format":"Money","daysEvaluatedColumns":null},{"table":"transaction","column":"item_id","type":"INTEGER","showAt":{"inner":true,"total":true},"showInHours":false,"format":null,"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":7},{"field":"transaction.date","operator":"dynamic_period","condition":"AND","value":"this_year:this_year","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}],"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":"final_value","group":false,"sum":true,"avg":false,"max":false,"min":false},{"table":"transaction","column":"item_id","group":true,"sum":null,"avg":null,"max":null,"min":null,"matrix_type":"vertical","translated":"Item","id":"transaction.item_id"}],"preview":false,"orderBy":[{"table":"transaction","column":"date","isHeaderColumn":true,"desc":false}],"groupBy":[]} 2022-10-24 16:20:41.897+00 2022-10-24 20:03:25.666+00 2022-10-24 20:03:25.661+00 870 870 870 870 REL-002604 matrix Gastos com pedágios acumulado no ano de 2022 Gastos com Pedágio acumulado (SEM PARAR) transaction
{"type":"area","categories":"transaction.date","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 2536 {"table":"transaction","relationships":[],"type":"matrix","fields":[{"table":"transaction","column":"invoice","type":"STRING","showAt":{"inner":true,"total":true},"showInHours":false,"format":null,"daysEvaluatedColumns":null},{"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":"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.supplier_id","operator":"equal","condition":"AND","value":[2290,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":1},{"field":"transaction.date","operator":"dynamic_period","condition":"AND","value":"this_year:this_year","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":2}],"aggregates":[{"table":"transaction","column":"invoice","group":true,"sum":null,"avg":null,"max":null,"min":null,"matrix_type":"vertical","translated":"Fatura","id":"transaction.invoice"},{"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":"final_value","group":false,"sum":true,"avg":false,"max":false,"min":false}],"preview":false,"orderBy":[{"table":"transaction","column":"date","isHeaderColumn":true,"desc":false}],"groupBy":[]} 2022-10-24 13:27:18.846+00 2022-10-24 20:04:36.156+00 2022-10-24 20:04:36.151+00 870 870 870 870 REL-002536 matrix Mostra os gastos por veiculo com pedágio do ano atual Gasto com Pedágio transaction
{"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}} 235 2535 {"table":"transaction","relationships":[],"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":"final_value","type":"DECIMAL","summarizers":{"sum":true,"avg":false,"max":false,"min":false},"showAt":{"inner":true,"total":true},"showInHours":false,"format":"Money","daysEvaluatedColumns":null},{"table":"transaction","column":"item_id","type":"INTEGER","showAt":{"inner":true,"total":true},"showInHours":false,"format":null,"daysEvaluatedColumns":null}],"filters":[{"field":"transaction.supplier_id","operator":"equal","condition":"AND","value":[2290,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":4},{"field":"transaction.date","operator":"dynamic_period","condition":"AND","value":"this_year:this_year","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":5}],"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":"final_value","group":false,"sum":true,"avg":false,"max":false,"min":false},{"table":"transaction","column":"item_id","group":true,"sum":null,"avg":null,"max":null,"min":null,"matrix_type":"vertical","translated":"Item","id":"transaction.item_id"}],"preview":false,"orderBy":[{"table":"transaction","column":"date","isHeaderColumn":true,"desc":false}],"groupBy":[]} 2022-10-24 13:24:27.169+00 2022-10-24 20:05:11.067+00 2022-10-24 20:05:11.004+00 376 870 870 376 REL-002535 matrix Custo com Pedágio no ano atual transaction
{"type":"column","categories":"transaction.date","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":true},"filters":{"showOnlyFirstRecords":false,"showAllRecords":true,"recordsToShow":null}} 235 2534 {"table":"transaction","relationships":[],"type":"matrix","fields":[{"table":"transaction","column":"vehicle_id","type":"INTEGER","showAt":{"inner":true,"total":true},"showInHours":false,"format":null,"daysEvaluatedColumns":null},{"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":"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.supplier_id","operator":"equal","condition":"AND","value":[2290,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":1},{"field":"transaction.date","operator":"dynamic_period","condition":"AND","value":"this_year:this_year","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":2}],"aggregates":[{"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"},{"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":"final_value","group":false,"sum":true,"avg":false,"max":false,"min":false}],"preview":false,"orderBy":[{"table":"transaction","column":"date","isHeaderColumn":true,"desc":false}],"groupBy":[]} 2022-10-24 12:58:40.751+00 2022-10-24 20:05:31.851+00 2022-10-24 20:05:31.848+00 376 870 870 376 REL-002534 matrix Mostra os gastos por veiculo com pedágio do ano atual Gasto com Pedágio no mês atual transaction
{"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 2263 {"table":"transaction","relationships":["vehicle"],"type":"table","fields":[{"table":"vehicle","column":"cf_36","type":"STRING","showAt":null,"showInHours":false,"format":null,"daysEvaluatedColumns":null},{"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":1}],"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}],"preview":false,"orderBy":[{"table":"transaction","column":"date","isHeaderColumn":true,"desc":true}],"groupBy":[]} 2022-09-30 14:13:08.619+00 2022-10-24 20:05:56.413+00 2022-10-24 20:05:56.28+00 870 870 870 870 REL-002263 table Relatório de pedágio Sem Parar por classificação Pedágio Sem Parar por classificação transaction
{"type":"column","categories":"transaction.vehicle_id","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 1555 {"table":"transaction","relationships":[],"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":"vehicle_id","type":"INTEGER","showAt":null,"showInHours":false,"format":null,"daysEvaluatedColumns":null},{"table":"transaction","column":"name","type":"STRING","showAt":null,"showInHours":false,"format":null,"daysEvaluatedColumns":null},{"table":"transaction","column":"supplier_id","type":"INTEGER","showAt":null,"showInHours":false,"format":null,"daysEvaluatedColumns":null},{"table":"transaction","column":"item_description","type":"TEXT","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},{"table":"transaction","column":"observation","type":"TEXT","showAt":null,"showInHours":false,"format":null,"daysEvaluatedColumns":null}],"filters":[{"field":"transaction.date","operator":"dynamic_period","condition":"AND","value":"this_year:this_year","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":5},{"field":"transaction.item_id","operator":"equal","condition":"AND","value":[1683],"variableValue":null,"variableValueType":null,"variableValueTranslated":null,"conditionType":"fixed","references":"item","format":null,"type":"INTEGER","isFixedPeriod":false,"isDatePeriod":false,"isDynamicPeriod":false,"isNotInTable":false,"translated":null,"lineNumber":6}],"aggregates":[{"table":"transaction","column":"date","group":true,"sum":false,"avg":false,"max":false,"min":false,"stddev":false},{"table":"transaction","column":"final_value","group":false,"sum":true,"avg":false,"max":false,"min":false,"stddev":false}],"preview":false,"orderBy":[],"groupBy":[]} 2022-09-20 20:23:28.15+00 2022-10-24 20:08:50.306+00 2022-10-24 20:08:50.303+00 514 870 870 514 REL-001555 table Despesas - Pedágios Move Mais - Ano atual transaction
{"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 3248 {"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.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":2}],"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:27:57.483+00 2022-11-16 13:27:57.494+00 870 870 REL-003248 table Relatório de previsão de ordens de serviços de rastreadores em andamento. Previsão OS RASTREADOR em Andamento service_order
{"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 3286 {"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":20},{"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":20},{"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":21},{"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":22}],"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:24:37.364+00 2022-11-16 18:24:37.377+00 870 870 REL-003286 matrix Mostra o total de emissão de CO2 no ano. TOTAL EMISSÃO CO2 ( VOLKSWAGEN ) ct_34