Skip to main content

Summary:

Do you have the need to review content consumption by your learners per country or region to compare uptake? This is possible using a pivot within a look and changing the view to a bar graph.

Requirement Overview:

If any of these requirements fit your end goal, this may be the play for you.

  • Requirement 1: Show the number of content items enrolled in per country.
  • Requirement 2: Display the breakdown of content per status.
  • Requirement 3: Display the data in an easy to read bar graph.

Functional area to be used:

  • Reporting > Create

Core Functionality Configurations:

Description : 

Using any Explore in the Learner Content & Progress section of the Create page, display learner country and status, then pivot on status.

Configuration:

  1. Navigate to the Reporting > Create page (/learn/manager/reporting-hub/custom-reports).
  2. Choose the What is the average completion progress on a content item? report under the Learner Content & Progress section. 
  3. Choose fields to display and filter (add other filters if required also).
    • In the screenshot, we selected Status, Count, and Country to display. We selected Content Title, Country, and Email to filter.
      AD_4nXcSVIK0pSMqsK6fCr0ta2PQQLsUEHY9Vu13LGDr9oTc9WFiDfyaeenmiKKFkyBX-FkEUGgXH8LOyS1bSF2Ng2bysMA7PDgRr1I5c0C1IKUbpXnSt1vuJzty1NloBeN-SdzfkoTJyw?key=XHhpDiuzCFT0WY4iq5g0FXxq
  4. Choose the Pivot icon on the Status label.
    AD_4nXcPuONsKOdKXTBxjEA4rzck1SnVa4f1OESGIhV6Kj2cn6N6dkZz46S6_Y9DWwv6fXe5UTAE-gjGs3vlxay8vpCqt1MmH5GQA7pWirlXhStWUo9NOjtTDiDHyCLSvCE4EvrvvfAKqQ?key=XHhpDiuzCFT0WY4iq5g0FXxq
  5. Click into the Visualization tab to change from a table format to a bar graph format.AD_4nXfdXOaNgod5U2a6nuHGvfuhrSz10GuU7LFkGhVPk1SfhduIIYiOW4O82S8Slsi-0SkIFrsN1mwuS_nh86mdftClfPlVSSXmGohkpPySVkVQKjzVxG5ZvrBnMZgaohnZ8NE47lsb?key=XHhpDiuzCFT0WY4iq5g0FXxq
  6. Enter the settings below to have a RYG, stacked bar graph with a sum of the quantities at the top.

    AD_4nXe9xkKxJ3jNzJI0GC3Lp-utt73_Hn1_QMjFIYfXdOY0uBVellSr_IIhHcOnllxCgQ9GsTs25lrsNAl4csUEiHMh9T3pC0cco9u_iCbyffhBjseDGSLRLg2SNMWG9bjr0XZSSU0a-A?key=XHhpDiuzCFT0WY4iq5g0FXxq     AD_4nXfx_ohJIjkCANTjjCaYo3oDc5i47iBrf6qpHoAl26r18LVCPDH15pGJM4cbn13hdtnmqbk-hUTTRY8nBpizk322xC6NlfTakLCnlb0oa9IYw6EAlOXMETqY12G29Fcurh4r72TM?key=XHhpDiuzCFT0WY4iq5g0FXxq   AD_4nXecazvAV6acXjoL1gFbffC_wmSy-WVZhuVVdU6zZc6K04MgHRA15jbwndn-Gm5Dg8MH_d_yZq-pKTp-D_3sySYmtgM7kmzoUCmaYeDXRgg0LWqRuXZ8thDgughNKeV4Zc0gRFkWKw?key=XHhpDiuzCFT0WY4iq5g0FXxq

    Your graph will now look like this: AD_4nXcXezpw-rCXjc6IeXVZCyOnHmyeuJfidPeyM1NS5p-1SJMrgtdhqrqPBcatUHZtur84CYsLzYhN_iyIPBuGbDC4NRqioMvjucFRuBp3QaDdgdC2nHt5KSdoz1o-J_zCxEk-Nvj3?key=XHhpDiuzCFT0WY4iq5g0FXxq
  7. If you prefer, you can change from Stacked to Grouped to see the status side by side: AD_4nXf6WBNIOgasoGIBGGhNLPWSwIWGuR7GcOMmoZn9cp6d5gifM-Ch-l1JCaDqUZYuj9_HW9qVLQfSxv247cq8I30pr9QUeljyQVLTYU6_6PxBjrNQe-ph7ilcZVhx5lKUAXNDTdV6Yg?key=XHhpDiuzCFT0WY4iq5g0FXxq
  8. Once you are happy with your graph click the gear icon in the top right corner and choose whether you want to save as a Look or to an existing or new Dashboard.AD_4nXd70U388z0V4kvef9iBVdSfRuZeT0EyTi2szqbcyRzjCznoz3-um1p60X3iF0dgtGaa2sWnHWebGdsNpcgUuzblfsgyaEJ4-6jV_Oelr4bFfFgwj1D0hnOVNw--Y4PZ3MbnHhM6SA?key=XHhpDiuzCFT0WY4iq5g0FXxq

    You cannot use the save to new dashboard option at this step if you'd like it to be in the Group folder and therefore, visible to other users. Choose save to an existing dashboard to add it to a dashboard within a Group folder.

Risks and considerations:

  1. Your report may need to be filtered differently if you only want to see the values per specific content types, (e.g. Certifications).
  2. If you have too many records you may need to limit the number of countries you report on in order to get a readable display.
Be the first to reply!

Reply


Terms & ConditionsCookie settings