Pivot Widget - Maximum Number of Values

Hello MikeGre,

Thank you for your question. That script should work. You can also configure pivot tables per this documentation. 

I hope that helps. Please let us know if you have any more questions.

Thank you.

Hello DRay 

Thanks for your prompt answer and documentation link!

My question was relevant to any implications that this script might cause to the performance of the environment, but I guess that your reply covers this.

After reading the relevant section for Configuring Pivot Table Limits, it says that : 

"Maximum number of columns to display: Limits the number of columns presented at the end of each page of the Pivot Table on the dashboard. The default number of columns is 70."

Though it says that, the number of max columns to display is 70, I still don't understand why, when we try to add 20 ["rows" or "values"]  the Add button disappears [screenshot below]

Any explanation to that?

Hi DRay ,

The question here is not to increase the Row Limit. The question is focused on the number of columns and understanding the limits and capabilities of adding more than 20 in a pivot widget.

Hi MikeGre,

I apologize for not understanding your question. 

I recommend opening a support ticket to look at this behavior with you. They will be able to get on a screenshare and get a better idea of what is going on.  https://www.sisense.com/support/