142330 - no subject - Hi All,\n\nAm trying to create a stacked

You'll need to do some work in an expression rule after pulling the data because as you said, the data subsets may not be the same length. I would suggest looping through a rule with the date list, checking if there's a datapoint on each subset, and if not inserting a 0 value into that array.

Thanks for the suggestion can i get any example code for these cases it will be more help full.

Have you considered doing this in one datasubset, grouping by the status in addition to the other fields? Alternatively you might consider creating a view that uses a UNION ALL to assist with the grouping.

You would want to start by getting a list of all the days (in my example will be the current month):
local!days: 1+enumerate(day(eomonth(today(),0)))

Now you'll want to check each datasubset for a value for each day, substituting 0 where you have no value (I would do 2 separate queries for =SUCCESS and <>SUCCESS):
local!dataPoints: apply(
fn!displayvalue(
value: _,
inArray: local!data.dayMonth,
replacement: local!data.id,
default: 0
),
local!days
)
This is running through the days variable we made, checking if that value is in your data, and subbing in 0 if there isn't data.

Thanks a lot conorc , I was able to design what i needed.