{"id":2986,"date":"2019-08-26T11:09:18","date_gmt":"2019-08-26T11:09:18","guid":{"rendered":"https:\/\/clockify.me\/help\/?p=2986"},"modified":"2026-04-23T08:17:07","modified_gmt":"2026-04-23T08:17:07","slug":"creating-custom-reports","status":"publish","type":"post","link":"https:\/\/clockify.me\/help\/pt\/reports\/creating-custom-reports","title":{"rendered":"Personalizar relat\u00f3rios"},"content":{"rendered":"<p>Se os relat\u00f3rios integrados e as <a href=\"https:\/\/clockify.me\/help\/reports\/customize-exports\">op\u00e7\u00f5es de personaliza\u00e7\u00e3o<\/a> do Clockify n\u00e3o fornecerem a estrutura de que voc\u00ea precisa, crie seu pr\u00f3prio relat\u00f3rio usando tabelas din\u00e2micas no Excel\/Planilhas Google.<\/p>\n\n\n\n<p>Basta exportar os relat\u00f3rios detalhados como CSV ou Excel e voc\u00ea pode criar qualquer tipo de relat\u00f3rio que desejar:<\/p>\n\n\n\n<ul class=\"wp-block-list\">\n<li>Total de horas (ou quantidade) discriminadas por cliente &gt; projeto &gt; tarefa &gt; descri\u00e7\u00e3o<\/li>\n\n\n\n<li>Relat\u00f3rio mensal com total de horas (ou quantidade) por projeto (ou usu\u00e1rio) por dia<\/li>\n<\/ul>\n\n\n\n<div class=\"wp-block-custom-highlight-box custom-box color-green\"><div class=\"box-header\"><svg width=\"20\" height=\"20\" viewbox=\"0 0 24 24\" fill=\"none\"><mask id=\"mask-green\" style=\"mask-type:alpha\" maskunits=\"userSpaceOnUse\" x=\"0\" y=\"0\" width=\"24\" height=\"24\"><rect width=\"24\" height=\"24\" fill=\"#D9D9D9\"><\/rect><\/mask><g mask=\"url(#mask-green)\"><path d=\"M5 21.0001C4.45 21.0001 3.97917 20.8043 3.5875 20.4126C3.19583 20.0209 3 19.5501 3 19.0001V5.0001C3 4.4501 3.19583 3.97926 3.5875 3.5876C3.97917 3.19593 4.45 3.0001 5 3.0001H13.925L11.925 5.0001H5V19.0001H19V12.0501L21 10.0501V19.0001C21 19.5501 20.8042 20.0209 20.4125 20.4126C20.0208 20.8043 19.55 21.0001 19 21.0001H5ZM9 15.0001V10.7501L18.175 1.5751C18.375 1.3751 18.6 1.2251 18.85 1.1251C19.1 1.0251 19.35 0.975098 19.6 0.975098C19.8667 0.975098 20.1208 1.0251 20.3625 1.1251C20.6042 1.2251 20.825 1.3751 21.025 1.5751L22.425 3.0001C22.6083 3.2001 22.75 3.42093 22.85 3.6626C22.95 3.90426 23 4.1501 23 4.4001C23 4.6501 22.9542 4.89593 22.8625 5.1376C22.7708 5.37926 22.625 5.6001 22.425 5.8001L13.25 15.0001H9ZM11 13.0001H12.4L18.2 7.2001L17.5 6.5001L16.775 5.8001L11 11.5751V13.0001Z\" fill=\"#4CAF50\"><\/path><\/g><\/svg><span class=\"box-label\">Nota<\/span><\/div><div class=\"box-content\">\n<p>Voc\u00ea s\u00f3 pode exportar um relat\u00f3rio para CSV\/Excel se estiver em per\u00edodo de teste gratuito ou inscrito no plano Basic ou superior. Para usu\u00e1rios do plano gratuito, a exporta\u00e7\u00e3o de relat\u00f3rios est\u00e1 dispon\u00edvel apenas em PDF.<\/p>\n<\/div><\/div>\n\n\n<div class=\"wp-block-image\">\n<figure class=\"aligncenter\"><a href=\"https:\/\/docs.google.com\/spreadsheets\/d\/1c7oG8zhIUYcFre8GWg39xjJNiyPjqS88igXcn9FpuQM\/edit#gid=1624600682\"><img loading=\"lazy\" decoding=\"async\" width=\"752\" height=\"458\" src=\"https:\/\/clockify.me\/help\/wp-content\/uploads\/2019\/08\/pivot-report.png\" alt=\"pivot report\" class=\"wp-image-3010\" srcset=\"https:\/\/clockify.me\/help\/wp-content\/uploads\/2019\/08\/pivot-report.png 752w, https:\/\/clockify.me\/help\/wp-content\/uploads\/2019\/08\/pivot-report-300x183.png 300w, https:\/\/clockify.me\/help\/wp-content\/uploads\/2019\/08\/pivot-report-60x37.png 60w, https:\/\/clockify.me\/help\/wp-content\/uploads\/2019\/08\/pivot-report-150x91.png 150w\" sizes=\"auto, (max-width: 752px) 100vw, 752px\" \/><\/a><\/figure>\n<\/div>\n\n\n<p><a href=\"https:\/\/docs.google.com\/spreadsheets\/d\/1c7oG8zhIUYcFre8GWg39xjJNiyPjqS88igXcn9FpuQM\/edit#gid=1124667396\" target=\"_blank\" rel=\"noreferrer noopener\" aria-label=\" cron\u00f4metro  espa\u00e7o de trabalho\">Veja um exemplo (Planilhas Google)<\/a><\/p>\n\n\n\n<h2 class=\"wp-block-heading\">Como criar um relat\u00f3rio personalizado<\/h2>\n\n\n\n<p>Crie um relat\u00f3rio personalizado da seguinte maneira:<\/p>\n\n\n\n<ol class=\"wp-block-list\">\n<li>Exporte o Relat\u00f3rio detalhado do Clockify em CSV ou Excel e abra-o na Planilha Google ou no Excel<\/li>\n\n\n\n<li>Selecione toda a tabela<\/li>\n\n\n\n<li>Excel: v\u00e1 em Inserir&gt; Tabela Din\u00e2mica; Planilhas Google: v\u00e1 para Inserir &gt; Tabela Din\u00e2mica<\/li>\n\n\n\n<li>Clique em OK<\/li>\n\n\n\n<li>Escolha quais campos mostrar em linhas\/colunas e o que exibir como valores. Exemplo: \u201cLinha: Projeto\u201d, \u201cColuna: Usu\u00e1rio\u201d, \u201cValor: Dura\u00e7\u00e3o (decimal)\u201d<\/li>\n<\/ol>\n\n\n\n<h2 class=\"wp-block-heading\">Adicionando dimens\u00f5es adicionais<\/h2>\n\n\n\n<p>Voc\u00ea pode enriquecer os relat\u00f3rios usando <a href=\"https:\/\/clockify.me\/help\/track-time-and-expenses\/custom-fields\" target=\"_blank\" rel=\"noreferrer noopener\">campos personalizados<\/a> as entradas de tempo. Seus usu\u00e1rios podem rastrear todos os tipos de coisas, como despesas, quilometragem, unidades, etc.&nbsp;<\/p>\n\n\n\n<p>Tamb\u00e9m pode adicionar metadados \u00e0s entradas de tempo usando campos personalizados em projetos. Dessa forma, voc\u00ea ter\u00e1 mais op\u00e7\u00f5es para agrupar o tempo em tabelas din\u00e2micas.<\/p>\n\n\n\n<p class=\"has-text-align-center translation-block\"><a href=\"https:\/\/clockify.me\/downloads\/samples\/report-detailed-sample-custom-fields.xlsx\" target=\"_blank\" rel=\"noreferrer noopener\" aria-label=\" (opens in a new tab)\">\nBaixe um exemplo de relat\u00f3rio com campos personalizados (Excel)\n<\/a><\/p>\n\n\n\n<figure class=\"wp-block-image size-large\"><img loading=\"lazy\" decoding=\"async\" width=\"738\" height=\"624\" src=\"https:\/\/clockify.me\/help\/wp-content\/uploads\/2020\/02\/detailed-report-pivot-custom-fields-3.png\" alt=\"\" class=\"wp-image-4449\" srcset=\"https:\/\/clockify.me\/help\/wp-content\/uploads\/2020\/02\/detailed-report-pivot-custom-fields-3.png 738w, https:\/\/clockify.me\/help\/wp-content\/uploads\/2020\/02\/detailed-report-pivot-custom-fields-3-300x254.png 300w, https:\/\/clockify.me\/help\/wp-content\/uploads\/2020\/02\/detailed-report-pivot-custom-fields-3-60x51.png 60w, https:\/\/clockify.me\/help\/wp-content\/uploads\/2020\/02\/detailed-report-pivot-custom-fields-3-150x127.png 150w\" sizes=\"auto, (max-width: 738px) 100vw, 738px\" \/><\/figure>\n\n\n\n<h2 class=\"wp-block-heading\">Como encontrar entradas sobrepostas<\/h2>\n\n\n\n<p>Se voc\u00ea tiver entradas com horas de in\u00edcio e t\u00e9rmino sobrepostas, poder\u00e1 encontr\u00e1-las facilmente no Excel ou nas Planilhas Google.<\/p>\n\n\n\n<ol class=\"wp-block-list\">\n<li>Exporte o relat\u00f3rio detalhado do Clockify em CSV<\/li>\n\n\n\n<li>Abra CSV no Excel\/Planilhas Google<\/li>\n\n\n\n<li>Selecione todos os dados e classifique-os por: Usu\u00e1rio&gt;Data de in\u00edcio&gt;Hora de in\u00edcio<\/li>\n\n\n\n<li class=\"translation-block\">Crie uma nova coluna de  <strong>sobreposi\u00e7\u00e3o<\/strong><\/li>\n\n\n\n<li>Para o primeiro registro, use esta f\u00f3rmula: =IF(OR(IF($F1=$F2, IF($I2=$I1, IF($L1&gt;$J2, verdadeiro, falso))),IF($F2=$F3, IF($I2=$I3, IF($L2&gt;$J3, verdadeiro, falso)))),\u201dsobreposi\u00e7\u00e3o\u201d, \u201cok\u201d)<\/li>\n\n\n\n<li>Expanda e aplique a f\u00f3rmula para cada linha<\/li>\n\n\n\n<li>Aplique a formata\u00e7\u00e3o condicional para destacar entradas de tempo sobrepostas<\/li>\n\n\n\n<li>Crie tabela din\u00e2mica com base nos dados da tabela<\/li>\n\n\n\n<li>Selecione na tabela din\u00e2mica: <strong>Linha: Sobreposi\u00e7\u00e3o<\/strong>, <strong>Valor:Sobreposi\u00e7\u00e3o (contagem)<\/strong><\/li>\n\n\n\n<li>Clique na contagem de sobreposi\u00e7\u00e3o para ver apenas as entradas sobrepostas em uma nova planilha<\/li>\n<\/ol>\n\n\n\n<p>Como funciona a f\u00f3rmula: Depois que todas as entradas s\u00e3o classificadas, a f\u00f3rmula compara a linha anterior e a seguinte. Se as linhas forem do mesmo usu\u00e1rio e da mesma data, ele verifica se o hor\u00e1rio de in\u00edcio da entrada se sobrep\u00f5e ao hor\u00e1rio de t\u00e9rmino da entrada anterior ou se o hor\u00e1rio de t\u00e9rmino se sobrep\u00f5e ao hor\u00e1rio de in\u00edcio da pr\u00f3xima entrada.<\/p>\n\n\n\n<p class=\"has-text-align-center\"> <a href=\"https:\/\/docs.google.com\/spreadsheets\/d\/1c7oG8zhIUYcFre8GWg39xjJNiyPjqS88igXcn9FpuQM\/edit#gid=2085526633\" target=\"_blank\" rel=\"noreferrer noopener\" aria-label=\" cron\u00f4metro  espa\u00e7o de trabalho\">Veja o exemplo de entradas sobrepostas (Planilhas Google)<\/a> <\/p>\n\n\n\n<figure class=\"wp-block-image\"><a href=\"https:\/\/docs.google.com\/spreadsheets\/d\/1c7oG8zhIUYcFre8GWg39xjJNiyPjqS88igXcn9FpuQM\/edit#gid=2085526633\"><img loading=\"lazy\" decoding=\"async\" width=\"720\" height=\"294\" src=\"https:\/\/clockify.me\/help\/wp-content\/uploads\/2019\/08\/overlapping-entries-min.png\" alt=\"overlapping entries\" class=\"wp-image-3023\" srcset=\"https:\/\/clockify.me\/help\/wp-content\/uploads\/2019\/08\/overlapping-entries-min.png 720w, https:\/\/clockify.me\/help\/wp-content\/uploads\/2019\/08\/overlapping-entries-min-300x123.png 300w, https:\/\/clockify.me\/help\/wp-content\/uploads\/2019\/08\/overlapping-entries-min-60x25.png 60w, https:\/\/clockify.me\/help\/wp-content\/uploads\/2019\/08\/overlapping-entries-min-150x61.png 150w\" sizes=\"auto, (max-width: 720px) 100vw, 720px\" \/><\/a><\/figure>\n\n\n\n<div class=\"wp-block-group related-articles\"><div class=\"wp-block-group__inner-container is-layout-constrained wp-block-group-is-layout-constrained\">\n<h3 class=\"wp-block-heading\">Artigos relacionados<\/h3>\n\n\n\n<ul class=\"wp-block-list related-articles-list\">\n<li class=\"translation-block\"><a href=\"https:\/\/clockify.me\/help\/pt\/reports\/customize-exports\">Personalizar exporta\u00e7\u00f5es de relat\u00f3rios<\/a><\/li>\n<\/ul>\n<\/div><\/div>","protected":false},"excerpt":{"rendered":"If Clockify&#8217;s built-in reports and customization options don&#8217;t provi&#8230;","protected":false},"author":3,"featured_media":0,"comment_status":"closed","ping_status":"closed","sticky":false,"template":"","format":"standard","meta":{"_acf_changed":false,"_helpful_status":1,"_searchwp_excluded":"","footnotes":""},"categories":[26],"tags":[],"class_list":["post-2986","post","type-post","status-publish","format-standard","hentry","category-manage-reports"],"acf":[],"featured_image_src":null,"author_info":{"display_name":"aleksandar.olic","author_link":"https:\/\/clockify.me\/help\/pt\/author\/aleksandar-olic"},"_links":{"self":[{"href":"https:\/\/clockify.me\/help\/pt\/wp-json\/wp\/v2\/posts\/2986","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/clockify.me\/help\/pt\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/clockify.me\/help\/pt\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/clockify.me\/help\/pt\/wp-json\/wp\/v2\/users\/3"}],"replies":[{"embeddable":true,"href":"https:\/\/clockify.me\/help\/pt\/wp-json\/wp\/v2\/comments?post=2986"}],"version-history":[{"count":45,"href":"https:\/\/clockify.me\/help\/pt\/wp-json\/wp\/v2\/posts\/2986\/revisions"}],"predecessor-version":[{"id":30901,"href":"https:\/\/clockify.me\/help\/pt\/wp-json\/wp\/v2\/posts\/2986\/revisions\/30901"}],"wp:attachment":[{"href":"https:\/\/clockify.me\/help\/pt\/wp-json\/wp\/v2\/media?parent=2986"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/clockify.me\/help\/pt\/wp-json\/wp\/v2\/categories?post=2986"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/clockify.me\/help\/pt\/wp-json\/wp\/v2\/tags?post=2986"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}