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":"treemap","categories":"vehicle.cost_center_id","values":[{"column":"_formula.QDE.","rawColumn":"_formula.QDE.","axis":0,"summarizer":"formula","isMainValue":true}],"legend":{"enabled":false},"show_values":{"enabled":false},"use_diferent_color":{"enabled":true},"stacked_column":{"enabled":false},"filters":{"showOnlyFirstRecords":false,"showAllRecords":true,"recordsToShow":null}} 268 1606 {"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":"cf_142","type":"STRING","showAt":{"inner":true,"total":true},"showInHours":false,"format":null,"daysEvaluatedColumns":null},{"table":"vehicle","column":"cost_center_id","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":3},{"field":"vehicle.cf_379","operator":"equal","condition":"AND","value":["CAVALO","UTILITARIO","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":4}],"aggregates":[{"table":"vehicle","column":"cf_142","group":true,"sum":null,"avg":null,"max":null,"min":null,"matrix_type":"vertical","translated":"Marca RG LOG","id":"vehicle.cf_142"},{"table":"vehicle","column":"cost_center_id","group":true,"sum":null,"avg":null,"max":null,"min":null,"matrix_type":"horizontal","translated":"Centro de custo","id":"vehicle.cost_center_id"}],"preview":false,"orderBy":[{"table":"vehicle","column":"cost_center_id","isHeaderColumn":true,"desc":false}],"groupBy":[]} 2022-09-21 13:04:04.785+00 2022-09-21 13:24:20.051+00 870 870 870 REL-001606 matrix Quantidade de veículos por centro de custos QDE POR CENTRO CUSTO VEICULOS v2 vehicle
{"type":"treemap","categories":"vehicle.cost_center_id","values":[{"column":"_formula.QDE.","rawColumn":"_formula.QDE.","axis":0,"summarizer":"formula","isMainValue":true}],"legend":{"enabled":false},"show_values":{"enabled":false},"use_diferent_color":{"enabled":true},"stacked_column":{},"filters":{"showOnlyFirstRecords":false,"showAllRecords":true,"recordsToShow":null}} 268 1609 {"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":"cf_142","type":"STRING","showAt":{"inner":true,"total":true},"showInHours":false,"format":null,"daysEvaluatedColumns":null},{"table":"vehicle","column":"cost_center_id","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","UTILITARIO","TRUCK","PASSEIO"],"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_142","group":true,"sum":null,"avg":null,"max":null,"min":null,"matrix_type":"vertical","translated":"Marca RG LOG","id":"vehicle.cf_142"},{"table":"vehicle","column":"cost_center_id","group":true,"sum":null,"avg":null,"max":null,"min":null,"matrix_type":"horizontal","translated":"Centro de custo","id":"vehicle.cost_center_id"}],"preview":false,"orderBy":[{"table":"vehicle","column":"cost_center_id","isHeaderColumn":true,"desc":false}],"groupBy":[]} 2022-09-21 13:24:42.54+00 2022-09-21 13:24:42.64+00 870 870 REL-001609 matrix Quantidade de veículos por centro de custos QDE POR CENTRO CUSTO VEICULOS vehicle
{"type":"pie","categories":"vehicle.cf_734","values":[{"column":"_formula.QDE. TIPO","rawColumn":"_formula.QDE. TIPO","axis":0,"summarizer":"formula","isMainValue":true}],"legend":{"enabled":true},"show_values":{"enabled":false},"use_diferent_color":{"enabled":false},"stacked_column":{"enabled":false},"filters":{"showOnlyFirstRecords":false,"showAllRecords":true,"recordsToShow":null}} 268 1592 {"table":"vehicle","relationships":[],"type":"matrix","fields":[{"table":"_formula","column":"QDE. TIPO","type":"formula","query":"COUNT(DISTINCT vehicle.id)","showAt":{"inner":true,"total":true},"showInHours":false,"format":null,"daysEvaluatedColumns":null,"relatedTables":[{"table":"vehicle"}]},{"table":"vehicle","column":"cf_379","type":"STRING","showAt":{"inner":true,"total":true},"showInHours":false,"format":null,"daysEvaluatedColumns":null},{"table":"vehicle","column":"cf_36","type":"STRING","showAt":{"inner":true,"total":true},"showInHours":false,"format":null,"daysEvaluatedColumns":null}],"filters":[{"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":3},{"field":"vehicle.cf_379","operator":"equal","condition":"AND","value":["CAVALO","UTILITARIO","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":4}],"aggregates":[{"table":"vehicle","column":"cf_379","group":true,"sum":null,"avg":null,"max":null,"min":null,"matrix_type":"vertical","translated":"Tipo de Grupo","id":"vehicle.cf_379"},{"table":"vehicle","column":"cf_36","group":true,"sum":null,"avg":null,"max":null,"min":null,"matrix_type":"horizontal","translated":"Classificação","id":"vehicle.cf_36"}],"preview":false,"orderBy":[{"table":"vehicle","column":"cf_36","isHeaderColumn":true,"desc":false}],"groupBy":[]} 2022-09-21 11:42:28.234+00 2022-09-21 13:33:18.509+00 870 870 870 REL-001592 matrix Quantidade de veículos por tipo QDE POR TIPOS V4 vehicle
{"type":"column","categories":"transaction.vehicle_id","values":[{"column":"transaction.traveled_distance","rawColumn":"transaction.traveled_distance__sum__","axis":0,"summarizer":"sum","isMainValue":true}],"legend":{"enabled":true},"filters":{"showOnlyFirstRecords":false,"showAllRecords":true,"recordsToShow":null},"show_values":{"enabled":true}} 433 2706 {"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":"traveled_distance","type":"DECIMAL","summarizers":{"sum":true,"avg":false,"max":false,"min":false},"showAt":{"inner":true,"total":true},"showInHours":false,"format":null,"daysEvaluatedColumns":null},{"table":"_formula","column":"QDE. FROTAS","type":"formula","query":"COUNT(DISTINCT vehicle.id)","showAt":{"inner":true,"total":true},"showInHours":false,"format":null,"daysEvaluatedColumns":null,"relatedTables":[{"table":"vehicle"}]},{"table":"transaction","column":"vehicle_id","type":"INTEGER","showAt":{"inner":true,"total":true},"showInHours":false,"format":null,"daysEvaluatedColumns":null}],"filters":[{"field":"transaction.vehicle_id","operator":"not_empty","condition":"AND","value":null,"variableValue":null,"variableValueType":null,"variableValueTranslated":null,"conditionType":"fixed","references":"vehicle","format":null,"type":"INTEGER","isFixedPeriod":false,"isDatePeriod":false,"isDynamicPeriod":false,"translated":null,"lineNumber":26},{"field":"vehicle.motorized","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":27},{"field":"transaction.date","operator":"dynamic_period","condition":"AND","value":"this_month:this_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":28},{"field":"vehicle.cf_34","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":29},{"field":"vehicle.cf_142","operator":"equal","condition":"AND","value":"IVECO","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":30}],"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":"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":[]} 2022-10-25 13:43:53.905+00 2022-10-25 13:43:53.937+00 870 870 REL-002706 matrix Mostra a distância percorrida por frota no mês atual KM RODADO FROTA (IVECO) transaction
{"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 4784 {"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":["PASSEIO"],"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:34:33.764+00 2023-03-06 12:34:33.796+00 870 870 REL-004784 matrix Quantidade de veículos por tipo QDE POR TIPOS PASSEIOS. vehicle
{"type":"pie","categories":"vehicle.cf_734","values":[{"column":"_formula.QDE. TIPO","rawColumn":"_formula.QDE. TIPO","axis":0,"summarizer":"formula","isMainValue":true}],"legend":{"enabled":true},"show_values":{"enabled":false},"use_diferent_color":{"enabled":false},"stacked_column":{"enabled":false},"filters":{"showOnlyFirstRecords":false,"showAllRecords":true,"recordsToShow":null}} 268 1611 {"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_734","type":"STRING","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":23},{"field":"vehicle.cf_379","operator":"equal","condition":"AND","value":["CAVALO","UTILITARIO","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":24}],"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_734","group":true,"sum":null,"avg":null,"max":null,"min":null,"matrix_type":"horizontal","translated":"Operadora Tag","id":"vehicle.cf_734"}],"preview":false,"orderBy":[{"table":"vehicle","column":"cf_734","isHeaderColumn":true,"desc":false}],"groupBy":[]} 2022-09-21 13:34:09.416+00 2022-09-21 13:34:09.436+00 870 870 REL-001611 matrix Quantidade de tags pedágio por operadora QDE TAGS PEDÁGIO 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 5183 {"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},{"table":"vehicle","column":"current_odometer","type":"DECIMAL","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":["SEMIRREBOQUE","REBOQUE"],"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"},{"table":"vehicle","column":"current_odometer","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-09-06 14:58:49.083+00 2023-09-06 14:58:49.095+00 1668 1668 REL-005183 matrix Quantidade de veículos por tipo QDE POR TIPOS CARRETAS.Hodometro vehicle
1 1881 {"table":"service_order","relationships":[],"type":"table","fields":[{"table":"service_order","column":"vehicle_id","type":"INTEGER","showAt":null,"format":null,"translated":"Veículo"},{"table":"service_order","column":"name","type":"STRING","showAt":null,"format":null,"translated":"Nome"},{"table":"service_order","column":"type","type":"STRING","showAt":null,"format":"list:serviceOrderTypes","translated":"Tipo"},{"table":"service_order","column":"status","type":"STRING","showAt":null,"format":"list:serviceOrderStatus","translated":"Situação"},{"table":"service_order","column":"service_start_date","type":"DATE","showAt":null,"format":null,"translated":"Data de início do serviço"},{"table":"service_order","column":"service_finish_date","type":"DATE","showAt":null,"format":null,"translated":"Data de término do serviço"},{"table":"service_order","column":"doc_number","type":"STRING","showAt":null,"format":null,"translated":"Nº de documento"},{"table":"service_order","column":"total_cost","type":"DECIMAL","showAt":null,"format":"Money","translated":"Valor total realizado"},{"table":"service_order","column":"request_reason","type":"STRING","showAt":null,"format":"list:requestReasonsSO","translated":"Motivo da solicitação"}],"filters":[{"field":"service_order.service_finish_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":"service_order.service_finish_date","operator":"not_empty","condition":"AND","value":null,"references":null,"format":null,"type":"DATE","variableValue":null,"variableValueType":null,"conditionType":"fixed","isFixedPeriod":false,"isDynamicPeriod":false,"isDatePeriod":false,"daysInPeriod":null,"frequencyInPeriod":null,"translated":null}],"aggregates":[{"table":"service_order","column":"vehicle_id","group":true,"sum":false,"avg":false,"max":false,"min":false}],"preview":false,"orderBy":[],"hideDetails":true} 2022-09-26 19:13:51.336+00 2022-09-26 19:13:52.049+00 376 376 REL-001881 table Ordens de Serviço - Custos com ordens de serviço por veículo Ano atual service_order
{"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 1510 {"table":"vehicle","relationships":[],"type":"matrix","fields":[{"table":"_formula","column":"QDE. TIPO","type":"formula","query":"COUNT(DISTINCT vehicle.id)","showAt":{"inner":true,"total":true},"showInHours":false,"format":null,"daysEvaluatedColumns":null,"relatedTables":[{"table":"vehicle"}]},{"table":"vehicle","column":"cf_379","type":"STRING","showAt":{"inner":true,"total":true},"showInHours":false,"format":null,"daysEvaluatedColumns":null},{"table":"vehicle","column":"cf_36","type":"STRING","showAt":{"inner":true,"total":true},"showInHours":false,"format":null,"daysEvaluatedColumns":null}],"filters":[{"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":6},{"field":"vehicle.cf_379","operator":"equal","condition":"AND","value":["PASSEIO"],"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":7}],"aggregates":[{"table":"vehicle","column":"cf_379","group":true,"sum":null,"avg":null,"max":null,"min":null,"matrix_type":"vertical","translated":"Tipo de Grupo","id":"vehicle.cf_379"},{"table":"vehicle","column":"cf_36","group":true,"sum":null,"avg":null,"max":null,"min":null,"matrix_type":"horizontal","translated":"Classificação","id":"vehicle.cf_36"}],"preview":false,"orderBy":[{"table":"vehicle","column":"cf_36","isHeaderColumn":true,"desc":false}],"groupBy":[]} 2022-09-19 17:36:19.409+00 2023-03-06 12:35:41.757+00 2023-03-06 12:35:41.754+00 870 870 870 870 REL-001510 matrix Quantidade de veículos por tipo QDE POR TIPOS PASSEIOS vehicle
{"type":"bar","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":{},"stacked_column":{"enabled":false},"filters":{"showOnlyFirstRecords":false,"showAllRecords":true,"recordsToShow":null}} 235 1781 {"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":"name","type":"STRING","showAt":null,"showInHours":false,"format":null,"daysEvaluatedColumns":null,"translated":"Nome"},{"table":"transaction","column":"date","type":"DATE","showAt":null,"showInHours":false,"format":null,"daysEvaluatedColumns":null,"translated":"Data"},{"table":"transaction","column":"item_id","type":"INTEGER","showAt":null,"showInHours":false,"format":null,"daysEvaluatedColumns":null,"translated":"Item"},{"table":"transaction","column":"unit_value","type":"DECIMAL","showAt":null,"showInHours":false,"format":"Money","daysEvaluatedColumns":null,"translated":"Valor unitário"},{"table":"transaction","column":"final_value","type":"DECIMAL","showAt":null,"showInHours":false,"format":"Money","daysEvaluatedColumns":null,"translated":"Valor total"},{"table":"transaction","column":"observation","type":"TEXT","showAt":null,"showInHours":false,"format":null,"daysEvaluatedColumns":null,"translated":"Observação"},{"table":"transaction","column":"doc_number","type":"STRING","showAt":null,"showInHours":false,"format":null,"daysEvaluatedColumns":null,"translated":"Nº de documento"},{"table":"transaction","column":"supplier_id","type":"INTEGER","showAt":null,"showInHours":false,"format":null,"daysEvaluatedColumns":null,"translated":"Fornecedor"}],"filters":[{"field":"transaction.supplier_id","operator":"equal","condition":"AND","value":[2290],"references":"supplier","format":null,"type":"INTEGER","variableValue":null,"variableValueType":null,"conditionType":"fixed","isFixedPeriod":false,"isDynamicPeriod":false,"isNotInTable":false,"isDatePeriod":false,"translated":null},{"field":"transaction.date","operator":"dynamic_period","condition":"AND","value":"last_month:last_month","references":null,"format":null,"type":"DATE","variableValue":null,"variableValueType":null,"conditionType":"fixed","isFixedPeriod":false,"isDynamicPeriod":true,"isNotInTable":false,"isDatePeriod":false,"daysInPeriod":null,"frequencyInPeriod":null,"translated":null}],"aggregates":[{"table":"transaction","column":"vehicle_id","group":true,"sum":false,"avg":false,"max":false,"min":false,"stddev":false,"translated":"Veículo","id":"transaction.vehicle_id"},{"table":"transaction","column":"final_value","group":false,"sum":true,"avg":false,"max":false,"min":false,"stddev":false}],"preview":false,"orderBy":[{"table":"transaction","column":"date","isHeaderColumn":true,"desc":true}],"groupBy":[],"having":[]} 2022-09-23 13:18:17.576+00 2022-10-24 19:52:05.688+00 2022-10-24 19:52:05.682+00 376 870 870 376 REL-001781 table Mostra somente os pedágios do mês anterior Custo com pedágio - Mês anterior transaction