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},"filters":{"showOnlyFirstRecords":false,"showAllRecords":true,"recordsToShow":null},"show_values":{"enabled":true}} 565 3374 {"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":3},{"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":4}],"aggregates":[{"table":"item","column":"type","group":true,"sum":null,"avg":null,"max":null,"min":null,"matrix_type":"vertical"},{"table":"transaction","column":"date","group":true,"sum":null,"avg":null,"max":null,"min":null,"matrix_type":"horizontal"},{"table":"transaction","column":"final_value","group":false,"sum":true,"avg":false,"max":false,"min":false}],"preview":false,"orderBy":[{"table":"transaction","column":"date","isHeaderColumn":true,"desc":false},{"table":"item","column":"type","isHeaderColumn":true,"desc":false}],"groupBy":[]} 2022-11-21 11:59:28.83+00 2022-11-21 13:14:10.102+00 870 376 870 REL-003374 matrix Despesas em geral do ano de 2022 Despesas - Custos totais mensais ano 2022 transaction
1 112 {"type":"column","categories":"warehouse_item.warehouse_id","values":[{"column":"warehouse_item.on_hand_value","rawColumn":"warehouse_item.on_hand_value__sum__","summarizer":"sum","axis":0,"isMainValue":true}],"legend":{"enabled":true}} 1 30 {"table":"warehouse_item","relationships":[],"type":"table","fields":[{"table":"warehouse_item","column":"warehouse_id","type":"INTEGER","showAt":null,"format":null},{"table":"warehouse_item","column":"item_id","type":"INTEGER","showAt":null,"format":null},{"table":"warehouse_item","column":"on_hand_balance","type":"DECIMAL","showAt":null,"format":null},{"table":"warehouse_item","column":"pr_last_purshase","type":"DECIMAL","showAt":null,"format":null},{"table":"warehouse_item","column":"weighted_average_pr","type":"DECIMAL","showAt":null,"format":null},{"table":"warehouse_item","column":"on_hand_value","type":"DECIMAL","showAt":null,"format":null}],"filters":[],"aggregates":[{"table":"warehouse_item","column":"warehouse_id","group":true,"sum":false,"avg":false,"max":false,"min":false},{"table":"warehouse_item","column":"on_hand_value","group":false,"sum":true,"avg":false,"max":false,"min":false}],"preview":false,"orderBy":[{"table":"warehouse_item","column":"item_id","isHeaderColumn":true,"desc":true}],"hideDetails":true} 2017-10-13 12:04:07.786+00 2023-10-23 11:51:45.273+00 1 276 1 REL-000030 table Saldo dos itens em estoque por depósito Estoque - Saldo dos itens em estoque por depósito warehouse_item
{"type":"column","categories":"ct_34.cf_648","values":[{"column":"ct_34.cf_655","rawColumn":"ct_34.cf_655__avg__","axis":0,"summarizer":"avg","isMainValue":true}],"legend":{"enabled":true},"filters":{"showOnlyFirstRecords":false,"showAllRecords":true,"recordsToShow":null},"show_values":{"enabled":true}} 433 3283 {"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_655","type":"DECIMAL","summarizers":{"sum":false,"avg":true,"max":false,"min":false},"showAt":{"inner":true,"total":true},"showInHours":false,"format":null,"daysEvaluatedColumns":null},{"table":"ct_34","column":"cf_646","type":"DECIMAL","showAt":{"inner":true,"total":true},"showInHours":false,"format":null,"daysEvaluatedColumns":null}],"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":1},{"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":1},{"field":"ct_34.cf_646","operator":"equal","condition":"AND","value":11,"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":2},{"field":"ct_34.cf_656","operator":"equal","condition":"AND","value":"VOLVO","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":3},{"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":4}],"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_655","group":false,"sum":false,"avg":true,"max":false,"min":false},{"table":"ct_34","column":"cf_646","group":true,"sum":null,"avg":null,"max":null,"min":null,"matrix_type":"horizontal"}],"preview":false,"orderBy":[{"table":"ct_34","column":"cf_646","isHeaderColumn":true,"desc":false}],"groupBy":[]} 2022-11-16 18:14:42.302+00 2022-12-07 12:04:43.237+00 870 870 870 REL-003283 matrix Mostra a média referente o mês anterior por frota. MÉDIAS FROTA GERAL (VOLVO) ct_34
{"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}} 565 3744 {"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":"item","column":"sub_system_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":3},{"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":4}],"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":"item","column":"sub_system_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":[]} 2022-12-12 20:48:38.729+00 2022-12-12 20:48:38.759+00 77 77 REL-003744 matrix Despesas em geral ano 2022 Despesas - Custos totais mensal ano 2022 - V2 transaction
{"type":"bar","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":{},"stacked_column":{"enabled":false},"filters":{"showOnlyFirstRecords":false,"showAllRecords":true,"recordsToShow":null}} 235 3642 {"table":"transaction","relationships":["vehicle"],"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":"item_id","type":"INTEGER","showAt":null,"showInHours":false,"format":null,"daysEvaluatedColumns":null},{"table":"transaction","column":"vehicle_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":"transaction","column":"invoice","type":"STRING","showAt":null,"showInHours":false,"format":null,"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],"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":"date","group":true,"sum":false,"avg":false,"max":false,"min":false,"stddev":false,"translated":"Data","id":"transaction.date"},{"table":"transaction","column":"final_value","group":false,"sum":true,"avg":false,"max":false,"min":false,"stddev":false},{"table":"transaction","column":"item_id","group":true,"sum":false,"avg":false,"max":false,"min":false,"stddev":false,"translated":"Item","id":"transaction.item_id"}],"preview":false,"orderBy":[],"groupBy":[],"hideDetails":true} 2022-12-09 15:27:04.848+00 2022-12-15 18:21:45.708+00 177 77 177 REL-003642 table Despesas de pedágio SEM PARAR transaction
2 3846 {"table":"item","relationships":[],"type":"table","fields":[{"table":"item","column":"type","type":"STRING","showAt":null,"showInHours":false,"format":"list:itemTypes","daysEvaluatedColumns":null}],"filters":[],"aggregates":[],"preview":false,"orderBy":[],"groupBy":[]} 2022-12-13 19:50:40.037+00 2022-12-13 19:55:54.429+00 2022-12-13 19:55:54.42+00 77 77 77 77 REL-003846 table Todos os tipos item
{"type":"treemap","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":true},"stacked_column":{"enabled":false},"filters":{"showOnlyFirstRecords":false,"showAllRecords":true,"recordsToShow":null}} 565 3440 {"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},{"table":"transaction","column":"item_id","type":"INTEGER","showAt":{"inner":true,"total":true},"showInHours":false,"format":null,"daysEvaluatedColumns":null}],"filters":[{"field":"transaction.date","operator":"dynamic_period","condition":"AND","value":"sub_12_months:last_month","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},{"field":"transaction.item_id","operator":"equal","condition":"AND","value":[4896],"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":2},{"field":"transaction.supplier_id","operator":"equal","condition":"AND","value":[845],"variableValue":null,"variableValueType":null,"variableValueTranslated":null,"conditionType":"fixed","references":"supplier","format":null,"type":"INTEGER","isFixedPeriod":false,"isDatePeriod":false,"isDynamicPeriod":false,"isNotInTable":false,"translated":null,"lineNumber":3}],"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},{"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-11-21 19:37:40.888+00 2022-12-01 13:03:04.807+00 376 276 376 REL-003440 matrix Mostra as despesas com locação Despesas com Locação transaction
1 3441 {"table":"employee","relationships":["role"],"type":"table","fields":[{"table":"employee","column":"name","type":"STRING","showAt":null,"showInHours":false,"format":null,"daysEvaluatedColumns":null},{"table":"employee","column":"demission_date","type":"DATE","showAt":null,"showInHours":false,"format":null,"daysEvaluatedColumns":null},{"table":"employee","column":"user_id","type":"INTEGER","showAt":null,"showInHours":false,"format":null,"daysEvaluatedColumns":null},{"table":"employee","column":"subsidiary_id","type":"INTEGER","showAt":null,"showInHours":false,"format":null,"daysEvaluatedColumns":null},{"table":"employee","column":"cost_center_id","type":"INTEGER","showAt":null,"showInHours":false,"format":null,"daysEvaluatedColumns":null},{"table":"employee","column":"employee_role_id","type":"INTEGER","showAt":null,"showInHours":false,"format":null,"daysEvaluatedColumns":null},{"table":"employee","column":"registration_num","type":"STRING","showAt":null,"showInHours":false,"format":null,"daysEvaluatedColumns":null},{"table":"employee","column":"habilitation_num","type":"STRING","showAt":null,"showInHours":false,"format":null,"daysEvaluatedColumns":null},{"table":"employee","column":"habilitation_category","type":"STRING","showAt":null,"showInHours":false,"format":"list:habilitationCategories","daysEvaluatedColumns":null},{"table":"employee","column":"habilitation_due_date","type":"DATE","showAt":null,"showInHours":false,"format":null,"daysEvaluatedColumns":null}],"filters":[{"field":"employee.active","operator":"equal","condition":"AND","value":true,"variableValue":null,"variableValueType":null,"variableValueTranslated":null,"conditionType":"fixed","references":null,"format":null,"type":"BOOLEAN","isDatePeriod":false,"translated":null,"lineNumber":3}],"aggregates":[],"preview":false,"orderBy":[{"table":"employee","column":"name","isHeaderColumn":true,"desc":false}],"groupBy":[]} 2022-11-21 19:54:52.526+00 2022-11-21 20:02:16.682+00 376 376 376 REL-003441 table Lista de colaborador employee
{"type":"bar","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 3643 {"table":"transaction","relationships":["vehicle"],"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":"item_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":"transaction","column":"invoice","type":"STRING","showAt":null,"showInHours":false,"format":null,"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},{"table":"vehicle","column":"cf_308","type":"STRING","showAt":null,"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":5},{"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":6}],"aggregates":[{"table":"transaction","column":"date","group":true,"sum":false,"avg":false,"max":false,"min":false,"stddev":false,"translated":"Data","id":"transaction.date"},{"table":"transaction","column":"final_value","group":false,"sum":true,"avg":false,"max":false,"min":false,"stddev":false}],"preview":false,"orderBy":[{"table":"vehicle","column":"license_plate","isHeaderColumn":true,"desc":true}],"groupBy":[]} 2022-12-09 15:28:19.893+00 2022-12-09 15:30:16.268+00 177 177 177 REL-003643 table Despesas de pedágio MOVE MAIS transaction
2 4117 {"table":"transaction","relationships":["vehicle"],"type":"table","fields":[{"table":"transaction","column":"vehicle_id","type":"INTEGER","showAt":null,"showInHours":false,"format":null,"daysEvaluatedColumns":null},{"table":"transaction","column":"item_id","type":"INTEGER","showAt":null,"showInHours":false,"format":null,"daysEvaluatedColumns":null},{"table":"transaction","column":"date","type":"DATE","showAt":null,"showInHours":false,"format":null,"daysEvaluatedColumns":null}],"filters":[{"field":"vehicle.vehicle_group_id","operator":"equal","condition":"AND","value":[248,282],"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":1}],"aggregates":[],"preview":false,"orderBy":[],"groupBy":[]} 2023-01-18 12:38:57.117+00 2023-01-18 12:38:57.144+00 870 870 REL-004117 table Relatorio de descrição de itens Relatorio de descrição de itens transaction