Forum Discussion

ReneeKoelewyn's avatar
ReneeKoelewyn
Frequent Visitor
1 year ago
Solved

Incorrect percentage pulling through to chart

Hi,

 

I am trying to pull through the data for 2024, but the incorrect percentage is pulling through to the chart. 

 

Not sure what I am doing wrong - any assistance will be greatly appreciated. 

 

 

 

 

  • Hi,

    it seems like you have a seperate table for each year, but you use only one column for the x-Axis. Is your table for 2024 connected to the learning hub category in the data model?

    As it shows the total of all categories for each category, there is probably a connection missing in your data model.

2 Replies

  • Darui6's avatar
    Darui6
    Frequent Visitor

    Hi,

    it seems like you have a seperate table for each year, but you use only one column for the x-Axis. Is your table for 2024 connected to the learning hub category in the data model?

    As it shows the total of all categories for each category, there is probably a connection missing in your data model.

    • ReneeKoelewyn's avatar
      ReneeKoelewyn
      Frequent Visitor

      Hi,

       

      Thank you so much! I had to create a new relationship, done and resolved 🙂