Hi everyone,
I’m working on a MashApp for a Dutch customer, only I’m stuck on a numbering challenge.
This is the case:
The MashApp is based on data from the ARIS Risk & Compliance Manager via the new direct link functionality that’s in from ARCM SR4. There are some widgets created in the MashApp and for some of them I need the functionality of counting the total of Test cases (TC_ID).
In the example above I worked with a number value (Teller) that creates a new column in the data table with the value 1. And at the end I sum all the values 1 in that column and get my total number of test cases (TC_ID).
This works fine if a test case (TC_ID) would only occur ones in the column... But in the ARCM it is possible to at multiple attribute values of the same attribute type to a risk. For example multiple risk types (R_TYPE_NAME) to a risk and the risk data is part of the test case data. Then the test case uses multiple rows in the table because every value combination has to have its own row.
Only than the counting value will be given to both rows and 1 unique test case (example 3454) is counted as 2 test cases.
So my question is how can I create some sort of counting value that only gives his value ones to each unique test case? Or is there a other way of counting the total of test cases and make this also available to filter on other widgets without counting double values.
Hope someone can help me with this problem
Thanks in advance!
Best regards,
Thijs Dirkmaat
Hi,
your approach is the way I'd suggested, too. To aggregate, e.g. count, MashZone need a numerical column to do its calculation. That is why you need the column Teller containing constant 1.
As far as I understood your data feed's column TC_ID contains duplicates since each test consists of multiple attributes (or risks?) and is represented by multiple data feed rows therefore. Your goal seems to be to count the number of TC_ID and "the other attribute" combinations.
You can do this by extending the aggregation operator. If there is such an input:
You could aggregate this way:
Note that I selected more dimensions for aggregation to create a combined key by considering more than one column. Is this applicable for your case?