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

komalc3

A Score Level 1

over 8 years ago

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...

Discussion posts and replies are publicly visible

0 komalc3
A Score Level 1
over 8 years ago

...g my SAIL code with the sub rules also therein for reference.

Can any one please guide me how to overcome this issue.

Thanks in advance....
Cancel
Vote Up 0 Vote Down

Sign in to reply

Verify Answer

Cancel
0 komalc3
A Score Level 1
over 8 years ago

This is Screenshot 2
Cancel
Vote Up 0 Vote Down

Sign in to reply

Verify Answer

Cancel
0 komalc3
A Score Level 1
over 8 years ago

This is the SAIL code
Code.txt
Cancel
Vote Up 0 Vote Down

Sign in to reply

Verify Answer

Cancel
0 Ricardo Galvan
Appian Employee
over 8 years ago

Is there a reason why nulls are not being filtered out when the data is retrieved?
Cancel
Vote Up 0 Vote Down

Sign in to reply

Verify Answer

Cancel
0 komalc3
A Score Level 1
over 8 years ago

Hi Ricardo

Thank you for replying.
If I go by the SAIL code attached, the variable local!datasubset1 which stores the a!queryEnity value, returns the correct result, nulls are not printed. (I printed it using a!textFiled for my reference). However, when this same variable is sent to the sub rule, nulls are generated in the column chart.
Just FYI, I am also attaching the sub rules.
Sub rules.txt
Cancel
Vote Up 0 Vote Down

Sign in to reply

Verify Answer

Cancel