Pour que Reportei interpr\u00e8te correctement la feuille, chaque colonne doit \u00eatre class\u00e9e comme Indicateur<\/strong>, Dimension<\/strong>, Date<\/strong> ou Dimension\/Indicateur<\/strong>. Cette classification d\u00e9termine les widgets disponibles : graphiques, indicateurs chiffr\u00e9s ou tableaux.<\/p>\n\n\n\n

Pourquoi un graphique n\u00e9cessite-t-il une dimension ?<\/strong><\/span><\/h2>\n\n\n\n

Un graphique compare des p\u00e9riodes, cat\u00e9gories, campagnes ou canaux. Il faut donc un \u00e9l\u00e9ment permettant de regrouper ou de r\u00e9partir les valeurs<\/strong>. C\u2019est le r\u00f4le d\u2019une dimension<\/strong>.

Sans dimension, les donn\u00e9es ne peuvent pas \u00eatre organis\u00e9es dans le graphique.<\/strong><\/p>\n\n\n\n

Un graphique doit pouvoir r\u00e9pondre \u00e0 des questions comme :<\/p>\n\n\n\n

\n
• \u00c0 quelle cat\u00e9gorie appartient chaque valeur ?<\/em><\/li>\n\n\n\n
• Comment l\u2019indicateur \u00e9volue-t-il dans le temps ?<\/em><\/li>\n\n\n\n
• Quelles sont les performances par campagne, canal ou mois ?
  <\/em><\/li>\n<\/ul>\n\n\n\n

  Il doit donc savoir comment regrouper les donn\u00e9es<\/strong>. Pour cela, il faut au moins une colonne class\u00e9e comme :<\/p>\n\n\n\n

  \n
  • Dimension<\/strong>,<\/li>\n\n\n\n
  • Dimension\/Indicateur<\/strong>, ou<\/li>\n\n\n\n
  • Date<\/strong> \u2014 qui sert de dimension temporelle.<\/li>\n<\/ul>\n\n\n\n

    <\/p>\n\n\n\n

    Pourquoi les widgets chiffr\u00e9s n\u00e9cessitent-ils un indicateur ?<\/span><\/h2>\n\n\n\n

    Ils affichent des valeurs calcul\u00e9es : somme, moyenne, total, nombre d\u2019\u00e9l\u00e9ments ou autres indicateurs.<\/p>\n\n\n\n

    Il leur faut donc une colonne contenant des valeurs num\u00e9riques, class\u00e9e comme Indicateur<\/strong> ou Dimension\/Indicateur<\/strong>.<\/p>\n\n\n\n

    Sans indicateur, il est impossible de :<\/p>\n\n\n\n

    \n
    • additionner les valeurs ;<\/li>\n\n\n\n
    • calculer des r\u00e9sultats ;<\/li>\n\n\n\n
    • afficher des totaux ou moyennes.
      <\/li>\n<\/ul>\n\n\n\n

      Si aucune colonne n\u2019est class\u00e9e comme indicateur, les widgets chiffr\u00e9s et les graphiques ne sont pas disponibles<\/strong> \u2014 les graphiques ayant eux aussi besoin de valeurs \u00e0 comparer. Dans ce cas, vous pouvez cr\u00e9er uniquement un Tableau<\/strong>.<\/p>\n\n\n\n

      ---

      \n\n\n\n

      R\u00e9capitulatif<\/strong><\/span><\/h4>\n\n\n\n

      \n
      • Sans dimension :<\/strong> aucun graphique ne peut \u00eatre cr\u00e9\u00e9.<\/li>\n\n\n\n
      • Sans indicateur :<\/strong> seuls les tableaux sont disponibles, sans chiffres de synth\u00e8se ni graphiques.<\/li>\n\n\n\n
      • Avec les deux :<\/strong> graphiques, indicateurs chiffr\u00e9s et tableaux sont disponibles.<\/li>\n<\/ul>\n\n\n\n

        ---

        \n\n\n\n

        Comment corriger la classification ?<\/strong><\/span><\/h3>\n\n\n\n

        Une fois le mappage des colonnes termin\u00e9, leur classification ne peut plus \u00eatre modifi\u00e9e.<\/p>\n\n\n\n

        Pour changer le type d\u2019une colonne et d\u00e9bloquer d\u2019autres widgets, vous devez supprimer l\u2019int\u00e9gration actuelle et la cr\u00e9er \u00e0 nouveau<\/strong>.<\/p>\n\n\n\n

        V\u00e9rifiez et classez soigneusement chaque colonne avant de terminer le nouveau mappage.<\/p>\n\n\n\n

        Notre assistance peut vous accompagner \u00e0 chaque \u00e9tape.<\/em><\/a><\/p>\n","protected":false},"excerpt":{"rendered":"

        Pour que Reportei interpr\u00e8te correctement la feuille, chaque colonne doit \u00eatre class\u00e9e comme Indicateur, Dimension, Date ou Dimension\/Indicateur. Cette classification d\u00e9termine les widgets disponibles : graphiques, indicateurs chiffr\u00e9s ou tableaux. Pourquoi un graphique n\u00e9cessite-t-il une dimension ? Un graphique compare des p\u00e9riodes, cat\u00e9gories, campagnes ou canaux. Il faut donc un \u00e9l\u00e9ment permettant de regrouper ou de r\u00e9partir les valeurs. C\u2019est […]<\/p>\n","protected":false},"author":5,"featured_media":0,"menu_order":0,"comment_status":"open","ping_status":"closed","template":"","format":"standard","meta":{"inline_featured_image":false,"site-sidebar-layout":"default","site-content-layout":"","ast-site-content-layout":"default","site-content-style":"default","site-sidebar-style":"default","ast-global-header-display":"","ast-banner-title-visibility":"","ast-main-header-display":"","ast-hfb-above-header-display":"","ast-hfb-below-header-display":"","ast-hfb-mobile-header-display":"","site-post-title":"","ast-breadcrumbs-content":"","ast-featured-img":"","footer-sml-layout":"","ast-disable-related-posts":"","theme-transparent-header-meta":"","adv-header-id-meta":"","stick-header-meta":"","header-above-stick-meta":"","header-main-stick-meta":"","header-below-stick-meta":"","astra-migrate-meta-layouts":"default","ast-page-background-enabled":"default","ast-page-background-meta":{"desktop":{"background-color":"var(--ast-global-color-4)","background-image":"","background-repeat":"repeat","background-position":"center center","background-size":"auto","background-attachment":"scroll","background-type":"","background-media":"","overlay-type":"","overlay-color":"","overlay-opacity":"","overlay-gradient":""},"tablet":{"background-color":"","background-image":"","background-repeat":"repeat","background-position":"center center","background-size":"auto","background-attachment":"scroll","background-type":"","background-media":"","overlay-type":"","overlay-color":"","overlay-opacity":"","overlay-gradient":""},"mobile":{"background-color":"","background-image":"","background-repeat":"repeat","background-position":"center center","background-size":"auto","background-attachment":"scroll","background-type":"","background-media":"","overlay-type":"","overlay-color":"","overlay-opacity":"","overlay-gradient":""}},"ast-content-background-meta":{"desktop":{"background-color":"var(--ast-global-color-5)","background-image":"","background-repeat":"repeat","background-position":"center center","background-size":"auto","background-attachment":"scroll","background-type":"","background-media":"","overlay-type":"","overlay-color":"","overlay-opacity":"","overlay-gradient":""},"tablet":{"background-color":"var(--ast-global-color-5)","background-image":"","background-repeat":"repeat","background-position":"center center","background-size":"auto","background-attachment":"scroll","background-type":"","background-media":"","overlay-type":"","overlay-color":"","overlay-opacity":"","overlay-gradient":""},"mobile":{"background-color":"var(--ast-global-color-5)","background-image":"","background-repeat":"repeat","background-position":"center center","background-size":"auto","background-attachment":"scroll","background-type":"","background-media":"","overlay-type":"","overlay-color":"","overlay-opacity":"","overlay-gradient":""}},"footnotes":""},"helpdesk_category":[4491],"helpie_tag":[],"helpie_add_tag":[],"helpie_up_tag":[],"class_list":["post-84452","pauple_helpie","type-pauple_helpie","status-publish","format-standard","hentry","helpdesk_category-google-sheets-fr"],"_links":{"self":[{"href":"https:\/\/reportei.com\/fr\/wp-json\/wp\/v2\/pauple_helpie\/84452","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/reportei.com\/fr\/wp-json\/wp\/v2\/pauple_helpie"}],"about":[{"href":"https:\/\/reportei.com\/fr\/wp-json\/wp\/v2\/types\/pauple_helpie"}],"author":[{"embeddable":true,"href":"https:\/\/reportei.com\/fr\/wp-json\/wp\/v2\/users\/5"}],"replies":[{"embeddable":true,"href":"https:\/\/reportei.com\/fr\/wp-json\/wp\/v2\/comments?post=84452"}],"version-history":[{"count":2,"href":"https:\/\/reportei.com\/fr\/wp-json\/wp\/v2\/pauple_helpie\/84452\/revisions"}],"predecessor-version":[{"id":84849,"href":"https:\/\/reportei.com\/fr\/wp-json\/wp\/v2\/pauple_helpie\/84452\/revisions\/84849"}],"wp:attachment":[{"href":"https:\/\/reportei.com\/fr\/wp-json\/wp\/v2\/media?parent=84452"}],"wp:term":[{"taxonomy":"helpdesk_category","embeddable":true,"href":"https:\/\/reportei.com\/fr\/wp-json\/wp\/v2\/helpdesk_category?post=84452"},{"taxonomy":"helpie_tag","embeddable":true,"href":"https:\/\/reportei.com\/fr\/wp-json\/wp\/v2\/helpie_tag?post=84452"},{"taxonomy":"helpie_add_tag","embeddable":true,"href":"https:\/\/reportei.com\/fr\/wp-json\/wp\/v2\/helpie_add_tag?post=84452"},{"taxonomy":"helpie_up_tag","embeddable":true,"href":"https:\/\/reportei.com\/fr\/wp-json\/wp\/v2\/helpie_up_tag?post=84452"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}