Profile picture for user matd

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

by Stephan Freudl
Posted on Thu, 08/26/2010 - 18:14

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?

0

Featured achievement

Rookie
Say hello to the ARIS Community! Personalize your community experience by following forums or tags, liking a post or uploading a profile picture.
Recent Unlocks

Leaderboard

|
icon-arrow-down icon-arrow-cerulean-left icon-arrow-cerulean-right icon-arrow-down icon-arrow-left icon-arrow-right icon-arrow icon-back icon-close icon-comments icon-correct-answer icon-tick icon-download icon-facebook icon-flag icon-google-plus icon-hamburger icon-in icon-info icon-instagram icon-login-true icon-login icon-mail-notification icon-mail icon-mortarboard icon-newsletter icon-notification icon-pinterest icon-plus icon-rss icon-search icon-share icon-shield icon-snapchat icon-star icon-tutorials icon-twitter icon-universities icon-videos icon-views icon-whatsapp icon-xing icon-youtube icon-jobs icon-heart icon-heart2 aris-express bpm-glossary help-intro help-design Process_Mining_Icon help-publishing help-administration help-dashboarding help-archive help-risk icon-knowledge icon-question icon-events icon-message icon-more icon-pencil forum-icon icon-lock