Tooltip for Pie Charts

Hello DRay Liliia_DevX  harikm007 ,

I saw harikm007 other post about adding tooltip information to bar chart, column chart, etc, but I was wondering if there was code out there to add it to a pie chart (https://community.sisense.com/t5/build-analytics/add-additional-information-in-tooltip-column-bar-line-area/m-p/2538)? 

My attempt at it using ChatGPT:

// Add CART ID count to the query
widget.on("beforequery", function (se, ev) {
  var newJaql = {
    jaql: {
      column: "CART ID",
      agg: "count",
      datatype: "numeric",
      dim: "[GMV_ORDER_DASH_UNION.CART ID]",
      table: "GMV_ORDER_DASH_UNION",
      title: "Cart Count"
    }
  };
  ev.query.metadata.push(newJaql);
});

// Modify the tooltip content
widget.on("beforedatapointtooltip", function (se, args) {
  // Find the Cart Count index in the results
  var cartCountIndex = se.rawQueryResult.headers.indexOf("Cart Count");
  
  if (cartCountIndex !== -1) {
    // For pie charts, we need to match the category
    var category = args.context.category;
    var categoryIndex = se.rawQueryResult.headers.indexOf(se.metadata.panels[0].items[0].jaql.title);
    
    // Find the matching row for this pie slice
    for (var i = 0; i < se.rawQueryResult.values.length; i++) {
      var row = se.rawQueryResult.values[i];
      if (row[categoryIndex].text === category) {
        // Add Cart Count to the tooltip
        args.context.points.push({
          seriesName: "Cart Count",
          showPercentage: false,
          value: row[cartCountIndex].text,
          valueColor: args.context.points[0].valueColor
        });
        break;
      }
    }
  }
});

As you expected this does not work. Any possible ideas would be much appreciated.