Forum Discussion

JRParker's avatar
JRParker
Helper III
7 years ago
Solved

Remove Repeating Values in a Table Visualization

So we have a basic Table visual with two fields from two tables related via one-to-many relationship.  How does one prevent the repeating value on the 'one' side while repeating the values on the 'many' side:

 

 

Desired result:

 

Thanks in advance; presumably straight forward but apparently not for a rookie :) 

Need Help
  • parry2k's avatar
    parry2k
    7 years ago

    JRParker use matrix visual, add lead_name and activity_note on rows, click drill down button, on format pane, turn off stepped layout and you will have the view you are looking for.

5 Replies

  • parry2k's avatar
    parry2k
    Super User
    7 years ago

    JRParker use matrix visual, add lead_name and activity_note on rows, click drill down button, on format pane, turn off stepped layout and you will have the view you are looking for.

    • JRParker's avatar
      JRParker
      Helper III
      7 years ago

      Couldn't get this to work in the following scenario when the 'many' side has two fields (Note, Activity)

       

      Lead                Note                        Activity

      Lead 1Note 1.1Phone Call
      Lead 1Note 1.2Phone Call
      Lead 1Note 1.3Phone Call
      Lead 2Note 2.1Meeting
      Lead 2Note 2.1Phone Call
      Lead 3Note 3.1Phone Call
      Lead 3Note 3.2Meeting
      Lead 3Note 3.3Meeting
      Lead 3Note 3.4Meeting

       

      Desired outcome:

       

      Lead                Note                        Activity

      Lead 1Note 1.1Phone Call
       Note 1.2Phone Call
       Note 1.3Phone Call
      Lead 2Note 2.1Meeting
       Note 2.1Phone Call
      Lead 3Note 3.1Phone Call
       Note 3.2Meeting
       Note 3.3Meeting
       Note 3.4Meeting

       

      Thanks again parry2k!

      • parry2k's avatar
        parry2k
        Super User
        7 years ago

        JRParker it will work, make sure you are using matrix visual, not table visual