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
2 2300 {"table":"vehicle","relationships":[],"type":"table","fields":[{"table":"vehicle","column":"cf_767","type":"DECIMAL","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_768","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":"credtudo_updated_date","type":"STRING","showAt":null,"showInHours":false,"format":null,"daysEvaluatedColumns":null}],"filters":[],"aggregates":[],"preview":false,"orderBy":[{"table":"vehicle","column":"cf_35","isHeaderColumn":true,"desc":false}],"groupBy":[]} 2022-09-30 18:49:08.807+00 2022-09-30 18:49:09.193+00 376 376 REL-002300 table Detalhes do Sascar vehicle
{"type":"bar","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":false},"stacked_column":{"enabled":false},"filters":{"showOnlyFirstRecords":false,"showAllRecords":true,"recordsToShow":null}} 268 1550 {"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_34","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","translated":"Grupo do modelo","id":"vehicle.model_group"},{"table":"vehicle","column":"cf_34","group":true,"sum":null,"avg":null,"max":null,"min":null,"matrix_type":"horizontal","translated":"Propriedade","id":"vehicle.cf_34"}],"preview":false,"orderBy":[{"table":"vehicle","column":"cf_34","isHeaderColumn":true,"desc":false}],"groupBy":[]} 2022-09-20 18:42:59.651+00 2022-09-21 12:38:27.011+00 2022-09-21 12:38:27.003+00 870 870 870 870 REL-001550 matrix Quantidade de veículos por tipo QDE POR PROPRIEDADE vehicle
1 131 1 52 {"table":"service_order","relationships":[],"type":"table","fields":[{"table":"service_order","column":"vehicle_id","type":"INTEGER","showAt":null,"format":null},{"table":"service_order","column":"name","type":"STRING","showAt":null,"format":null},{"table":"service_order","column":"type","type":"STRING","showAt":null,"format":"list:serviceOrderTypes"},{"table":"service_order","column":"status","type":"STRING","showAt":null,"format":"list:serviceOrderStatus"},{"table":"service_order","column":"service_start_date","type":"DATE","showAt":null,"format":null},{"table":"service_order","column":"service_finish_date","type":"DATE","showAt":null,"format":null},{"table":"service_order","column":"doc_number","type":"STRING","showAt":null,"format":null},{"table":"service_order","column":"total_cost","type":"DECIMAL","showAt":null,"format":"Money"},{"table":"service_order","column":"request_reason","type":"STRING","showAt":null,"format":"list:requestReasonsSO"}],"filters":[{"field":"service_order.service_finish_date","operator":"dynamic_period","condition":"AND","value":"sub_30_days:this_day","references":null,"format":null,"type":"DATE","isFixedPeriod":false,"isDynamicPeriod":true},{"field":"service_order.service_finish_date","operator":"not_empty","condition":"AND","value":null,"references":null,"format":null,"type":"DATE","isFixedPeriod":false,"isDynamicPeriod":false}],"aggregates":[{"table":"service_order","column":"vehicle_id","group":true,"sum":false,"avg":false,"max":false,"min":false}],"preview":false,"orderBy":[],"hideDetails":false} 2017-11-09 20:01:04.018+00 2022-09-29 13:53:54.152+00 1 37 1 REL-000052 table Relatório utiliza a data de término para o período Apenas ordens com data de término serão listadas. As ordens Aguardando NF e Terminadas possuem data de término. Ordens de Serviço - Custos com ordens de serviço por veículo U30d service_order
{"type":"bar","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}} 532 2940 {"table":"transaction","relationships":["vehicle"],"type":"matrix","fields":[{"table":"transaction","column":"supplier_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}],"filters":[{"field":"transaction.supplier_id","operator":"equal","condition":"AND","value":[2425],"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}],"aggregates":[{"table":"transaction","column":"supplier_id","group":true,"sum":null,"avg":null,"max":null,"min":null,"matrix_type":"vertical","translated":"Fornecedor","id":"transaction.supplier_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}],"preview":false,"orderBy":[{"table":"transaction","column":"date","isHeaderColumn":true,"desc":false}],"groupBy":[]} 2022-10-27 11:17:48.506+00 2022-10-27 11:17:49.798+00 870 870 REL-002940 matrix Mostra somente os custos com a 3s Tecnologia Despesa com 3s Tecnologia transaction
{"type":"bar","categories":"ct_1.cf_103","values":[{"column":"ct_1.cf_104","rawColumn":"ct_1.cf_104__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}} 3 115 {"table":"ct_1","relationships":[],"type":"table","fields":[{"table":"ct_1","column":"cf_103","type":"INTEGER","showAt":null,"showInHours":false,"format":null,"daysEvaluatedColumns":null},{"table":"ct_1","column":"name","type":"STRING","showAt":null,"showInHours":false,"format":null,"daysEvaluatedColumns":null},{"table":"ct_1","column":"cf_104","type":"DECIMAL","showAt":null,"showInHours":false,"format":"Money","daysEvaluatedColumns":null},{"table":"ct_1","column":"cf_105","type":"STRING","showAt":null,"showInHours":false,"format":null,"daysEvaluatedColumns":null},{"table":"ct_1","column":"cf_106","type":"JSON","showAt":null,"showInHours":false,"format":"association:employee","daysEvaluatedColumns":null},{"table":"ct_1","column":"cf_107","type":"DATE","showAt":null,"showInHours":false,"format":"Date","daysEvaluatedColumns":null},{"table":"ct_1","column":"created_by_id","type":"INTEGER","showAt":null,"showInHours":false,"format":null,"daysEvaluatedColumns":null}],"filters":[{"field":"ct_1.cf_107","operator":"$gte","condition":"AND","value":"2022-06-15T03: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_1.cf_107","operator":"$lte","condition":"AND","value":"2022-07-15T02: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}],"aggregates":[{"table":"ct_1","column":"cf_103","group":true,"sum":false,"avg":false,"max":false,"min":false,"stddev":false,"translated":"Nome do colaborador ","id":"ct_1.cf_103"},{"table":"ct_1","column":"cf_104","group":false,"sum":true,"avg":false,"max":false,"min":false,"stddev":false}],"preview":false,"orderBy":[],"groupBy":[]} 2022-07-13 20:03:53.09+00 2022-10-27 18:47:32.664+00 2022-10-27 18:47:32.659+00 77 376 376 77 REL-000115 table Este relatório serve para mostrar todos os valores que devem ser descontados do motorista . Módulo de desconto ct_1
{"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 1549 {"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":"cf_379","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":4}],"aggregates":[{"table":"vehicle","column":"cf_142","group":true,"sum":null,"avg":null,"max":null,"min":null,"matrix_type":"vertical"},{"table":"vehicle","column":"cf_379","group":true,"sum":null,"avg":null,"max":null,"min":null,"matrix_type":"horizontal"}],"preview":false,"orderBy":[{"table":"vehicle","column":"cf_379","isHeaderColumn":true,"desc":false}],"groupBy":[]} 2022-09-20 18:40:15.401+00 2022-09-21 11:37:20.164+00 2022-09-21 11:37:20.12+00 870 870 870 870 REL-001549 matrix Quantidade de veículos por tipo QDE POR MARCA v2 vehicle
{"type":"bar","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":{},"stacked_column":{"enabled":false},"filters":{"showOnlyFirstRecords":false,"showAllRecords":true,"recordsToShow":null}} 268 1553 {"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_34","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":7}],"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":"cf_34","group":true,"sum":null,"avg":null,"max":null,"min":null,"matrix_type":"horizontal","translated":"Propriedade","id":"vehicle.cf_34"}],"preview":false,"orderBy":[{"table":"vehicle","column":"cf_34","isHeaderColumn":true,"desc":false}],"groupBy":[]} 2022-09-20 18:56:40.326+00 2022-09-21 12:38:12.051+00 2022-09-21 12:38:12.047+00 870 870 870 870 REL-001553 matrix Quantidade de veículos por tipo QDE POR PROPRIEDADE v2 vehicle
1 2154 {"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.vehicle_id","operator":"not_empty","condition":"AND","value":null,"references":"vehicle","format":null,"type":"INTEGER","variableValue":null,"variableValueType":null,"conditionType":"fixed","isFixedPeriod":false,"isDynamicPeriod":false,"isNotInTable":false,"isDatePeriod":false,"daysInPeriod":null,"frequencyInPeriod":null,"translated":null},{"field":"service_order.status","operator":"equal","condition":"AND","value":["in_progress"],"references":null,"format":"list:serviceOrderStatus","type":"STRING","variableValue":null,"variableValueType":null,"conditionType":"fixed","isFixedPeriod":false,"isDynamicPeriod":false,"isNotInTable":false,"isDatePeriod":false,"daysInPeriod":null,"frequencyInPeriod":null,"translated":null},{"field":"service_order.forecast_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,"isNotInTable":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":false,"groupBy":[],"having":[]} 2022-09-29 14:35:41.765+00 2022-09-29 14:35:42.04+00 310 310 REL-002154 table Relatório utiliza a data de término para o período Apenas ordens com data de término serão listadas. As ordens Aguardando NF e Terminadas possuem data de término. Ordens de Serviço - Custos com ordens de serviço por veículo service_order
{"type":"column","categories":"transaction.vehicle_id","values":[{"column":"transaction.real_consumption","rawColumn":"transaction.real_consumption__avg__","axis":0,"summarizer":"avg","isMainValue":true}],"legend":{"enabled":true},"filters":{"showOnlyFirstRecords":false,"showAllRecords":true,"recordsToShow":null},"show_values":{"enabled":true}} 433 2703 {"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":"real_consumption","type":"DECIMAL","summarizers":{"sum":false,"avg":true,"max":false,"min":false},"showAt":{"inner":true,"total":true},"showInHours":false,"format":null,"daysEvaluatedColumns":null},{"table":"transaction","column":"vehicle_id","type":"INTEGER","showAt":{"inner":true,"total":true},"showInHours":false,"format":null,"daysEvaluatedColumns":null}],"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,"isNotInTable":false,"translated":null,"lineNumber":11},{"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":12},{"field":"transaction.real_consumption","operator":"$gt","condition":"AND","value":0.01,"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":13},{"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":14},{"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":15}],"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":"real_consumption","group":false,"sum":false,"avg":true,"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:40:32.161+00 2022-10-25 13:40:32.177+00 870 870 REL-002703 matrix Consumo médio por veículo marca IVECO Consumo médio por frota (IVECO) transaction
{"type":"column","categories":"transaction.date","values":[{"column":"transaction.final_value","rawColumn":"transaction.final_value__sum__","axis":0,"summarizer":"sum","isMainValue":true}],"legend":{"enabled":true},"show_values":{"enabled":true},"use_diferent_color":{"enabled":false},"stacked_column":{"enabled":false},"filters":{"showOnlyFirstRecords":false,"showAllRecords":true,"recordsToShow":null}} 235 2257 {"table":"transaction","relationships":["expense"],"type":"table","fields":[{"table":"transaction","column":"invoice","type":"STRING","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":"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}],"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":1},{"field":"transaction.vehicle_id","operator":"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,"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":"transaction","column":"invoice","group":true,"sum":false,"avg":false,"max":false,"min":false,"stddev":false,"translated":"Fatura","id":"transaction.invoice"}],"preview":false,"orderBy":[],"groupBy":[]} 2022-09-30 13:22:26.768+00 2022-10-24 19:54:09.409+00 2022-10-24 19:54:08.686+00 870 870 870 870 REL-002257 table Mostra somente o pedágio consumido por placas de terceiros na Move Mais por fatura Valor por fatura de terceiros Move Mais transaction