• State Not Answered
  • Replies 7 replies
  • Subscribers 5 subscribers
  • Views 2608 views
  • Users 0 members are here
Related Discussions
Home » Discussions » Reports

Display cumulative data on Appian Reports

Raviteja Varma Jampana
A Score Level 2

Hi, Is there any simple way to show cumulative data on charts? i have data like this in DB and i need report as shown below
id validation date validatedwithin1day
1 01-10-2015 true
2 05-11-2015 false
3 01-12-2015 true
4 01-01-2016 true
5 05-01-2016 false
6 10-01-2016 true
7 02-02-2016 true

report must be like this

oct-15 nov-15 dec-15 jan-16 feb-16
1 1 2 4 5

i.e cumulative count of true's with frequency of year.Let me know if you need any more data.

OriginalPostID-188882

  Discussion posts and replies are publicly visible

Parents
  • 0
    If I understand the requirement correctly you should be able to do that by filtering on validatedwithin1day = true, performing grouping on the date field and using a count aggregation function on validatedwithin1day. Something like:

    a!queryEntity(
    entity: cons!ENTITY_DATA,
    query:
              a!query(
                        aggregation: a!queryAggregation(aggregationColumns: {
                         a!queryAggregationColumn(field: "validationdate", isGrouping: true),
                         a!queryAggregationColumn(field: "validatedwithin1day", aggregationFunction: "COUNT")
                        }),
                        filter: a!queryFilter(
                         field: "validatedwithin1day",
                         operator: "=",
                         value: true
                        )
              )
    )
Reply
  • 0
    If I understand the requirement correctly you should be able to do that by filtering on validatedwithin1day = true, performing grouping on the date field and using a count aggregation function on validatedwithin1day. Something like:

    a!queryEntity(
    entity: cons!ENTITY_DATA,
    query:
              a!query(
                        aggregation: a!queryAggregation(aggregationColumns: {
                         a!queryAggregationColumn(field: "validationdate", isGrouping: true),
                         a!queryAggregationColumn(field: "validatedwithin1day", aggregationFunction: "COUNT")
                        }),
                        filter: a!queryFilter(
                         field: "validatedwithin1day",
                         operator: "=",
                         value: true
                        )
              )
    )
Children
No Data

© 2024 Appian. All rights reserved.