Forum Discussion

cjakerle's avatar
cjakerle
Cloud Apps
08-22-2024
Solved

Show more than 70 columns in a pivot2 (without changing the global setting)

Hello, We have a situation where we need to show 3 different values for each day of a month in a pivot (so, up to 93 max columns).  I know there is a global setting to expand the number of columns o...
dashboards & reporting
  • DRay's avatar
    DRay
    08-26-2024

    Hi cjakerle.

    You can definitely change the global setting to 95. Do you have a test environment you can try it with to see what the impact may be? If not, I recommend closely monitoring the server performance after you increase the global limit to make sure the system performance is acceptable.

DRay's avatar
DRay
Sisense Employee
08-26-2024

Hi cjakerle.

You can definitely change the global setting to 95. Do you have a test environment you can try it with to see what the impact may be? If not, I recommend closely monitoring the server performance after you increase the global limit to make sure the system performance is acceptable.

cjakerle's avatar
cjakerle
Cloud Apps
08-27-2024

Thanks, DRay .  I think updating the global setting is the way to go.  I updated in a test server with no load and it went fine.  I'll try it in Prod and watch it as you suggested.