{"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\/fr\/reports\/creating-custom-reports","title":{"rendered":"Personnaliser les rapports"},"content":{"rendered":"<p>Si les rapports int\u00e9gr\u00e9s et les <a href=\"https:\/\/clockify.me\/help\/reports\/customize-exports\">options de personnalisation<\/a> de  Clockify ne fournissent pas la structure dont vous avez besoin, cr\u00e9ez votre propre rapport en utilisant des tableaux crois\u00e9s.<\/p>\n\n\n\n<p>Il suffit d'exporter les rapports d\u00e9taill\u00e9s au format CSV ou Excel, et vous pouvez cr\u00e9er le type de rapport que vous souhaitez :<\/p>\n\n\n\n<ul class=\"wp-block-list\">\n<li>Heures totales (ou montant) ventil\u00e9es par client &gt; projet &gt; t\u00e2che &gt; description<\/li>\n\n\n\n<li>Rapport mensuel avec le nombre total d'heures (ou le montant) par projet (ou utilisateur) et par jour<\/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\">Remarque<\/span><\/div><div class=\"box-content\">\n<p>You can only export a report to CSV\/Excel if you are on Free trial or subscribed to the Basic plan or higher. For Free plan subscribers, you can only export a report to 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=\" (opens in a new tab)\">Voir un exemple (Google Sheets)<\/a><\/p>\n\n\n\n<h2 class=\"wp-block-heading\">Cr\u00e9er un rapport personnalis\u00e9<\/h2>\n\n\n\n<p>Create a custom report in the following way:<\/p>\n\n\n\n<ol class=\"wp-block-list\">\n<li>Exportez le rapport d\u00e9taill\u00e9 de Clockify en CSV ou Excel et ouvrez-le dans Google Sheets ou Excel<\/li>\n\n\n\n<li>S\u00e9lectionnez le tableau entier<\/li>\n\n\n\n<li>Excel : allez dans Insertion &gt; Tableau crois\u00e9 dynamique ; Google Sheets : allez dans Insertion &gt; Tableau crois\u00e9 dynamique<\/li>\n\n\n\n<li>Cliquez sur OK<\/li>\n\n\n\n<li>Choisissez les champs \u00e0 afficher en lignes\/colonnes, et ce qui doit \u00eatre affich\u00e9 comme valeurs. Exemple : \"Ligne : Projet\", \"Colonne : Utilisateur\", \"Valeur : Dur\u00e9e (d\u00e9cimale)\"<\/li>\n<\/ol>\n\n\n\n<h2 class=\"wp-block-heading\">Dimensions suppl\u00e9mentaires<\/h2>\n\n\n\n<p>Vous pouvez enrichir les rapports en utilisant des <a href=\"https:\/\/clockify.me\/help\/track-time-and-expenses\/custom-fields\" target=\"_blank\" rel=\"noreferrer noopener\">champs personnalis\u00e9s<\/a> sur les entr\u00e9es de temps. Vos utilisateurs peuvent suivre toutes sortes de choses, comme les d\u00e9penses, le kilom\u00e9trage, les unit\u00e9s, etc.&nbsp;<\/p>\n\n\n\n<p>Vous pouvez \u00e9galement ajouter des m\u00e9tadonn\u00e9es aux entr\u00e9es de temps en utilisant des champs personnalis\u00e9s sur les projets. De cette fa\u00e7on, vous aurez plus d'options pour regrouper le temps dans les tableaux crois\u00e9s dynamiques.<\/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)\">T\u00e9l\u00e9chargez un exemple de rapport avec des champs personnalis\u00e9s (Excel)<\/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\">Chevauchement d'entr\u00e9es<\/h2>\n\n\n\n<p>Si vous avez des entr\u00e9es dont les heures de d\u00e9but et de fin se chevauchent, vous pouvez facilement les retrouver dans Excel ou Google Sheets.<\/p>\n\n\n\n<ol class=\"wp-block-list\">\n<li>Exportez le rapport d\u00e9taill\u00e9 de Clockify en CSV<\/li>\n\n\n\n<li>Ouvrez le CSV dans Excel\/Google Sheets<\/li>\n\n\n\n<li>S\u00e9lectionnez toutes les donn\u00e9es et triez-les par : Utilisateur&gt;Date de d\u00e9but&gt;Heure de d\u00e9but<\/li>\n\n\n\n<li class=\"translation-block\">Cr\u00e9ez une nouvelle colonne <strong>Chevauchement<\/strong><\/li>\n\n\n\n<li>Pour le premier enregistrement, utilisez cette formule : =IF(OR(IF($F1=$F2, IF($I2=$I1, IF($L1&gt;$J2, true, false)),IF($F2=$F3, IF($I2=$I3, IF($L2&gt;$J3, true, false)))), \"overlap\", \"ok\")<\/li>\n\n\n\n<li>D\u00e9veloppez et appliquez la formule pour chaque ligne<\/li>\n\n\n\n<li>Appliquez la mise en forme conditionnelle pour mettre en \u00e9vidence les entr\u00e9es de temps qui se chevauchent<\/li>\n\n\n\n<li>Cr\u00e9ez un tableau crois\u00e9 dynamique \u00e0 partir des donn\u00e9es du tableau<\/li>\n\n\n\n<li>Dans le tableau crois\u00e9 dynamique, s\u00e9lectionnez : <strong>Ligne : Chevauchement<\/strong>, <strong>Valeur : Chevauchement (nombre)<\/strong><\/li>\n\n\n\n<li>Cliquez sur le nombre de chevauchements pour afficher uniquement les entr\u00e9es qui se chevauchent dans une nouvelle feuille<\/li>\n<\/ol>\n\n\n\n<p>Comment fonctionne la formule : Une fois que toutes les entr\u00e9es sont tri\u00e9es, la formule compare la ligne pr\u00e9c\u00e9dente et la suivante. Si les lignes proviennent du m\u00eame utilisateur et de la m\u00eame date, elle regarde si l'heure de d\u00e9but de l'entr\u00e9e chevauche l'heure de fin de l'entr\u00e9e pr\u00e9c\u00e9dente ou si son heure de fin chevauche l'heure de d\u00e9but de l'entr\u00e9e suivante.<\/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=\" (opens in a new tab)\">Voir un exemple de chevauchement des entr\u00e9es (Google Sheets)<\/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\">Articles similaires<\/h3>\n\n\n\n<ul class=\"wp-block-list related-articles-list\">\n<li class=\"translation-block\"><a href=\"https:\/\/clockify.me\/help\/fr\/reports\/customize-exports\">Personnaliser les exportations de rapports<\/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\/fr\/author\/aleksandar-olic"},"_links":{"self":[{"href":"https:\/\/clockify.me\/help\/fr\/wp-json\/wp\/v2\/posts\/2986","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/clockify.me\/help\/fr\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/clockify.me\/help\/fr\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/clockify.me\/help\/fr\/wp-json\/wp\/v2\/users\/3"}],"replies":[{"embeddable":true,"href":"https:\/\/clockify.me\/help\/fr\/wp-json\/wp\/v2\/comments?post=2986"}],"version-history":[{"count":45,"href":"https:\/\/clockify.me\/help\/fr\/wp-json\/wp\/v2\/posts\/2986\/revisions"}],"predecessor-version":[{"id":30901,"href":"https:\/\/clockify.me\/help\/fr\/wp-json\/wp\/v2\/posts\/2986\/revisions\/30901"}],"wp:attachment":[{"href":"https:\/\/clockify.me\/help\/fr\/wp-json\/wp\/v2\/media?parent=2986"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/clockify.me\/help\/fr\/wp-json\/wp\/v2\/categories?post=2986"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/clockify.me\/help\/fr\/wp-json\/wp\/v2\/tags?post=2986"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}