Reply
Frequent Visitor
Posts: 3
Registered: ‎07-03-2017
Accepted Solution

Problem for consolidating data

Hello,

 

I'm trying to have a consolidate results but I have difficulties to do it.

 

My database is the following:

 

Sub entity           Code          Coverage

 

Sub entity 1         01            Covered

Sub entity 2         01            Covered

Sub entity 3         01            Covered

Sub entity 1         02            Partially

Sub entity 2         02            Covered

Sub entity 3         02            Covered

Sub entity 1         03            Not covered

Sub entity 2         03            Not covered

Sub entity 3         03            Not covered

 

When I build a chart per sub entity representing the number of codes per coverage, I have no problem. However, if I select all the sub entities, I would like to have a consolidate view taking into account the following rules : if all are covered then it is covered, if all are not covered, then it is not covered, otherwise, it is partially covered.

 

Sub entity           Code          Coverage

 

Entity                   01            Covered

Entity                   02            Partially

Entity                   03            Not covered

 

I'm not sure about what I need to do (creating a column or a measure).

 

Could you help with this issue?

Jérémie

 

 

 


Accepted Solutions
Member
Posts: 95
Registered: ‎03-16-2017

Re: Problem for consolidating data

[ Edited ]

I think this measure should work:

 

 

be aware I used "nc" for "not covered" and "p" for "partially" so you have to correct that

View solution in original post


All Replies
Member
Posts: 95
Registered: ‎03-16-2017

Re: Problem for consolidating data

[ Edited ]

I think this measure should work:

 

 

be aware I used "nc" for "not covered" and "p" for "partially" so you have to correct that

Frequent Visitor
Posts: 3
Registered: ‎07-03-2017

Re: Problem for consolidating data

Great! It works. Thank you