Forum Discussion
Data visualizations not showing all rows
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
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
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.
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
Thanks. This worked once I put in a unique field native to the data.
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?
