188722 - no subject - Hi\n\nI am creating a stacked Column cha

Hi

I am creating a stacked Column chart with the help of the below SAIL Recipe:
forum.appian.com/.../SAIL_Recipes.html


I have a field Lab which is acting as a base for each column. (I know I can make a normal chart report for this but I am making a stacked report as these sub rules are general rules and I am making other stacked reports as well where I am facing the same issue).
My report also has a feature of user filters. So based on the user filters my stacked column chart should display.

The issue that I am facing is, if I have data for say 2 out of 3 Labs, based on the user filters, then the code is not able to handle nulls, the column chart displays [Category 6] Rather than not displaying the data. PFA Screenshot 1 for the same.

Also the data is being mismatched. PFA Screenshot 2 for the same.

I am also attachin...

OriginalPostID-188722