{"id":408,"date":"2016-07-12T11:39:51","date_gmt":"2016-07-12T10:39:51","guid":{"rendered":"https:\/\/app.lib.uliege.be\/alma\/?p=408"},"modified":"2016-09-15T09:29:18","modified_gmt":"2016-09-15T08:29:18","slug":"ajouter-un-filtre-sur-un-sous-total","status":"publish","type":"post","link":"https:\/\/services.lib.uliege.be\/alma\/ajouter-un-filtre-sur-un-sous-total\/","title":{"rendered":"Ajouter un filtre sur un sous-total"},"content":{"rendered":"<p>Ce tutoriel nous explique comment, dans un rapport contenant des sous-totaux, cr\u00e9er un filtre qui porte sur le sous-total plut\u00f4t que sur chaque valeur de mani\u00e8re individuelle.<\/p>\n<p>Exemple : un rapport qui afficherait des lecteurs hors ULg avec <u><b>au <\/b><\/u><u><b>moins<\/b><\/u><u><b> 3 <\/b><\/u><u><b>pr\u00eats<\/b><\/u> <u><b>en<\/b><\/u><u><b> retard<\/b><\/u> (due date = J-1) et ce, que leur statut soit NORMAL, RECALL, RENEW mais pas LOST.<\/p>\n<p><img loading=\"lazy\" decoding=\"async\" class=\"wp-image-1270 size-large aligncenter\" src=\"https:\/\/services.lib.uliege.be\/alma\/wp-content\/uploads\/2016\/09\/01-filtre-loan_censored-flouter-1024x576.jpg\" alt=\"01-filtre-loan_censored-flouter\" width=\"800\" height=\"450\" srcset=\"https:\/\/services.lib.uliege.be\/alma\/wp-content\/uploads\/2016\/09\/01-filtre-loan_censored-flouter-1024x576.jpg 1024w, https:\/\/services.lib.uliege.be\/alma\/wp-content\/uploads\/2016\/09\/01-filtre-loan_censored-flouter-300x169.jpg 300w, https:\/\/services.lib.uliege.be\/alma\/wp-content\/uploads\/2016\/09\/01-filtre-loan_censored-flouter-768x432.jpg 768w, https:\/\/services.lib.uliege.be\/alma\/wp-content\/uploads\/2016\/09\/01-filtre-loan_censored-flouter.jpg 1280w\" sizes=\"auto, (max-width: 800px) 100vw, 800px\" \/><\/p>\n<p>&nbsp;<\/p>\n<p>Seules les valeurs sup\u00e9rieures \u00e0 3 pour chaque statut de pr\u00eat sont conserv\u00e9es. Un lecteur qui aurait 1 pr\u00eat RENEW en retard et 2 pr\u00eats NORMAL en retard n&rsquo;appara\u00eetra pas ici. \u00c7a ne correspond donc pas au r\u00e9sultat souhait\u00e9.<\/p>\n<ul>\n<li>La solution est d\u2019utiliser un filtre au niveau de la table. Pour cela, faire un clic droit sur la colonne \u201cPrimary Identifier\u201d &gt; Keep Only &gt; Members where Loans is greather than &gt; Value = 2<\/li>\n<\/ul>\n<p><img loading=\"lazy\" decoding=\"async\" class=\"wp-image-1271 size-large aligncenter\" src=\"https:\/\/services.lib.uliege.be\/alma\/wp-content\/uploads\/2016\/09\/02-filtre-loan_censored-flouter-1024x576.jpg\" alt=\"02-filtre-loan_censored-flouter\" width=\"800\" height=\"450\" srcset=\"https:\/\/services.lib.uliege.be\/alma\/wp-content\/uploads\/2016\/09\/02-filtre-loan_censored-flouter-1024x576.jpg 1024w, https:\/\/services.lib.uliege.be\/alma\/wp-content\/uploads\/2016\/09\/02-filtre-loan_censored-flouter-300x169.jpg 300w, https:\/\/services.lib.uliege.be\/alma\/wp-content\/uploads\/2016\/09\/02-filtre-loan_censored-flouter-768x432.jpg 768w, https:\/\/services.lib.uliege.be\/alma\/wp-content\/uploads\/2016\/09\/02-filtre-loan_censored-flouter.jpg 1280w\" sizes=\"auto, (max-width: 800px) 100vw, 800px\" \/>Le r\u00e9sultat reprend bien des lecteurs qui ont au moins 3 LOST au total (m\u00eame s\u2019il n\u2019y en a qu\u2019un par statut).<\/p>\n<p><img loading=\"lazy\" decoding=\"async\" class=\"wp-image-1272 size-large aligncenter\" src=\"https:\/\/services.lib.uliege.be\/alma\/wp-content\/uploads\/2016\/09\/03-filtre-loan_censoredfloute-1024x576.jpg\" alt=\"03-filtre-loan_censoredfloute\" width=\"800\" height=\"450\" srcset=\"https:\/\/services.lib.uliege.be\/alma\/wp-content\/uploads\/2016\/09\/03-filtre-loan_censoredfloute-1024x576.jpg 1024w, https:\/\/services.lib.uliege.be\/alma\/wp-content\/uploads\/2016\/09\/03-filtre-loan_censoredfloute-300x169.jpg 300w, https:\/\/services.lib.uliege.be\/alma\/wp-content\/uploads\/2016\/09\/03-filtre-loan_censoredfloute-768x432.jpg 768w, https:\/\/services.lib.uliege.be\/alma\/wp-content\/uploads\/2016\/09\/03-filtre-loan_censoredfloute.jpg 1280w\" sizes=\"auto, (max-width: 800px) 100vw, 800px\" \/>Ceci fait, il est possible d\u2019annuler ou de modifier cette op\u00e9ration via l\u2019onglet \u201cSelection Steps\u201d situ\u00e9 tout en bas de la vue qui affiche la table.<\/p>\n<p><img loading=\"lazy\" decoding=\"async\" class=\"wp-image-1273 size-large aligncenter\" src=\"https:\/\/services.lib.uliege.be\/alma\/wp-content\/uploads\/2016\/09\/04-filtre-loan_censored-flouter-1024x576.jpg\" alt=\"04-filtre-loan_censored-flouter\" width=\"800\" height=\"450\" srcset=\"https:\/\/services.lib.uliege.be\/alma\/wp-content\/uploads\/2016\/09\/04-filtre-loan_censored-flouter-1024x576.jpg 1024w, https:\/\/services.lib.uliege.be\/alma\/wp-content\/uploads\/2016\/09\/04-filtre-loan_censored-flouter-300x169.jpg 300w, https:\/\/services.lib.uliege.be\/alma\/wp-content\/uploads\/2016\/09\/04-filtre-loan_censored-flouter-768x432.jpg 768w, https:\/\/services.lib.uliege.be\/alma\/wp-content\/uploads\/2016\/09\/04-filtre-loan_censored-flouter.jpg 1280w\" sizes=\"auto, (max-width: 800px) 100vw, 800px\" \/><\/p>\n","protected":false},"excerpt":{"rendered":"<p>Ce tutoriel nous explique comment, dans un rapport contenant des sous-totaux, cr\u00e9er un filtre qui porte sur le sous-total plut\u00f4t que sur chaque valeur de mani\u00e8re individuelle. Exemple : un rapport qui afficherait des lecteurs hors ULg avec au moins 3 pr\u00eats en retard (due date = J-1) et ce,&#8230; <a href=\"https:\/\/services.lib.uliege.be\/alma\/ajouter-un-filtre-sur-un-sous-total\/\" class=\"readmore\">Lire l&#039;int\u00e9gralit\u00e9&#8230;<span class=\"screen-reader-text\">Ajouter un filtre sur un sous-total<\/span><span class=\"fa fa-angle-double-right\" aria-hidden=\"true\"><\/span><\/a><\/p>\n","protected":false},"author":4,"featured_media":0,"comment_status":"closed","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"jetpack_post_was_ever_published":false,"_jetpack_newsletter_access":"","_jetpack_dont_email_post_to_subs":true,"_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}},"categories":[3],"tags":[54,46],"class_list":["post-408","post","type-post","status-publish","format-standard","hentry","category-analytics","tag-filtres","tag-sous-total","content-layout-excerpt-thumb"],"jetpack_publicize_connections":[],"jetpack_featured_media_url":"","jetpack_sharing_enabled":true,"jetpack_shortlink":"https:\/\/wp.me\/p7rJUv-6A","_links":{"self":[{"href":"https:\/\/services.lib.uliege.be\/alma\/wp-json\/wp\/v2\/posts\/408","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\/4"}],"replies":[{"embeddable":true,"href":"https:\/\/services.lib.uliege.be\/alma\/wp-json\/wp\/v2\/comments?post=408"}],"version-history":[{"count":14,"href":"https:\/\/services.lib.uliege.be\/alma\/wp-json\/wp\/v2\/posts\/408\/revisions"}],"predecessor-version":[{"id":1274,"href":"https:\/\/services.lib.uliege.be\/alma\/wp-json\/wp\/v2\/posts\/408\/revisions\/1274"}],"wp:attachment":[{"href":"https:\/\/services.lib.uliege.be\/alma\/wp-json\/wp\/v2\/media?parent=408"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/services.lib.uliege.be\/alma\/wp-json\/wp\/v2\/categories?post=408"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/services.lib.uliege.be\/alma\/wp-json\/wp\/v2\/tags?post=408"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}