Forum Discussion
calculated row for matrix rows
Maggie,
Ffinally solved the problem as follows
Created three calculated columns which set a flag of 1
if the Data is Data1 and Value >0 1, 0
if the Data is Data2 and Value >0 1, 0
if the Data is Data3 and Value >0 1, 0
Then created a measure which when used in a matrix visualiation adds up the flags.
Then set a filter to show only iitems where the measure of the sum is < 3
This produces the desired matrix I gave as an example in the original question and only shows items where there is a missing required data value or one or more values is 0.
This is easily modified for any number of required data elements for a given row by adding more calculated flag columns and using them in the sum measure calculation then change the filter to 1 less than the total number of required data elements for each row.
Thanks for all the suggestions
Mr. Seward,
Sounds good, but there are several hundred "data types" and I am only interested in three that are mandatory and want to present the user with a report showing where critical data is missing from the table. Thanks if you can guide me further in this quest.
Mr. Seward,
Beyond my pay grade but I will try tomorrow.
Hi dougjones
Does the solution really helps you, if it works, could you kindly accept the solution as an answer, if not, please share the error with me?
Best Regards
Maggie
Maggie,
Ffinally solved the problem as follows
Created three calculated columns which set a flag of 1
if the Data is Data1 and Value >0 1, 0
if the Data is Data2 and Value >0 1, 0
if the Data is Data3 and Value >0 1, 0
Then created a measure which when used in a matrix visualiation adds up the flags.
Then set a filter to show only iitems where the measure of the sum is < 3
This produces the desired matrix I gave as an example in the original question and only shows items where there is a missing required data value or one or more values is 0.
This is easily modified for any number of required data elements for a given row by adding more calculated flag columns and using them in the sum measure calculation then change the filter to 1 less than the total number of required data elements for each row.
Thanks for all the suggestions
