Hi,
Is there any way that I can get a sum from one column in a table with an other column?
As example: We having licenses for Dolby Digital in one licensing element there we have 300 tokens and used 107 tokens and then we have another element with 300 tokens and used 88 tokens. Can I then get the sum of these tokens?
I know it works with single parameter with ParameterSummary: Sum|120501/3975:308|120501/3975:311|
But not when I´m trying to get data from a table.
// Thomaz
Hi Thomaz,
I believe you will need to include the index in your shape data in order to make it work. The structure of the parameter section can be found in DataMiner Docs. For example:
Sum|DMAID/EID:PARAMID:INDEX1|DMAID/EID:PARAMID:INDEX2|...
The drawback of this approach is that you will need to include the index of all the rows from the table in your shape data.
Another approach is using Dashboards. You can create a GQI query that gets data from all tables that are related to a specific connector. From the result you can aggregate based on the desired column to get the total sum of tokens.
Hope it helps.
Hi Miguel,
The sum is working when I use index as you say, but do you know how I can do an subtraction of the parameters?
120501/2735:6453 = 300
120501/2735:6454 = 193
Sum|120501/2735:6453:TL-DD-DEC|120501/2735:6454:TL-DD-DEC|
gives the results of 493
Subtract|120501/2735:6453:TL-DD-DEC|120501/2735:6454:TL-DD-DEC|
gives the results of 300
// Thomaz