Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
6 years ago
Solved

Data visualizations not showing all rows

Thanks in advance.

 

I'm having a weird issue where a table visualization I created will not show all the rows of data. Based on the filters applied, there should be 10 rows, and a count confirms that. But a table of the same data reduces down to only three rows.  Any idea what's going on?  

Need Help
  • Anonymous's avatar
    Anonymous
    6 years ago

    Hi Anonymous 

     

    Maybe you could try adding an index column to your data and put that into your visual. Since it is no longer "duplicate", it should show everything you have. Remember to add the index column into your visual.

     

    Daren

8 Replies

  • lprado's avatar
    lprado
    New Member
    3 years ago

    right click on column for that visual and choose "show items with no data"

    • CP0's avatar
      CP0
      New Member
      1 year ago

      Best answer. This sorted it out. cheers

  • az38's avatar
    az38
    Community Champion
    6 years ago

    hi Anonymous 

    try to  set "Do not aggregate" in parameters Transaction_Amount field in Visualizations pane

     

    do not hesitate to give a kudo to useful posts and mark solutions as solution

    • Anonymous's avatar
      Anonymous
      Not applicable
      6 years ago

      I do have data visualizations set to 'Don't Summarize'. The issue appears to be that it doesn't want to repeat what it thinks is duplicate data. This is what this is - it's duplicate purchases from my company's purchase card log, so the dates, merchants, amounts, etc are the same. Any idea? Thanks.

      • Anonymous's avatar
        Anonymous
        Not applicable
        6 years ago

        Hi Anonymous 

         

        Maybe you could try adding an index column to your data and put that into your visual. Since it is no longer "duplicate", it should show everything you have. Remember to add the index column into your visual.

         

        Daren

  • jdbuchanan71's avatar
    jdbuchanan71
    Super User
    6 years ago

    The transation amount measure is filtering the results and only returning the merchant_names where the amount is not blank.