Forum Discussion

jeromeianmpbi's avatar
jeromeianmpbi
New Member
5 years ago

Interact Graph and Table Not Working Well

Hi. 
I have a distibution of errors graph and a table of failed cases. My goal is that when i click the REPORTER errors or the SERIOUSNESS errors, the table will only show cases with "1" at the REPORTER or SERIOUSNESS column.

The data is in the same table in an xcel sheet. Can someone pls let me know what to do?

Super Thanks!!!

Need Help
Show and Tell
Tips and Tricks

2 Replies

  • amitchandak's avatar
    amitchandak
    Super User
    5 years ago

    jeromeianmpbi , in the first visual, if REPORTER and SERIOUSNESS are measures then not possible.

     

    Create a new column

    if([REPORTER] =1, "REPORTER", "SERIOUSNESS")  and use that as legend

    • jeromeianmpbi's avatar
      jeromeianmpbi
      New Member
      5 years ago

      thanks amit. REPORTER and SERIOUSNESS are columns.
      I have tried your suggestion but unfortunately, i cannot add the "new" column as a legend in the 2nd visual (which is a "table"). also, there are more than 5 columns (REPORTER, SERIOUSNESS, Field A, Field B, Field C, etc.).