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-09-2024

Hi lalasisi ,

A few steps here.

In the columns shelf you want your teams.

In the values shelf, you want:

  • your metric for comparison &
  • your metric for comparison ALL (teams) then click on three dots > Series Type > Line.

Lastly, this widget script will highlight the relevant team:

let myColor = "red"
let myTeam = 'Lily Brown'

widget.on('processresult', (w, args) => {
  args.result.series[0].data.find((d) => { return d.selectionData[0] === myTeam}).color = myColor
})

With the result looking like:

Let me know how you go?

Thanks,

Daniel

RAPID BI

[email protected]

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

 

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

    Hi Daniel,

    Thanks for your reply and I appreciate the help. Your answer would help achieve the basic chart but it is missing 2 of the most critical requirements:

    1. My team would change dynamically when the end user filter to a different team (in the dashboard filter). How to write the script in a way that it will highlight a different team every time the dashboard filter is changed?
    2. How to hide the team names of all the blue bars but let the red team name visible. This also needs to be dynamic as the user can choose "red sox" this time but "yankees" next time.
    • rapidbisupport's avatar
      rapidbisupport
      Data Pipeline
      09-10-2024

      Missed these - a few extra steps required:

      Let's make a few changes to the widget script, where we will detect the selected dashboard filters related to the first category item and then change the color and replace the xAxis text appropriately:

      let myColor = "red"

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
  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 = myColor
  }
  for (let j = 0; j < args.result.xAxis.categories.length; j++) {
    if (!myTeams.includes(args.result.xAxis.categories[j])) {
      args.result.xAxis.categories[j] = ''
    }
  }

})

      Secondly, lets make sure the widget filters behaviour is set to 'Highlight':

      This should result in this here:

      Let me know how you go?

      Thanks,

      Daniel

      RAPID BI

      [email protected]

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

      • lalasisi's avatar
        lalasisi
        Cloud Apps
        09-10-2024

        Amazing! Thank you so much Daniel! Your scripts works wonderfully! I was able to produce what I envisioned. Two more things, is there a way to make the gray bars to appear as #00ACCD and the orange bar to appear as #F7921E? I'd like to show the value labels of all the bars (i.e. their %'s). Is that another thing that needs to be added to the script?