This website uses Cookies. Click Accept to agree to our website's cookie use as described in our Cookie Policy. Click Preferences to customize your cookie settings.
I attempted to create a data bar representing a scale of 100, but the output is incorrect.
There the output:
1 ACCEPTED SOLUTION
Hi @b_bouri ,
The problem arises because the data bar in the pivot is based on finding the lowest and highest numbers from the column, which is typically valid. However, in your case, the lowest number should be 0 and the highest number should be 100. This discrepancy is why the output is incorrect.
To resolve this issue, you can manually specify the lowest and highest numbers using the widget script provided below. Update the variable 'panelItemName' with the name of the panel item where the data bar is displayed:
widget.on('processresult', function(w, args){
const panelItemName = 'Percent'
const panelItemIndex = args.query.metadata.findIndex((item) => item.jaql.title === panelItemName)
if(panelItemIndex >= 0) {
args.result.dataBars[panelItemIndex] = ['0', '100']
}
})After updating the script, the data bar should display correctly.
Feel free to reach out if you have further questions, we're always happy to help 🙂
[email protected]
Paldi Solutions, Number #1 Sisense Plugins Developer
Hi @b_bouri ,
The problem arises because the data bar in the pivot is based on finding the lowest and highest numbers from the column, which is typically valid. However, in your case, the lowest number should be 0 and the highest number should be 100. This discrepancy is why the output is incorrect.
To resolve this issue, you can manually specify the lowest and highest numbers using the widget script provided below. Update the variable 'panelItemName' with the name of the panel item where the data bar is displayed:
widget.on('processresult', function(w, args){
const panelItemName = 'Percent'
const panelItemIndex = args.query.metadata.findIndex((item) => item.jaql.title === panelItemName)
if(panelItemIndex >= 0) {
args.result.dataBars[panelItemIndex] = ['0', '100']
}
})After updating the script, the data bar should display correctly.
Feel free to reach out if you have further questions, we're always happy to help 🙂
[email protected]
Paldi Solutions, Number #1 Sisense Plugins Developer
