Forum Discussion

KervBruce's avatar
KervBruce
Icon for Advocate I rankAdvocate I
3 years ago

Matrix Table Layout

Hi, Today I was puzzled by the layout of a matrix table I created. My data has a number of columns including a date/time, there is no single unique column to act as a primary key but every row is u...
Need Help
KervBruce's avatar
KervBruce
Icon for Advocate I rankAdvocate I
3 years ago

Matrix without date hierarchy

 

Matrix withdate hierarchy

 

Pragati11's avatar
Pragati11
Icon for Super User rankSuper User
3 years ago

Hi KervBruce ,

 

Not sure why you have Build column moved to the RowsB section in your both matrix visuals.

This is what is causing the issue. I am sure if you remove this column from Rows section, you will not see those additional rows.

Can you please try and confirm that it works after removing BuildB column from the Rows section of matrix visual?

 

  • KervBruce's avatar
    KervBruce
    Icon for Advocate I rankAdvocate I
    3 years ago

    I put Build in the rows to understand what was going on, here it is with it removed.

     

    • Pragati11's avatar
      Pragati11
      Icon for Super User rankSuper User
      3 years ago

      Hi KervBruce ,

       

      So is the isue resolved because keeping build column was not adding any insights to your matrix visual earier?

       

      • KervBruce's avatar
        KervBruce
        Icon for Advocate I rankAdvocate I
        3 years ago

        No, not at all, because I still don't understand why I have 4 rows for the 2nd September as a value but one row for the 2nd September  in a hierarchy.

        (sorry, posted my earlier response in the wrong place)

  • KervBruce's avatar
    KervBruce
    Icon for Advocate I rankAdvocate I
    3 years ago

    No, not at all, because I still don't understand why I have 4 rows for the 2nd September as a value but one row for the 2nd September  in a hierarchy.