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":"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}} 565 4249 {"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":"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":"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":[]} 2023-02-13 12:13:57.112+00 2023-02-14 16:14:35.319+00 870 870 870 REL-004249 matrix Despesas em geral do ano de 2023 Despesas - Custos totais mensais ano 2023 transaction
{"type":"column","categories":"transaction.vehicle_id","values":[{"column":"transaction.traveled_distance","rawColumn":"transaction.traveled_distance__sum__","axis":0,"summarizer":"sum","isMainValue":true}],"legend":{"enabled":false}} 1 4050 {"table":"transaction","relationships":[],"type":"table","fields":[{"table":"transaction","column":"vehicle_id","type":"INTEGER","showAt":null,"showInHours":false,"format":null,"daysEvaluatedColumns":null,"translated":"Veículo"},{"table":"transaction","column":"date","type":"DATE","showAt":null,"showInHours":false,"format":null,"daysEvaluatedColumns":null,"translated":"Data"},{"table":"transaction","column":"odometer","type":"DECIMAL","showAt":null,"showInHours":false,"format":null,"daysEvaluatedColumns":null,"translated":"Hodômetro"},{"table":"transaction","column":"traveled_distance","type":"DECIMAL","showAt":null,"showInHours":false,"format":null,"daysEvaluatedColumns":null,"translated":"Distância percorrida"},{"table":"transaction","column":"accumulated_utilization","type":"DECIMAL","showAt":null,"showInHours":false,"format":null,"daysEvaluatedColumns":null,"translated":"Utilização acumulada"},{"table":"transaction","column":"type","type":"STRING","showAt":null,"showInHours":false,"format":"list:transactionTypes","daysEvaluatedColumns":null,"translated":"Tipo"},{"table":"transaction","column":"register_type","type":"STRING","showAt":null,"showInHours":false,"format":"list:transactionRegisterTypes","daysEvaluatedColumns":null,"translated":"Tipo de registro"},{"table":"transaction","column":"expense_id","type":"INTEGER","showAt":null,"showInHours":false,"format":null,"daysEvaluatedColumns":null,"translated":"Despesa"},{"table":"transaction","column":"service_order_id","type":"INTEGER","showAt":null,"showInHours":false,"format":null,"daysEvaluatedColumns":null,"translated":"Ordem de serviço"},{"table":"transaction","column":"gate_appointment_id","type":"INTEGER","showAt":null,"showInHours":false,"format":null,"daysEvaluatedColumns":null,"translated":"Controle de portaria"},{"table":"transaction","column":"created_by_id","type":"INTEGER","showAt":null,"showInHours":false,"format":null,"daysEvaluatedColumns":null,"translated":"Usuário que criou"}],"filters":[{"field":"transaction.vehicle_id","operator":"equal","condition":"AND","value":[58],"references":"vehicle","format":null,"type":"INTEGER","variableValue":null,"variableValueType":null,"conditionType":"fixed","isFixedPeriod":false,"isDynamicPeriod":false,"isNotInTable":false,"isDatePeriod":false,"daysInPeriod":null,"frequencyInPeriod":null,"translated":null},{"field":"transaction.odometer","operator":"not_empty","condition":"AND","value":0,"references":null,"format":null,"type":"DECIMAL","variableValue":null,"variableValueType":null,"conditionType":"fixed","isFixedPeriod":false,"isDynamicPeriod":false,"decimals":2,"isDatePeriod":false,"translated":null},{"field":"transaction.date","operator":"dynamic_period","condition":"AND","value":"last_year:this_year","references":null,"format":null,"type":"DATE","variableValue":null,"variableValueType":null,"conditionType":"fixed","isFixedPeriod":false,"isDynamicPeriod":true,"isNotInTable":false,"isDatePeriod":false,"translated":null}],"aggregates":[{"table":"transaction","column":"vehicle_id","group":true,"sum":false,"avg":false,"max":false,"min":false,"translated":"Veículo","id":"transaction.vehicle_id"},{"table":"transaction","column":"traveled_distance","group":false,"sum":true,"avg":false,"max":false,"min":false}],"preview":false,"orderBy":[{"table":"transaction","column":"date","isHeaderColumn":true,"desc":true}],"groupBy":[],"having":[]} 2023-01-06 13:50:02.577+00 2023-01-12 20:19:48.203+00 43 177 43 REL-004050 table linha do tempo do ano anterior e 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":true},"filters":{"showOnlyFirstRecords":false,"showAllRecords":true,"recordsToShow":null},"show_values":{"enabled":true}} 2 4282 {"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},{"table":"transaction","column":"item_description","type":"TEXT","showAt":{"inner":true,"total":true},"showInHours":false,"format":null,"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":"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},{"field":"item.type","operator":"equal","condition":"AND","value":["Outros"],"variableValue":null,"variableValueType":null,"variableValueTranslated":null,"conditionType":"fixed","references":null,"format":"list:itemTypes","type":"STRING","isFixedPeriod":false,"isDatePeriod":false,"isDynamicPeriod":false,"isNotInTable":false,"translated":null,"lineNumber":3}],"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},{"table":"transaction","column":"item_description","group":true,"sum":null,"avg":null,"max":null,"min":null,"matrix_type":"vertical"}],"preview":false,"orderBy":[{"table":"transaction","column":"date","isHeaderColumn":true,"desc":false},{"table":"item","column":"type","isHeaderColumn":true,"desc":false}],"groupBy":[]} 2023-02-14 11:26:23.918+00 2023-02-14 11:26:23.959+00 870 870 REL-004282 matrix Despesas do tipo Outros do ano de 2023 Despesas - Outros 2023 transaction
{"type":"line","categories":"transaction.date","values":[{"column":"_formula.Custo por Km rodado","rawColumn":"_formula.Custo por Km rodado","summarizer":"formula","axis":0,"isMainValue":true}],"legend":{"enabled":false}} 565 4083 {"table":"transaction","relationships":["vehicle"],"type":"matrix","fields":[{"table":"transaction","column":"date","type":"DATE","date_config":["month","year"],"showAt":{"inner":true,"total":true},"format":null,"translated":"Data"},{"table":"_formula","column":"Custo por Km rodado","type":"formula","query":"SUM(transaction.final_value) / SUM(transaction.traveled_distance)","showAt":{"inner":true,"total":true},"format":null},{"table":"transaction","column":"final_value","type":"DECIMAL","summarizers":{"sum":true,"avg":false,"max":false,"min":false},"showAt":{"inner":true,"total":true},"format":"Money","translated":"Valor total"},{"table":"transaction","column":"traveled_distance","type":"DECIMAL","summarizers":{"sum":true,"avg":false,"max":false,"min":false},"showAt":{"inner":true,"total":true},"format":null,"translated":"Distância percorrida"},{"table":"transaction","column":"vehicle_id","type":"INTEGER","showAt":{"inner":true,"total":true},"format":null,"translated":"Veículo"}],"filters":[{"field":"transaction.date","operator":"dynamic_period","condition":"AND","value":"this_year:this_year","references":null,"format":null,"type":"DATE","variableValue":null,"variableValueType":null,"conditionType":"fixed","isFixedPeriod":false,"isDynamicPeriod":true,"isDatePeriod":false,"translated":null},{"field":"transaction.type","operator":"$ne","condition":"AND","value":["revenue"],"references":null,"format":"list:transactionTypes","type":"STRING","variableValue":null,"variableValueType":null,"conditionType":"fixed","isFixedPeriod":false,"isDynamicPeriod":false,"isDatePeriod":false,"translated":null},{"field":"transaction.vehicle_id","operator":"not_empty","condition":"AND","value":null,"references":"vehicle","format":null,"type":"INTEGER","variableValue":null,"variableValueType":null,"conditionType":"fixed","isFixedPeriod":false,"isDynamicPeriod":false,"isDatePeriod":false,"daysInPeriod":null,"frequencyInPeriod":null,"translated":null},{"field":"vehicle.measurement_unit","operator":"equal","condition":"AND","value":["km"],"references":null,"format":"list:unitMeasure","type":"STRING","variableValue":null,"variableValueType":null,"conditionType":"fixed","isFixedPeriod":false,"isDynamicPeriod":false,"isDatePeriod":false,"translated":null},{"field":"transaction.sofit_alert","operator":"equal","condition":"AND","value":"","references":null,"format":null,"type":"TEXT","variableValue":null,"variableValueType":null,"conditionType":"fixed","isFixedPeriod":false,"isDynamicPeriod":false,"isNotInTable":false,"isDatePeriod":false,"daysInPeriod":null,"frequencyInPeriod":null,"translated":null}],"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":"traveled_distance","group":false,"sum":true,"avg":false,"max":false,"min":false},{"table":"transaction","column":"vehicle_id","group":true,"sum":null,"avg":null,"max":null,"min":null,"matrix_type":"vertical","translated":"Veículo","id":"transaction.vehicle_id"}],"preview":false,"orderBy":[{"table":"transaction","column":"date","isHeaderColumn":true,"desc":false}],"groupBy":[],"having":[]} 2023-01-18 11:58:37.219+00 2023-01-18 11:58:37.25+00 276 276 REL-004083 matrix Despesas - Custo por km rodado mensal por veículo ano atual Apenas veículos cuja unidade de medida é KM irão aparecer no relatório Despesas - Custo por km rodado mensal por veículo ano atual teste transaction
{"type":"line","categories":"transaction.date","values":[{"column":"_formula.Custo por Km rodado","rawColumn":"_formula.Custo por Km rodado","summarizer":"formula","axis":0,"isMainValue":true}],"legend":{"enabled":false}} 2 4116 {"table":"transaction","relationships":["vehicle"],"type":"matrix","fields":[{"table":"transaction","column":"date","type":"DATE","date_config":["month","year"],"showAt":{"inner":true,"total":true},"format":null,"translated":"Data"},{"table":"_formula","column":"Custo por Km rodado","type":"formula","query":"SUM(transaction.final_value) / SUM(transaction.traveled_distance)","showAt":{"inner":true,"total":true},"format":null},{"table":"transaction","column":"final_value","type":"DECIMAL","summarizers":{"sum":true,"avg":false,"max":false,"min":false},"showAt":{"inner":true,"total":true},"format":"Money","translated":"Valor total"},{"table":"transaction","column":"traveled_distance","type":"DECIMAL","summarizers":{"sum":true,"avg":false,"max":false,"min":false},"showAt":{"inner":true,"total":true},"format":null,"translated":"Distância percorrida"},{"table":"transaction","column":"vehicle_id","type":"INTEGER","showAt":{"inner":true,"total":true},"format":null,"translated":"Veículo"}],"filters":[{"field":"transaction.date","operator":"dynamic_period","condition":"AND","value":"this_year:this_year","references":null,"format":null,"type":"DATE","variableValue":null,"variableValueType":null,"conditionType":"fixed","isFixedPeriod":false,"isDynamicPeriod":true,"isDatePeriod":false,"translated":null},{"field":"transaction.type","operator":"$ne","condition":"AND","value":["revenue"],"references":null,"format":"list:transactionTypes","type":"STRING","variableValue":null,"variableValueType":null,"conditionType":"fixed","isFixedPeriod":false,"isDynamicPeriod":false,"isDatePeriod":false,"translated":null},{"field":"transaction.vehicle_id","operator":"not_empty","condition":"AND","value":null,"references":"vehicle","format":null,"type":"INTEGER","variableValue":null,"variableValueType":null,"conditionType":"fixed","isFixedPeriod":false,"isDynamicPeriod":false,"isDatePeriod":false,"daysInPeriod":null,"frequencyInPeriod":null,"translated":null},{"field":"vehicle.measurement_unit","operator":"equal","condition":"AND","value":["km"],"references":null,"format":"list:unitMeasure","type":"STRING","variableValue":null,"variableValueType":null,"conditionType":"fixed","isFixedPeriod":false,"isDynamicPeriod":false,"isDatePeriod":false,"translated":null},{"field":"transaction.sofit_alert","operator":"equal","condition":"AND","value":null,"references":null,"format":null,"type":"TEXT","variableValue":null,"variableValueType":null,"conditionType":"fixed","isFixedPeriod":false,"isDynamicPeriod":false,"isNotInTable":false,"isDatePeriod":false,"daysInPeriod":null,"frequencyInPeriod":null,"translated":null}],"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":"traveled_distance","group":false,"sum":true,"avg":false,"max":false,"min":false},{"table":"transaction","column":"vehicle_id","group":true,"sum":null,"avg":null,"max":null,"min":null,"matrix_type":"vertical","translated":"Veículo","id":"transaction.vehicle_id"}],"preview":false,"orderBy":[{"table":"transaction","column":"date","isHeaderColumn":true,"desc":false}],"groupBy":[],"having":[]} 2023-01-18 12:29:43.813+00 2023-01-18 12:29:43.839+00 870 870 REL-004116 matrix Despesas - Custo por km rodado mensal por veículo ano atual Apenas veículos cuja unidade de medida é KM irão aparecer no relatório Custo por km rodado transaction
466 4150 {"table":"ct_67","relationships":[],"type":"table","fields":[{"table":"ct_67","column":"cf_696","type":"STRING","showAt":null,"showInHours":false,"format":null,"daysEvaluatedColumns":null},{"table":"ct_67","column":"cf_697","type":"DATE","showAt":null,"showInHours":false,"format":"Date","daysEvaluatedColumns":null},{"table":"ct_67","column":"cf_699","type":"DECIMAL","showAt":null,"showInHours":false,"format":null,"daysEvaluatedColumns":null},{"table":"ct_67","column":"cf_700","type":"DECIMAL","showAt":null,"showInHours":false,"format":null,"daysEvaluatedColumns":null},{"table":"ct_67","column":"cf_701","type":"DECIMAL","showAt":null,"showInHours":false,"format":null,"daysEvaluatedColumns":null},{"table":"ct_67","column":"created_at","type":"DATE","showAt":null,"showInHours":false,"format":null,"daysEvaluatedColumns":null},{"table":"ct_67","column":"created_by_id","type":"INTEGER","showAt":null,"showInHours":false,"format":null,"daysEvaluatedColumns":null}],"filters":[{"field":"ct_67.cf_697","operator":"dynamic_period","condition":"AND","value":"last_day:last_day","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":1}],"aggregates":[],"preview":false,"orderBy":[],"groupBy":[]} 2023-01-30 12:55:14.899+00 2023-01-30 12:55:14.92+00 870 870 REL-004150 table Relatório de hodômetro atual das frotas ano 2023. Relatório Hodometro atual Frotas ct_67
1 147 {"type":"column","categories":"transaction.vehicle_id","values":[{"column":"transaction.final_value","rawColumn":"transaction.final_value__sum__","summarizer":"sum","axis":0,"isMainValue":true}],"legend":{"enabled":true}} 1 69 {"table":"transaction","relationships":[],"type":"table","fields":[{"table":"transaction","column":"vehicle_id","type":"INTEGER","showAt":null,"format":null},{"table":"transaction","column":"expense_id","type":"INTEGER","showAt":null,"format":null},{"table":"transaction","column":"item_id","type":"INTEGER","showAt":null,"format":null},{"table":"transaction","column":"date","type":"DATE","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_year:this_year","references":null,"format":null,"type":"DATE","isFixedPeriod":false,"isDynamicPeriod":true},{"field":"transaction.expense_id","operator":"not_empty","condition":"AND","value":null,"references":"expense","format":null,"type":"INTEGER","isFixedPeriod":false,"isDynamicPeriod":false}],"aggregates":[{"table":"transaction","column":"vehicle_id","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":"transaction","column":"final_value","isHeaderColumn":true,"desc":false}],"hideDetails":false} 2018-10-26 18:05:06.023+00 2023-02-06 15:14:09.279+00 1 310 1 REL-000069 table Ranking de despesas por veículo 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}} 2 4315 {"table":"transaction","relationships":["item","sub_system","vehicle","expense"],"type":"matrix","fields":[{"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},{"table":"transaction","column":"supplier_id","type":"INTEGER","showAt":{"inner":true,"total":true},"showInHours":false,"format":null,"daysEvaluatedColumns":null},{"table":"transaction","column":"vehicle_id","type":"INTEGER","showAt":{"inner":true,"total":true},"showInHours":false,"format":null,"daysEvaluatedColumns":null},{"table":"transaction","column":"doc_number","type":"STRING","showAt":{"inner":true,"total":true},"showInHours":false,"format":null,"daysEvaluatedColumns":null}],"filters":[{"field":"transaction.date","operator":"dynamic_period","condition":"AND","value":"last_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},{"field":"item.type","operator":"equal","condition":"AND","value":["Outros"],"variableValue":null,"variableValueType":null,"variableValueTranslated":null,"conditionType":"fixed","references":null,"format":"list:itemTypes","type":"STRING","isFixedPeriod":false,"isDatePeriod":false,"isDynamicPeriod":false,"isNotInTable":false,"translated":null,"lineNumber":11},{"field":"transaction.supplier_id","operator":"equal","condition":"AND","value":[2423],"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}],"aggregates":[{"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},{"table":"transaction","column":"supplier_id","group":true,"sum":null,"avg":null,"max":null,"min":null,"matrix_type":"vertical"},{"table":"transaction","column":"vehicle_id","group":true,"sum":null,"avg":null,"max":null,"min":null,"matrix_type":"vertical"},{"table":"transaction","column":"doc_number","group":true,"sum":null,"avg":null,"max":null,"min":null,"matrix_type":"vertical"}],"preview":false,"orderBy":[{"table":"transaction","column":"date","isHeaderColumn":true,"desc":false}],"groupBy":[]} 2023-02-14 19:26:24.378+00 2023-02-14 19:26:24.407+00 870 870 REL-004315 matrix Analise de importação Fatura Rastreadores 2023 Analise de importação Fatura Rastreadores 2023 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}} 2 4381 {"table":"transaction","relationships":["item"],"type":"matrix","fields":[{"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},{"table":"transaction","column":"supplier_id","type":"INTEGER","showAt":{"inner":true,"total":true},"showInHours":false,"format":null,"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":"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},{"field":"item.type","operator":"equal","condition":"AND","value":["Outros"],"variableValue":null,"variableValueType":null,"variableValueTranslated":null,"conditionType":"fixed","references":null,"format":"list:itemTypes","type":"STRING","isFixedPeriod":false,"isDatePeriod":false,"isDynamicPeriod":false,"isNotInTable":false,"translated":null,"lineNumber":3}],"aggregates":[{"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},{"table":"transaction","column":"supplier_id","group":true,"sum":null,"avg":null,"max":null,"min":null,"matrix_type":"vertical"}],"preview":false,"orderBy":[{"table":"transaction","column":"date","isHeaderColumn":true,"desc":false}],"groupBy":[]} 2023-02-15 13:05:17.675+00 2023-02-15 13:05:17.704+00 870 870 REL-004381 matrix Despesas do tipo Outros/Rastreadores do ano de 2023 Despesas - SASCAR 2023 transaction
{"type":"bar","categories":"transaction.supplier_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}} 2 4414 {"table":"transaction","relationships":["item"],"type":"matrix","fields":[{"table":"transaction","column":"date","type":"DATE","date_config":["month","year"],"showAt":{"inner":true,"total":true},"showInHours":false,"format":null,"daysEvaluatedColumns":null,"translated":"Data"},{"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,"translated":"Valor total"},{"table":"transaction","column":"supplier_id","type":"INTEGER","showAt":{"inner":true,"total":true},"showInHours":false,"format":null,"daysEvaluatedColumns":null,"translated":"Fornecedor"}],"filters":[{"field":"transaction.type","operator":"equal","condition":"AND","value":["expense"],"references":null,"format":"list:transactionTypes","type":"STRING","variableValue":null,"variableValueType":null,"conditionType":"fixed","isDatePeriod":false,"translated":null},{"field":"transaction.date","operator":"dynamic_period","condition":"AND","value":"this_year:this_year","references":null,"format":null,"type":"DATE","variableValue":null,"variableValueType":null,"conditionType":"fixed","isFixedPeriod":false,"isDynamicPeriod":true,"isNotInTable":false,"isDatePeriod":false,"translated":null},{"field":"item.type","operator":"equal","condition":"AND","value":["Outros"],"references":null,"format":"list:itemTypes","type":"STRING","variableValue":null,"variableValueType":null,"conditionType":"fixed","isFixedPeriod":false,"isDynamicPeriod":false,"isNotInTable":false,"isDatePeriod":false,"translated":null},{"field":"transaction.supplier_id","operator":"$ne","condition":"AND","value":[5172],"references":"supplier","format":null,"type":"INTEGER","variableValue":null,"variableValueType":null,"conditionType":"fixed","isFixedPeriod":false,"isDynamicPeriod":false,"isNotInTable":false,"isDatePeriod":false,"daysInPeriod":null,"frequencyInPeriod":null,"translated":null}],"aggregates":[{"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},{"table":"transaction","column":"supplier_id","group":true,"sum":null,"avg":null,"max":null,"min":null,"matrix_type":"vertical"}],"preview":false,"orderBy":[{"table":"transaction","column":"date","isHeaderColumn":true,"desc":false}],"groupBy":[],"having":[]} 2023-02-15 13:57:55.503+00 2023-07-11 13:22:20.469+00 870 276 870 REL-004414 matrix Despesas do tipo Outros/Rastreadores do ano de 2023 Despesas - Rastreadores 2023 transaction