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

Tow · October 2021

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 · October 2021

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 · October 2021

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 · October 2021

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 · October 2021

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

GrantSmith · October 2021

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 · October 2021

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 · November 2022

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

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

Best Answers

Answers

Categories