Forum Discussion

lalasisi's avatar
lalasisi
Cloud Apps
09-06-2024

Tricky Combo Chart in Sisense How?

Hi the great sisense community, I need a lot of help on making a combo chart in Sisense. Below is what I want to create: The purpose of this chart is to show my main baseball team (Yankees) in b...
dashboards & reporting
data models
rapidbisupport's avatar
rapidbisupport
Data Pipeline
09-11-2024

Hey mate,

Sure thing - i've provided a few variables at the top of the script to change selected and unseelcted colors:

 

let selectedColor = "#F7921E"
let unselectedColor = "#00ACCD"

widget.on('processresult', (w, args) => {
  let categoryItem = widget.metadata.panels[0].items[0].jaql.dim
  let myTeams = widget.dashboard.filters.item(categoryItem).jaql.filter.members
  
  args.result.series[0].data.forEach((d) => { 
	  d.color = unselectedColor
	  d.selected = false
  
  })
  
  for (let i = 0; i < myTeams.length; i++) {
    let myTeam = myTeams[i]
    args.result.series[0].data.find((d) => { return d.selectionData[0] === myTeam }).color = selectedColor
  }
  for (let j = 0; j < args.result.xAxis.categories.length; j++) {
    if (!myTeams.includes(args.result.xAxis.categories[j])) {
      args.result.xAxis.categories[j] = ''
    }
  }

})

 

With the value labels, you can do this in the interface (the "Value Label" toggle):

Let me know how you go?

Thanks,

Daniel

RAPID BI

daniel.ranisavljevic@rapidbi.com.au

RAPID BI - Sisense Professional Services | Implementations | Custom Add-ons

 

lalasisi's avatar
lalasisi
Cloud Apps
09-11-2024

Thank you! Is there a way to only show value labels for the bars, not the line?

  • rapidbisupport's avatar
    rapidbisupport
    Data Pipeline
    09-12-2024

    Yep - you can remove them by using the args.result.plotOptions in the process result:

      args.result.plotOptions.line.dataLabels.enabled = false

    Or all together:

    let selectedColor = "#F7921E"
let unselectedColor = "#00ACCD"

widget.on('processresult', (w, args) => {
  args.result.plotOptions.line.dataLabels.enabled = false
  let categoryItem = widget.metadata.panels[0].items[0].jaql.dim
  let myTeams = widget.dashboard.filters.item(categoryItem).jaql.filter.members
  
  args.result.series[0].data.forEach((d) => { 
	  d.color = unselectedColor
	  d.selected = false
  
  })
  
  for (let i = 0; i < myTeams.length; i++) {
    let myTeam = myTeams[i]
    args.result.series[0].data.find((d) => { return d.selectionData[0] === myTeam }).color = selectedColor
  }
  for (let j = 0; j < args.result.xAxis.categories.length; j++) {
    if (!myTeams.includes(args.result.xAxis.categories[j])) {
      args.result.xAxis.categories[j] = ''
    }
  }

})

    Which looks like this:

    Let me know how you go?

    Thanks,

    Daniel

    RAPID BI

    daniel.ranisavljevic@rapidbi.com.au

    RAPID BI - Sisense Professional Services | Implementations | Custom Add-ons