Create a line graph showing the data accumulating over time

Try this:

load(
local!dates: {"01/01/2016","02/01/2016","03/01/2016"},
local!values: {"100","150","80"},
a!paragraphField(
value: apply(
rule!pb_forum_accumulate_values,
enumerate(length(local!values))+1,
local!values
)
)
)

Where rule!pb_forum_accumulate_values is as below, with inputs of index (single integer) and array (array of integers):

= sum(
index(
ri!array,
enumerate(
ri!index
) + 1
)
)

Thanks...any recommendations on doing that in a line chart series? I've built the expression and pass my data from a query into it using the apply function and save the results into a local!var and am trying to use local!var as my series...the line it is producing is the original data series.

You should be able to set categories to the array of dates, and the data as follows:

data: apply(
rule!pb_forum_accumulate_values,
enumerate(length(local!values))+1,
local!values
)

...where local!values is replaced with the array of values.

It might be worth following this if you haven't already: forum.appian.com/.../SAIL_Components.html

...as follows:

= load(
local!dates: {
"01/01/2016",
"02/01/2016",
"03/01/2016"
},
local!values: {
"100",
"150",
"80"
},
a!lineChartField(
label: "Dates and values",
categories: local!dates,
series: {
a!chartSeries(
label: "Values",
data: apply(
rule!pb_forum_accumulate_values,
enumerate(
length(
local!values
)
) + 1,
local!values
)
)
}
)
)

User error...I had the inputs reversed on my expression...Thanks, your recommendation worked perfectly!!

No worries!