Hi pHi-Tech ,
I'll try answer your questions, but then provide some commentary below.
Sisense is very flexible - so the answer to 'can I do this' is almost always 'yes' - but the 'how can i do this' could have many different approaches.
1. I understood that conditional formatting can help here - but I cannot find or use this feature in my edit space in this chart. I don't know why.
This depends on the chart you are using. Can you share more information on this?
2. Do I need to write a code? or I can use features to help me?
As above.
3. If I choose RED as my out of range color, how can I modify that in range temperature wont use the color RED.
If we're using the OOTB (out of the box) theme, then charts will cycle through the pallette on the dashboard (screenshot below). They'll cycle through these colours and then move down a gradient and start again to assign categories with colours.
If you're looking to use code to do this - an example widget script for a line chart:
const threshold = 3
// when the widget is processing the result it's recieved from Sisense (and before it puts the result in the chart we're about to render)
widget.on('processresult', (w, args) => {
// lets iterate through the different categories
for (let i = 0; i < args.result.series.length; i++) {
// for the data points in each category
const category = args.result.series[i]
for (let j = 0; j < category.data.length; j++) {
// if the 'datapoint' is greater than our threshold, let's change the color of the point
const datum = category.data[j]
if (datum.y > threshold) {
datum.color = 'red'
}
}
}
})Will result in this.
There are ways to change the entire category line color if they ever went over a threshold, etc. so if you can get more specific about what you're trying to achieve, we can provide a more specific script.
Alternatively, feel free to take us up on our free 30-minute consult: https://www.rapidbi.com.au/sisense-add-ons/Services/Free-30-Minute-Sisense-Consultation/
