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 t...
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

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.

PaulDBrown's avatar
PaulDBrown
Community Champion
6 years ago

Anonymous 

It sounds like you have 10 rows of data, but only 3 distinct Merchants. Unless the other fields (transaction_date for example) are distinct, the aggregation on Transaction_amount kicks in to provide the "total" per row (all other fields being the same).

Can you provide a sample of your data?

 

PS: BTW, are you using a table or matrix visual?