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
1 325 {"table":"user","relationships":[],"type":"table","fields":[{"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},{"table":"user","column":"profile_id","type":"INTEGER","showAt":null,"showInHours":false,"format":null,"daysEvaluatedColumns":null},{"table":"user","column":"subsidiary_id","type":"JSON","showAt":null,"showInHours":false,"format":"association:subsidiary","daysEvaluatedColumns":null}],"filters":[{"field":"user.active","operator":"equal","condition":"AND","value":true,"variableValue":null,"variableValueType":null,"variableValueTranslated":null,"conditionType":"fixed","references":null,"format":null,"type":"BOOLEAN","isFixedPeriod":false,"isDatePeriod":false,"isDynamicPeriod":false,"isNotInTable":false,"translated":null,"lineNumber":1}],"aggregates":[],"preview":false,"orderBy":[{"table":"user","column":"name","isHeaderColumn":true,"desc":true}],"groupBy":[]} 2022-08-03 19:23:43.101+00 2022-08-03 19:23:43.137+00 77 77 REL-000325 table Mostra todos os usuários que estão ativos dentro do sistema e permissões. Lista de usuários do sistema user
268 1590 {"table":"vehicle","relationships":["group","modelversion","cost_center","model"],"type":"table","fields":[{"table":"vehicle","column":"cf_611","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":"vehicle","column":"cf_379","type":"STRING","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":"vehicle_group_id","type":"INTEGER","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":"axis_number","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":"cf_663","type":"STRING","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":"cf_34","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_612","type":"TEXT","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":4},{"field":"vehicle.cf_379","operator":"equal","condition":"AND","value":["CAVALO","TRUCK"],"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":5},{"field":"vehicle.cf_142","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":6}],"aggregates":[],"preview":false,"orderBy":[],"groupBy":[]} 2022-09-21 11:34:47.358+00 2022-09-21 11:34:48.012+00 870 870 REL-001590 table relatório para verificar veículos ativos MARCA VOLKSWAGEN RELATÓRIO ANALITICO SOMENTE VOLKSWAGEN vehicle
268 1470 {"table":"vehicle","relationships":["group","modelversion","cost_center","model"],"type":"table","fields":[{"table":"vehicle","column":"cf_611","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":"vehicle","column":"cf_379","type":"STRING","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":"vehicle_group_id","type":"INTEGER","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":"axis_number","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":"cf_663","type":"STRING","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":"cf_34","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_612","type":"TEXT","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},{"field":"vehicle.cf_379","operator":"equal","condition":"AND","value":["CAVALO"],"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":[],"preview":false,"orderBy":[],"groupBy":[]} 2022-09-19 14:18:56.648+00 2022-09-19 16:51:18.456+00 870 870 870 REL-001470 table relatório para verificar veículos ativos RELATÓRIO ANALITICO SOMENTE CAVALOS vehicle
{"type":"bar","categories":"vehicle.cf_36","values":[{"column":"_formula.QDE. TIPO","rawColumn":"_formula.QDE. TIPO","summarizer":"formula","axis":0,"isMainValue":true}],"legend":{"enabled":false},"filters":{"showOnlyFirstRecords":false,"showAllRecords":true,"recordsToShow":null},"show_values":{"enabled":true}} 268 4780 {"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},{"table":"vehicle","column":"cf_611","type":"STRING","showAt":{"inner":true,"total":true},"showInHours":false,"format":null,"daysEvaluatedColumns":null},{"table":"vehicle","column":"license_plate","type":"STRING","showAt":{"inner":true,"total":true},"showInHours":false,"format":null,"daysEvaluatedColumns":null},{"table":"vehicle","column":"cf_142","type":"STRING","showAt":{"inner":true,"total":true},"showInHours":false,"format":null,"daysEvaluatedColumns":null},{"table":"vehicle","column":"cf_141","type":"STRING","showAt":{"inner":true,"total":true},"showInHours":false,"format":null,"daysEvaluatedColumns":null},{"table":"vehicle","column":"fabrication_year","type":"INTEGER","showAt":{"inner":true,"total":true},"showInHours":false,"format":null,"daysEvaluatedColumns":null},{"table":"vehicle","column":"model_year","type":"INTEGER","showAt":{"inner":true,"total":true},"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},{"field":"vehicle.cf_379","operator":"equal","condition":"AND","value":["CAVALO"],"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":"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"},{"table":"vehicle","column":"cf_611","group":true,"sum":null,"avg":null,"max":null,"min":null,"matrix_type":"vertical"},{"table":"vehicle","column":"license_plate","group":true,"sum":null,"avg":null,"max":null,"min":null,"matrix_type":"vertical"},{"table":"vehicle","column":"cf_142","group":true,"sum":null,"avg":null,"max":null,"min":null,"matrix_type":"vertical"},{"table":"vehicle","column":"cf_141","group":true,"sum":null,"avg":null,"max":null,"min":null,"matrix_type":"vertical"},{"table":"vehicle","column":"fabrication_year","group":true,"sum":null,"avg":null,"max":null,"min":null,"matrix_type":"vertical"},{"table":"vehicle","column":"model_year","group":true,"sum":null,"avg":null,"max":null,"min":null,"matrix_type":"vertical"}],"preview":false,"orderBy":[{"table":"vehicle","column":"cf_36","isHeaderColumn":true,"desc":false}],"groupBy":[]} 2023-03-06 12:25:53.393+00 2023-03-06 12:25:53.416+00 870 870 REL-004780 matrix Quantidade de veículos por tipo QDE POR TIPOS CAVALOS. vehicle
{"type":"column","categories":"vehicle.cf_142","values":[{"column":"_formula.QDE.","rawColumn":"_formula.QDE.","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 1436 {"table":"vehicle","relationships":[],"type":"matrix","fields":[{"table":"_formula","column":"QDE.","type":"formula","query":"COUNT(DISTINCT vehicle.id)","showAt":{"inner":true,"total":true},"showInHours":false,"format":null,"daysEvaluatedColumns":null,"relatedTables":[{"table":"vehicle"}]},{"table":"vehicle","column":"model_group","type":"STRING","showAt":{"inner":true,"total":true},"showInHours":false,"format":null,"daysEvaluatedColumns":null},{"table":"vehicle","column":"cf_142","type":"STRING","showAt":{"inner":true,"total":true},"showInHours":false,"format":null,"daysEvaluatedColumns":null}],"filters":[],"aggregates":[{"table":"vehicle","column":"model_group","group":true,"sum":null,"avg":null,"max":null,"min":null,"matrix_type":"vertical"},{"table":"vehicle","column":"cf_142","group":true,"sum":null,"avg":null,"max":null,"min":null,"matrix_type":"horizontal"}],"preview":false,"orderBy":[{"table":"vehicle","column":"cf_142","isHeaderColumn":true,"desc":false}],"groupBy":[]} 2022-09-18 15:08:18.727+00 2022-09-21 11:39:40.854+00 2022-09-21 11:39:40.85+00 870 870 870 870 REL-001436 matrix Quantidade de veículos por tipo QDE POR MARCA vehicle
1 106 {"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 26 {"table":"transaction","relationships":["service_order","vehicle","item"],"type":"table","fields":[{"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.service_order_id","operator":"$ne","condition":"AND","value":null,"references":"service_order","format":null,"type":"INTEGER"},{"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.final_value","operator":"$gte","condition":"AND","value":0.01,"references":null,"format":null,"type":"DECIMAL"},{"field":"service_order.type","operator":"equal","condition":"AND","value":["corrective"],"references":null,"format":"list:serviceOrderTypes","type":"STRING"}],"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":"vehicle_id","isHeaderColumn":false,"desc":false}],"hideDetails":false} 2016-07-04 18:06:03.445+00 2022-08-03 20:00:23.447+00 77 REL-000026 table Ordens de serviço - Custos corretivos no mês atual transaction
268 4785 {"table":"vehicle","relationships":["group","modelversion","cost_center","model"],"type":"table","fields":[{"table":"vehicle","column":"cf_611","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":"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":"disponibility","type":"STRING","showAt":null,"showInHours":false,"format":"list:vehicleDisponibility","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},{"field":"vehicle.cf_611","operator":"not_empty","condition":"AND","value":null,"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},{"field":"vehicle.license_plate","operator":"not_empty","condition":"AND","value":null,"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":"vehicle.cf_34","operator":"not_empty","condition":"AND","value":null,"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":4},{"field":"vehicle.cf_379","operator":"$ne","condition":"AND","value":["SEMIRREBOQUE","REBOQUE","PASSEIO","UTILITARIO"],"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":5},{"field":"vehicle.vehicle_group_id","operator":"$ne","condition":"AND","value":[215],"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":6}],"aggregates":[],"preview":false,"orderBy":[],"groupBy":[]} 2023-03-06 13:18:34.214+00 2023-03-06 18:57:49.552+00 870 870 870 REL-004785 table relatório para verificar frotas ativas RELATÓRIO ANALITICO VEICULOS v9 vehicle
{"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 2698 {"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":8},{"field":"ct_34.cf_656","operator":"equal","condition":"AND","value":"SCANIA","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":9},{"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":10}],"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:05.417+00 2022-10-25 13:37:05.611+00 870 870 REL-002698 matrix Relatório de emissões de CO2 referente ano 2022 TOTAL Emissão CO2 (SCANIA) ct_34
{"type":"treemap","categories":"vehicle.cf_34","values":[{"column":"_formula.QDE.","rawColumn":"_formula.QDE.","axis":0,"summarizer":"formula","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}} 268 1437 {"table":"vehicle","relationships":[],"type":"matrix","fields":[{"table":"_formula","column":"QDE.","type":"formula","query":"COUNT(DISTINCT vehicle.id)","showAt":{"inner":true,"total":true},"showInHours":false,"format":null,"daysEvaluatedColumns":null,"relatedTables":[{"table":"vehicle"}]},{"table":"vehicle","column":"model_group","type":"STRING","showAt":{"inner":true,"total":true},"showInHours":false,"format":null,"daysEvaluatedColumns":null},{"table":"vehicle","column":"subsidiary_id","type":"INTEGER","showAt":{"inner":true,"total":true},"showInHours":false,"format":null,"daysEvaluatedColumns":null}],"filters":[],"aggregates":[{"table":"vehicle","column":"model_group","group":true,"sum":null,"avg":null,"max":null,"min":null,"matrix_type":"vertical","translated":"Grupo do modelo","id":"vehicle.model_group"},{"table":"vehicle","column":"subsidiary_id","group":true,"sum":null,"avg":null,"max":null,"min":null,"matrix_type":"horizontal","translated":"Filial","id":"vehicle.subsidiary_id"}],"preview":false,"orderBy":[{"table":"vehicle","column":"subsidiary_id","isHeaderColumn":true,"desc":false}],"groupBy":[]} 2022-09-18 15:10:43.253+00 2022-09-21 11:40:37.571+00 2022-09-21 11:40:37.568+00 870 870 870 870 REL-001437 matrix Quantidade de veículos por tipo QDE POR FILIAL vehicle
{"type":"bar","categories":"transaction.vehicle_id","values":[{"column":"transaction.distance","rawColumn":"transaction.distance__sum__","axis":0,"summarizer":"sum","isMainValue":true},{"column":"transaction.quantity","rawColumn":"transaction.quantity__sum__","axis":0,"summarizer":"sum","isMainValue":false}],"legend":{"enabled":true},"filters":{"showOnlyFirstRecords":false,"showAllRecords":true,"recordsToShow":null},"show_values":{"enabled":true}} 1 359 {"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":"employee_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":"vehicle_model_id","type":"INTEGER","showAt":null,"showInHours":false,"format":null,"daysEvaluatedColumns":null},{"table":"transaction","column":"expense_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},{"table":"transaction","column":"final_value","type":"DECIMAL","showAt":null,"showInHours":false,"format":"Money","daysEvaluatedColumns":null},{"table":"transaction","column":"odometer","type":"DECIMAL","showAt":null,"showInHours":false,"format":null,"daysEvaluatedColumns":null},{"table":"transaction","column":"distance","type":"DECIMAL","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":"real_consumption","type":"DECIMAL","showAt":null,"showInHours":false,"format":null,"daysEvaluatedColumns":null},{"table":"transaction","column":"standard_consumption","type":"DECIMAL","showAt":null,"showInHours":false,"format":null,"daysEvaluatedColumns":null},{"table":"transaction","column":"deviation_percentage","type":"DECIMAL","showAt":null,"showInHours":false,"format":null,"daysEvaluatedColumns":null},{"table":"_formula","column":"Média (km/l)","type":"formula","query":"SUM(transaction.distance) / SUM(transaction.quantity)","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":"gas_pump_id","type":"INTEGER","showAt":null,"showInHours":false,"format":null,"daysEvaluatedColumns":null},{"table":"transaction","column":"external_id","type":"STRING","showAt":null,"showInHours":false,"format":null,"daysEvaluatedColumns":null},{"table":"transaction","column":"created_by_id","type":"INTEGER","showAt":null,"showInHours":false,"format":null,"daysEvaluatedColumns":null},{"table":"transaction","column":"updated_by_id","type":"INTEGER","showAt":null,"showInHours":false,"format":null,"daysEvaluatedColumns":null}],"filters":[{"field":"transaction.register_type","operator":"equal","condition":"AND","value":["Abastecimento"],"variableValue":null,"variableValueType":null,"variableValueTranslated":null,"conditionType":"fixed","references":null,"format":"list:transactionRegisterTypes","type":"STRING","isFixedPeriod":false,"isDatePeriod":false,"isDynamicPeriod":false,"translated":null,"lineNumber":9},{"field":"vehicle.consumption_type","operator":"equal","condition":"AND","value":["km/l"],"variableValue":null,"variableValueType":null,"variableValueTranslated":null,"conditionType":"fixed","references":null,"format":"list:consumptionTypes","type":"STRING","isFixedPeriod":false,"isDatePeriod":false,"isDynamicPeriod":false,"translated":null,"lineNumber":10},{"field":"transaction.item_id","operator":"not_empty","condition":"AND","value":null,"variableValue":null,"variableValueType":null,"variableValueTranslated":null,"conditionType":"fixed","references":"item","format":null,"type":"INTEGER","isFixedPeriod":false,"isDatePeriod":false,"isDynamicPeriod":false,"translated":null,"lineNumber":11}],"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":"distance","group":false,"sum":true,"avg":false,"max":false,"min":false},{"table":"transaction","column":"quantity","group":false,"sum":true,"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":"date","isHeaderColumn":true,"desc":false}],"groupBy":[]} 2022-08-04 19:43:35.856+00 2022-08-04 19:52:36.734+00 77 77 77 REL-000359 table Abastecimentos transaction