{"id":7251,"date":"2026-05-06T13:32:02","date_gmt":"2026-05-06T11:32:02","guid":{"rendered":"https:\/\/services.lib.uliege.be\/alma\/?p=7251"},"modified":"2026-05-06T13:34:15","modified_gmt":"2026-05-06T11:34:15","slug":"afficher-ou-filtrer-les-jours-de-la-semaine-dans-un-rapport-analytique","status":"publish","type":"post","link":"https:\/\/services.lib.uliege.be\/alma\/afficher-ou-filtrer-les-jours-de-la-semaine-dans-un-rapport-analytique\/","title":{"rendered":"Afficher ou filtrer les jours de la semaine dans un rapport analytique"},"content":{"rendered":"\n<p class=\"wp-block-paragraph\">Par d\u00e9faut, Alma Analytics ne propose pas de champ permettant de sp\u00e9cifier un ou plusieurs jour(s) de la semaine. Voici comment contourner cette limitation.<\/p>\n\n\n\n<p class=\"wp-block-paragraph\">Utiliser le champ \u00ab\u00a0date\u00a0\u00bb correspondant \u00e0 vos besoins (ex : Loan Date, Transaction Date, Portfolio Activation Date\u2026)<\/p>\n\n\n\n<p class=\"wp-block-paragraph\">Depuis l&rsquo;onglet \u00ab\u00a0Criteria\u00a0\u00bb, cliquer sur le rouage en regard de la colonne et cliquer sur \u00ab\u00a0Edit Formula\u00a0\u00bb<\/p>\n\n\n\n<figure class=\"wp-block-image size-full is-resized\"><img loading=\"lazy\" decoding=\"async\" width=\"768\" height=\"314\" src=\"https:\/\/services.lib.uliege.be\/alma\/wp-content\/uploads\/2026\/05\/dayof1.png\" alt=\"\" class=\"wp-image-7256\" style=\"width:708px;height:auto\" srcset=\"https:\/\/services.lib.uliege.be\/alma\/wp-content\/uploads\/2026\/05\/dayof1.png 768w, https:\/\/services.lib.uliege.be\/alma\/wp-content\/uploads\/2026\/05\/dayof1-300x123.png 300w\" sizes=\"auto, (max-width: 768px) 100vw, 768px\" \/><\/figure>\n\n\n\n<p class=\"wp-block-paragraph\"><\/p>\n\n\n\n<p class=\"wp-block-paragraph\">Puis s&rsquo;assurer que la formule soit bien s\u00e9lectionn\u00e9e et cliquer sur Fonctions \u00ab\u00a0f(\u2026)\u00a0\u00bb<\/p>\n\n\n\n<figure class=\"wp-block-image size-full is-resized\"><img loading=\"lazy\" decoding=\"async\" width=\"938\" height=\"641\" src=\"https:\/\/services.lib.uliege.be\/alma\/wp-content\/uploads\/2026\/05\/dayof2.png\" alt=\"\" class=\"wp-image-7257\" style=\"aspect-ratio:1.4633296763984798;width:743px;height:auto\" srcset=\"https:\/\/services.lib.uliege.be\/alma\/wp-content\/uploads\/2026\/05\/dayof2.png 938w, https:\/\/services.lib.uliege.be\/alma\/wp-content\/uploads\/2026\/05\/dayof2-300x205.png 300w, https:\/\/services.lib.uliege.be\/alma\/wp-content\/uploads\/2026\/05\/dayof2-768x525.png 768w\" sizes=\"auto, (max-width: 938px) 100vw, 938px\" \/><\/figure>\n\n\n\n<p class=\"wp-block-paragraph\">Dans le menu \u00ab\u00a0Functions\u00a0\u00bb &gt; Calendar\/Date &gt; s\u00e9lectionner, selon votre besoin, DayOfWeek ou DayName puis cliquer sur Ok.<\/p>\n\n\n\n<figure class=\"wp-block-image size-full is-resized\"><img loading=\"lazy\" decoding=\"async\" width=\"615\" height=\"581\" src=\"https:\/\/services.lib.uliege.be\/alma\/wp-content\/uploads\/2026\/05\/dayof3.png\" alt=\"\" class=\"wp-image-7258\" style=\"width:459px;height:auto\" srcset=\"https:\/\/services.lib.uliege.be\/alma\/wp-content\/uploads\/2026\/05\/dayof3.png 615w, https:\/\/services.lib.uliege.be\/alma\/wp-content\/uploads\/2026\/05\/dayof3-300x283.png 300w\" sizes=\"auto, (max-width: 615px) 100vw, 615px\" \/><\/figure>\n\n\n\n<p class=\"wp-block-paragraph\">La formule \u00abLoan Date\u00bb.\u00abLoan Date\u00bb a \u00e9t\u00e9 modifi\u00e9e en DAYNAME(\u00abLoan Date\u00bb.\u00abLoan Date\u00bb) ou DAYOFWEEK(\u00abLoan Date\u00bb.\u00abLoan Date\u00bb).<\/p>\n\n\n\n<figure class=\"wp-block-image size-full is-resized\"><img loading=\"lazy\" decoding=\"async\" width=\"542\" height=\"156\" src=\"https:\/\/services.lib.uliege.be\/alma\/wp-content\/uploads\/2026\/05\/dayof4.png\" alt=\"\" class=\"wp-image-7259\" style=\"width:459px;height:auto\" srcset=\"https:\/\/services.lib.uliege.be\/alma\/wp-content\/uploads\/2026\/05\/dayof4.png 542w, https:\/\/services.lib.uliege.be\/alma\/wp-content\/uploads\/2026\/05\/dayof4-300x86.png 300w\" sizes=\"auto, (max-width: 542px) 100vw, 542px\" \/><\/figure>\n\n\n\n<p class=\"wp-block-paragraph\"><\/p>\n\n\n\n<p class=\"wp-block-paragraph\">Pour information :<\/p>\n\n\n\n<ul class=\"wp-block-list\">\n<li>DAYOFWEEK converti les jours de la semaine en valeurs num\u00e9riques (lundi = 1, mardi = 2&#8230;), ceci est utile notamment dans le cas de tri des donn\u00e9es. <\/li>\n\n\n\n<li>DAYNAME converti les jours de la semaine en valeurs textuelles (lundi = Mon, mardi = Tue&#8230;), utile pour l&rsquo;affichage des donn\u00e9es.<\/li>\n<\/ul>\n\n\n\n<p class=\"wp-block-paragraph\">Attention, par d\u00e9faut, Alma Analytics renseigne le dimanche comme \u00e9tant le premier jour de la semaine. Pour corriger cela, modifier la formule de la fa\u00e7on suivante. Ex : DAYOFWEEK(\u00abLoan Date\u00bb.\u00abLoan Date\u00bb) devient DAYOFWEEK(TIMESTAMPADD(SQL_TSI_DAY, -1,\u00abLoan Date\u00bb.\u00abLoan Date\u00bb)).<\/p>\n\n\n\n<p class=\"wp-block-paragraph\">Voici le r\u00e9sultat obtenu dans un tableau crois\u00e9 dynamique en ajoutant les deux informations, en ajoutant un tri croissant sur la colonne DAYOFWEEK(TIMESTAMPADD(SQL_TSI_DAY, -1,\u00abLoan Date\u00bb.\u00abLoan Date\u00bb)) puis en la masquant.<\/p>\n\n\n\n<figure class=\"wp-block-image size-full\"><img loading=\"lazy\" decoding=\"async\" width=\"444\" height=\"161\" src=\"https:\/\/services.lib.uliege.be\/alma\/wp-content\/uploads\/2026\/05\/dayof6.png\" alt=\"\" class=\"wp-image-7255\" srcset=\"https:\/\/services.lib.uliege.be\/alma\/wp-content\/uploads\/2026\/05\/dayof6.png 444w, https:\/\/services.lib.uliege.be\/alma\/wp-content\/uploads\/2026\/05\/dayof6-300x109.png 300w\" sizes=\"auto, (max-width: 444px) 100vw, 444px\" \/><\/figure>\n\n\n","protected":false},"excerpt":{"rendered":"<p>Par d\u00e9faut, Alma Analytics ne propose pas de champ permettant de sp\u00e9cifier un ou plusieurs jour(s) de la semaine. Voici comment contourner cette limitation. Utiliser le champ \u00ab\u00a0date\u00a0\u00bb correspondant \u00e0 vos besoins (ex : Loan Date, Transaction Date, Portfolio Activation Date\u2026) Depuis l&rsquo;onglet \u00ab\u00a0Criteria\u00a0\u00bb, cliquer sur le rouage en regard&#8230; <a href=\"https:\/\/services.lib.uliege.be\/alma\/afficher-ou-filtrer-les-jours-de-la-semaine-dans-un-rapport-analytique\/\" class=\"readmore\">Lire l&#039;int\u00e9gralit\u00e9&#8230;<span class=\"screen-reader-text\">Afficher ou filtrer les jours de la semaine dans un rapport analytique<\/span><span class=\"fa fa-angle-double-right\" aria-hidden=\"true\"><\/span><\/a><\/p>\n","protected":false},"author":9,"featured_media":0,"comment_status":"closed","ping_status":"closed","sticky":false,"template":"","format":"standard","meta":{"_jetpack_newsletter_access":"","_jetpack_dont_email_post_to_subs":false,"_jetpack_newsletter_tier_id":0,"_jetpack_memberships_contains_paywalled_content":false,"_jetpack_memberships_contains_paid_content":false,"footnotes":"","jetpack_publicize_message":"","jetpack_publicize_feature_enabled":true,"jetpack_social_post_already_shared":true,"jetpack_social_options":{"image_generator_settings":{"template":"highway","default_image_id":0,"font":"","enabled":false},"version":2},"jetpack_post_was_ever_published":false},"categories":[1],"tags":[],"class_list":["post-7251","post","type-post","status-publish","format-standard","hentry","category-non-classe","content-layout-excerpt-thumb"],"jetpack_publicize_connections":[],"jetpack_featured_media_url":"","jetpack_sharing_enabled":true,"jetpack_shortlink":"https:\/\/wp.me\/p7rJUv-1SX","_links":{"self":[{"href":"https:\/\/services.lib.uliege.be\/alma\/wp-json\/wp\/v2\/posts\/7251","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/services.lib.uliege.be\/alma\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/services.lib.uliege.be\/alma\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/services.lib.uliege.be\/alma\/wp-json\/wp\/v2\/users\/9"}],"replies":[{"embeddable":true,"href":"https:\/\/services.lib.uliege.be\/alma\/wp-json\/wp\/v2\/comments?post=7251"}],"version-history":[{"count":13,"href":"https:\/\/services.lib.uliege.be\/alma\/wp-json\/wp\/v2\/posts\/7251\/revisions"}],"predecessor-version":[{"id":7270,"href":"https:\/\/services.lib.uliege.be\/alma\/wp-json\/wp\/v2\/posts\/7251\/revisions\/7270"}],"wp:attachment":[{"href":"https:\/\/services.lib.uliege.be\/alma\/wp-json\/wp\/v2\/media?parent=7251"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/services.lib.uliege.be\/alma\/wp-json\/wp\/v2\/categories?post=7251"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/services.lib.uliege.be\/alma\/wp-json\/wp\/v2\/tags?post=7251"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}