How to display custom fields and calculations in dashboard gadget

[Jim Malgieri]

Hello,    

Situation: We have a project (PROJA) which uses labels Lt1, Lt2, ... , LtN and Lpc1, Lpc2, ... , LpcN.  We also have 2 custom number fields VA and VB - and a value calculated (CV) by Scriptrunner that uses  the formula (VB*100)/VA.  This Scriptrunner calculated value is placed into a third custom field.

Lt are various teams within PROJA.  Lpc is a project cycle within PROJA. Therefore, the values of VA and VB for each project cycles are the sums of all VA and VB values for that cycle.

What we would like to do is create a table to display these values.  The x-axis would be Lpc(1-n), y-axis Lt(1-n) and then display VA, VB and CV values for each Lpc, Lt pair.

Current Progress:  We have created 2 Rich Filter gadgets - One showing just the VA value and the other showing the VB values. 

Problem: The difficulty is displaying the calculated value, CV. What is happening is that CV is returning the total of all calculated values, each individual CV in the project cycle added up. Instead, we need the totalVB*100/totalVA to be returned - and we are having a really hard time pulling this off.

Example:

Gadget 1

      Lpc1   Lpc2

Lt1    VA*    VA

Lt2    VA     VA

Gadget 2

      Lpc1   Lpc2

Lt1    VB*    VB

Lt2    VB    VB

Gadget 3

    Lpc1    Lpc2

Lt1    CV*   CV

Lt2    CV    CV

* If VA*=100 and VB*=50  CV* should = 50 or 50%

Someone suggested I try Dataplane but I keep hitting a dead end with it.

Any and all suggestions are very welcome.  If you'd like me to give more info or re-explain anything, just ask.

Thanks,

Jim