Data visualizations not showing all rows

[Anonymous]

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?  

[lprado]

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

[az38]

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]

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]

@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?

[darentengdrake · Accepted solution]

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]

Thanks. This worked once I put in a unique field native to the data.

[jdbuchanan71]

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