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":"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 1511 {"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":9},{"field":"vehicle.cf_379","operator":"equal","condition":"AND","value":["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":10}],"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:44:19.834+00 2023-03-06 12:24:10.747+00 2023-03-06 12:24:10.744+00 870 870 870 870 REL-001511 matrix Quantidade de veículos por tipo QDE POR TIPOS TRUCKS vehicle
{"type":"column","categories":"vehicle.cf_141","values":[{"column":"_formula.QDE.","rawColumn":"_formula.QDE.","summarizer":"formula","axis":0,"isMainValue":true}],"legend":{"enabled":false},"filters":{"showOnlyFirstRecords":false,"showAllRecords":true,"recordsToShow":null},"show_values":{"enabled":true}} 268 1552 {"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_141","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":[{"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":6}],"aggregates":[{"table":"vehicle","column":"cf_141","group":true,"sum":null,"avg":null,"max":null,"min":null,"matrix_type":"horizontal","translated":"Modelo RG LOG","id":"vehicle.cf_141"},{"table":"vehicle","column":"cf_142","group":true,"sum":null,"avg":null,"max":null,"min":null,"matrix_type":"vertical"}],"preview":false,"orderBy":[{"table":"vehicle","column":"cf_141","isHeaderColumn":true,"desc":false}],"groupBy":[]} 2022-09-20 18:52:53.491+00 2022-09-21 12:48:45.598+00 2022-09-21 12:48:45.595+00 870 870 870 870 REL-001552 matrix Quantidade de veículos por tipo QDE POR MODELO v2 vehicle
{"type":"column","categories":"transaction.invoice","values":[{"column":"transaction.final_value","rawColumn":"transaction.final_value__sum__","axis":0,"summarizer":"sum","isMainValue":true}],"legend":{"enabled":false},"filters":{"showOnlyFirstRecords":false,"showAllRecords":true,"recordsToShow":null},"show_values":{"enabled":true}} 235 2266 {"table":"transaction","relationships":["vehicle"],"type":"table","fields":[{"table":"transaction","column":"invoice","type":"STRING","showAt":null,"showInHours":false,"format":null,"daysEvaluatedColumns":null},{"table":"transaction","column":"unit_value","type":"DECIMAL","showAt":null,"showInHours":false,"format":"Money","daysEvaluatedColumns":null},{"table":"transaction","column":"final_value","type":"DECIMAL","showAt":null,"showInHours":false,"format":"Money","daysEvaluatedColumns":null},{"table":"vehicle","column":"cf_36","type":"STRING","showAt":null,"showInHours":false,"format":null,"daysEvaluatedColumns":null}],"filters":[{"field":"transaction.supplier_id","operator":"equal","condition":"AND","value":[1422,1421],"variableValue":null,"variableValueType":null,"variableValueTranslated":null,"conditionType":"fixed","references":"supplier","format":null,"type":"INTEGER","isFixedPeriod":false,"isDatePeriod":false,"isDynamicPeriod":false,"isNotInTable":false,"translated":null,"lineNumber":6},{"field":"vehicle.cf_36","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":"transaction","column":"final_value","group":false,"sum":true,"avg":false,"max":false,"min":false,"stddev":false},{"table":"transaction","column":"invoice","group":true,"sum":false,"avg":false,"max":false,"min":false,"stddev":false}],"preview":false,"orderBy":[],"groupBy":[]} 2022-09-30 14:29:18.696+00 2022-09-30 14:29:18.737+00 870 870 REL-002266 table Relatório de pedágio Sem Parar total geral PASSEIO Total Sem Parar PASSEIO transaction
{"type":"bar","categories":"vehicle.license_plate","values":[{"column":"transaction.final_value","rawColumn":"transaction.final_value__sum__","axis":0,"summarizer":"sum","isMainValue":true}],"legend":{"enabled":true},"filters":{"showOnlyFirstRecords":false,"showAllRecords":true,"recordsToShow":null},"show_values":{"enabled":true}} 235 763 {"table":"transaction","relationships":["vehicle"],"type":"table","fields":[{"table":"vehicle","column":"license_plate","type":"STRING","showAt":null,"showInHours":false,"format":null,"daysEvaluatedColumns":null},{"table":"transaction","column":"vehicle_id","type":"INTEGER","showAt":null,"showInHours":false,"format":null,"daysEvaluatedColumns":null},{"table":"transaction","column":"name","type":"STRING","showAt":null,"showInHours":false,"format":null,"daysEvaluatedColumns":null},{"table":"transaction","column":"date","type":"DATE","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":"unit_value","type":"DECIMAL","showAt":null,"showInHours":false,"format":"Money","daysEvaluatedColumns":null},{"table":"transaction","column":"final_value","type":"DECIMAL","showAt":null,"showInHours":false,"format":"Money","daysEvaluatedColumns":null},{"table":"transaction","column":"supplier_id","type":"INTEGER","showAt":null,"showInHours":false,"format":null,"daysEvaluatedColumns":null},{"table":"transaction","column":"observation","type":"TEXT","showAt":null,"showInHours":false,"format":null,"daysEvaluatedColumns":null},{"table":"transaction","column":"invoice","type":"STRING","showAt":null,"showInHours":false,"format":null,"daysEvaluatedColumns":null}],"filters":[{"field":"transaction.supplier_id","operator":"equal","condition":"AND","value":[1422,1421],"variableValue":null,"variableValueType":null,"variableValueTranslated":null,"conditionType":"fixed","references":"supplier","format":null,"type":"INTEGER","isFixedPeriod":false,"isDatePeriod":false,"isDynamicPeriod":false,"isNotInTable":false,"translated":null,"lineNumber":2}],"aggregates":[{"table":"transaction","column":"final_value","group":false,"sum":true,"avg":false,"max":false,"min":false,"stddev":false},{"table":"vehicle","column":"license_plate","group":true,"sum":false,"avg":false,"max":false,"min":false,"stddev":false}],"preview":false,"orderBy":[],"groupBy":[]} 2022-08-19 19:49:20.275+00 2022-10-24 19:50:33.918+00 2022-10-24 19:50:33.897+00 376 870 870 376 REL-000763 table Mostra todos os pedágios, gerando dentro do Sofit Pedagios transaction
1 863 {"table":"user","relationships":["employee"],"type":"table","fields":[{"table":"user","column":"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":"employee","column":"active","type":"BOOLEAN","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":"email","type":"STRING","showAt":null,"showInHours":false,"format":null,"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":false}],"groupBy":[]} 2022-08-25 17:58:32.736+00 2022-08-25 18:58:38.235+00 376 376 376 REL-000863 table usuário ativos no sistema user
{"type":"column","categories":"tire.current_vehicle_id","values":[{"column":"_formula.Quantidade","rawColumn":"_formula.Quantidade","summarizer":"formula","axis":0,"isMainValue":true}],"legend":{"enabled":true}} 136 829 {"table":"tire","relationships":[],"type":"table","fields":[{"table":"tire","column":"current_vehicle_id","type":"INTEGER","showAt":null,"showInHours":false,"format":null,"daysEvaluatedColumns":null},{"table":"tire","column":"name","type":"STRING","showAt":null,"showInHours":false,"format":null,"daysEvaluatedColumns":null},{"table":"tire","column":"current_tire_position","type":"STRING","showAt":null,"showInHours":false,"format":null,"daysEvaluatedColumns":null},{"table":"_formula","column":"Quantidade","type":"formula","query":"COUNT(tire.id)","showAt":null,"showInHours":false,"format":null,"daysEvaluatedColumns":null}],"filters":[{"field":"tire.status","operator":"equal","condition":"AND","value":["in_activity"],"variableValue":null,"variableValueType":null,"variableValueTranslated":null,"conditionType":"fixed","references":null,"format":"list:tireStatus","type":"STRING","isFixedPeriod":false,"isDatePeriod":false,"isDynamicPeriod":false,"translated":null,"lineNumber":1}],"aggregates":[{"table":"tire","column":"current_vehicle_id","group":true,"sum":false,"avg":false,"max":false,"min":false}],"preview":false,"orderBy":[{"table":"tire","column":"current_tire_position","isHeaderColumn":true,"desc":false}],"groupBy":[]} 2022-08-22 20:35:43.079+00 2022-08-22 20:38:17.788+00 2022-08-22 20:38:17.784+00 376 376 376 376 REL-000829 table Pneus - Veículos sem pneu tire
202 830 {"table":"vehicle","relationships":[],"type":"table","fields":[{"table":"vehicle","column":"license_plate","type":"STRING","showAt":null,"showInHours":false,"format":null,"daysEvaluatedColumns":null}],"filters":[{"field":"vehicle.id","operator":"not_in_table","condition":"AND","value":"tires","variableValue":null,"variableValueType":null,"variableValueTranslated":null,"conditionType":"fixed","references":null,"format":null,"type":"INTEGER","isFixedPeriod":false,"isDatePeriod":false,"isDynamicPeriod":false,"isNotInTable":true,"translated":null,"lineNumber":1}],"aggregates":[],"preview":false,"orderBy":[],"groupBy":[]} 2022-08-22 20:56:13.275+00 2022-08-22 20:56:13.73+00 376 376 REL-000830 table mostra os veiculos que não tem pneu aplicado veiculos sem pneus 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 4781 {"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":["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"}],"preview":false,"orderBy":[{"table":"vehicle","column":"cf_36","isHeaderColumn":true,"desc":false}],"groupBy":[]} 2023-03-06 12:28:53.742+00 2023-03-06 12:28:53.766+00 870 870 REL-004781 matrix Quantidade de veículos por tipo QDE POR TIPOS CARRETAS. vehicle
1 964 {"table":"user","relationships":["employee"],"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":"email","type":"STRING","showAt":null,"showInHours":false,"format":null,"daysEvaluatedColumns":null},{"table":"employee","column":"name","type":"STRING","showAt":null,"showInHours":false,"format":null,"daysEvaluatedColumns":null},{"table":"employee","column":"user_id","type":"INTEGER","showAt":null,"showInHours":false,"format":null,"daysEvaluatedColumns":null}],"filters":[{"field":"user.is_support","operator":"equal","condition":"AND","value":false,"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":false}],"groupBy":[]} 2022-08-31 21:00:48.2+00 2022-08-31 21:00:48.413+00 514 514 REL-000964 table Colaboradores x usuários user
202 1067 {"table":"tire_life","relationships":["tire"],"type":"table","fields":[{"table":"tire","column":"name","type":"STRING","showAt":null,"showInHours":false,"format":null,"daysEvaluatedColumns":null},{"table":"tire","column":"structure","type":"STRING","showAt":null,"showInHours":false,"format":"list:tireStructures","daysEvaluatedColumns":null},{"table":"tire","column":"tire_brand_id","type":"INTEGER","showAt":null,"showInHours":false,"format":null,"daysEvaluatedColumns":null},{"table":"tire","column":"tire_drawing_id","type":"INTEGER","showAt":null,"showInHours":false,"format":null,"daysEvaluatedColumns":null},{"table":"tire_life","column":"life","type":"INTEGER","showAt":null,"showInHours":false,"format":null,"daysEvaluatedColumns":null},{"table":"tire","column":"accumulated_durability","type":"DECIMAL","showAt":null,"showInHours":false,"format":null,"daysEvaluatedColumns":null},{"table":"tire","column":"subsidiary_id","type":"INTEGER","showAt":null,"showInHours":false,"format":null,"daysEvaluatedColumns":null}],"filters":[{"field":"tire.status","operator":"equal","condition":"AND","value":["discarded"],"variableValue":null,"variableValueType":null,"variableValueTranslated":null,"conditionType":"fixed","references":null,"format":"list:tireStatus","type":"STRING","isFixedPeriod":false,"isDatePeriod":false,"isDynamicPeriod":false,"isNotInTable":false,"translated":null,"lineNumber":1}],"aggregates":[],"preview":false,"orderBy":[],"groupBy":[]} 2022-09-02 14:48:42.264+00 2022-09-02 14:48:43.542+00 376 376 REL-001067 table Pneus descartado tire_life