Display cumulative data on Appian Reports

@raviteja You would have already known this but I would like to suggest to strictly stick with database approach. Further I would like to suggest to achieve the use case completely in the view as suggested by @brettf.

Do attach the view here if you are expecting any suggestions from the performance perspective post development of the view.

@csteward To the best of knowledge, I guess the approach suggested by you might not work as per my knowledge because if we observe the requirement carefully two things can be understood:
1. Requirement is demanding the grouping on the month-year combination and a count against it whereas your idea performs a grouping on the day-month-year.
2. Requirement demands a cumulative count operation which is at not at all possible with the queryEntity and requires a special coding in the view to calculate it.

@raviteja You would have already known this but I would like to suggest to strictly stick with database approach. Further I would like to suggest to achieve the use case completely in the view as suggested by @brettf.

Do attach the view here if you are expecting any suggestions from the performance perspective post development of the view.

@csteward To the best of knowledge, I guess the approach suggested by you might not work as per my knowledge because if we observe the requirement carefully two things can be understood:
1. Requirement is demanding the grouping on the month-year combination and a count against it whereas your idea performs a grouping on the day-month-year.
2. Requirement demands a cumulative count operation which is at not at all possible with the queryEntity and requires a special coding in the view to calculate it.