"The Pivot Table is Only Showing Part of the Data" Error

Tow

In our KPI cards using pivot tables, I keep getting the following error.

”This pivot table is only showing part of the data. The visible rows and/or columns are incomplete.”

There doesn't seem to be anything wrong with the DataSet, and I have not been able to identify the cause.

Has anyone else had a similar error?

amehdad

Hi @Tow, it's likely that your pivot table has too many rows to process from the size of data being pulled in. In order to fully build the Pivot, the number of rows would need to be reduced.

GrantSmith

For future reference this is mentioned just above the "Customizing Pivot Tables" section in the knowledge base: https://domohelp.domo.com/hc/en-us/articles/360043429473-Pivot-Table#3. By default there's a limit of 25,000 rows to display. See the section " What are the DataSet row limits for each chart type?" on this article: https://domohelp.domo.com/hc/en-us/articles/360042924214-Card-Building-FAQs

amehdad

Hi @Tow, it's likely that your pivot table has too many rows to process from the size of data being pulled in. In order to fully build the Pivot, the number of rows would need to be reduced.

Tow

Thank you @amehdad. I couldn't find any information about this error and it helped me a lot.

GrantSmith

For future reference this is mentioned just above the "Customizing Pivot Tables" section in the knowledge base: https://domohelp.domo.com/hc/en-us/articles/360043429473-Pivot-Table#3. By default there's a limit of 25,000 rows to display. See the section " What are the DataSet row limits for each chart type?" on this article: https://domohelp.domo.com/hc/en-us/articles/360042924214-Card-Building-FAQs

Tow

Hi @GrantSmith, thank you very much for your help. I set the number of rows from "Filter and Sort" in Analyzer and I was able to solve our problem!

German_Rodriguez

I set the number of rows to 25K from "Filter and Sort" in Analyzer and I was able to solve our problem!