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

What is the best way to get a total/aggregate of the grid you are showing?

rachealv537

Hi! I have a report that aggregates a budget by client segment and returns the results in a grid. It works fine. However, I would like to add to my report the total for my grid at the top - not part of the grid- where I am going to add other text information. What is the best way to get a total/aggregate of the grid you are showing? Screenshot attached. Basically, a report total....

OriginalPostID-135924

OriginalPostID-135924

  Discussion posts and replies are publicly visible

Parents
  • 0
    Appian Employee
    If it's not part of the grid you should be able to get the .totalCount property from the DataSubset object returned by your query rule but that would mean running the query rule twice which maybe expensive ... maybe you can have a view with a single column to retrieve the count and create a simple CDT to query that view so the query is not as expensive as the original one.
Reply
  • 0
    Appian Employee
    If it's not part of the grid you should be able to get the .totalCount property from the DataSubset object returned by your query rule but that would mean running the query rule twice which maybe expensive ... maybe you can have a view with a single column to retrieve the count and create a simple CDT to query that view so the query is not as expensive as the original one.
Children
No Data
© 2024 Appian. All rights reserved.
We want to hear from you! Submit a review on Gartner or G2.