Limit the max value of the y-axis in the column chart to the max value [Linux]
Limit the Max high of Y-Axis of the Column chart to the Max value of the values in the chart, as usually we have +1 or more. L2025, both if applicable.
Step-by-Step Guide:
If you created a Column chart usually you will see such a result
The Y-axis is usually a little bit higher than the actual value.
To improve this, press edit for the widget.
Set the interval to 1
Press 3 dots, choose Edit Script.
In the new window, paste the following JavaScript code:
widget.on('beforeviewloaded', (scope,args)=>{
console.log(args);
//args.options.yAxis[0].max = 1;
args.options.yAxis[0].endOnTick = false;
})
Press the Save button to save the script.
Refresh the dashboard.
Now we can see that the values have the maximum value on the Y-axis.
Conclusion:
It is one of the ways to set the maximum value for the values on the Y-axis.
Disclaimer: This post outlines a potential custom workaround for a specific use case or provides instructions regarding a specific task. The solution may not work in all scenarios or Sisense versions, so we strongly recommend testing it in your environment before deployment. If you need further assistance with this, please let us know.
