• State Verified Answer
  • +1 person also asked this people also asked this
  • Replies 6 replies
  • Subscribers 4 subscribers
  • Views 2640 views
  • Users 0 members are here
Related Discussions
Home » Discussions » Reports

Create a line graph showing the data accumulating over time

bryant.st39

I have a series of dates with associated numeric values. I'd like to create a line graph showing the data accumulating over time
data:
1/1/2016-100
2/1/2016-150
3/1/1/2016-80
chart:
1/1/2016-100
2/1/2016-250
3/1/2016-330

Any recommendations?

OriginalPostID-156034

OriginalPostID-156034

  Discussion posts and replies are publicly visible

Parents
  • 0
    A Score Level 1
    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
    )
    )
Reply
  • 0
    A Score Level 1
    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
    )
    )
Children
No Data
© 2024 Appian. All rights reserved.
We want to hear from you! Submit a review on Gartner or G2.