AllPrevious expression for a trending Line Chart!!!

I am trying to show a Trending line chart showing the sum of all "findbugs" for all applications under a team, the application may or may not exist in the current hierarchy node. 1. if an application exists in the current node., it should get the max rowid for the application and get the "findbugs" column value for that rowid, and sum up with findbugs value for all other applications likewise. 2. if the application does not exist in the current node., it should get the max rowid from all the previous nodes and use that value for the sum. I am having trouble getting the right expression to the get the desired data in the line chart as shown in the attached picture. Trying to resolve this for last 3 weeks and unable to do it, appreciate your help and also i have attached the dxp file for reference. thanks

Attachments

AttachmentSize
Image icon linechart.png92.48 KB
Binary Data lincharttrendtest.dxp333.37 KB

(1) Answer

Login