Forum Discussion
Solved
Creating Hierarchy table with string column as value.
Hi,
I need to create a hierarchy display to show some comments of a function and metrics in each function.
Table would look like below. I need to show all functions in level hierarchy and their comments. When user expands hierarchy, corresponding metrics comments should be displayed. Tried using matrix and table but looks like something is missing for me.
Any ideas??
Thanks,
Anil
| Function | Metric | Metric Comments | Function Comments |
| Product Quality | Design Maturity Metric at release (%) (Phase V from stoplight chart) (AIT) | comments 1 | comments_function1 |
| Product Quality | Design Maturity EVM Release Readiness Review at release (Phase IV plm release criteria) | comments 2 | comments_function1 |
| Product Quality | QTP Coverage/Failures | comments 3 | comments_function1 |
| Product Quality | SRE arrivals | comments 4 | comments_function1 |
| Product Quality | Total # of defects per product (# FW bugs) at release (EVM) | comments 5 | comments_function1 |
| Product Quality | Total # of defects SBM (# FW bugs submitted most recent 6 mo period) (AIT) | comments 6 | comments_function1 |
| Product Quality | SPR's resulting in EC's | comments 7 | comments_function1 |
| Product Quality | Field BUGs from Customer Complaints (# bugs submitted most recent 6 mo period) (AIT) | comments 8 | comments_function2 |
| Product Quality | Field/Warranty Failure Rate EVM (%) ( x100 to give range of response) | comments 9 | comments_function2 |
| Product Quality | NA w/UPS Field/Warranty Failure Rate AIT (%/mo) (x100 to give range of response) | comments 10 | comments_function2 |
| Supply Chain Quality | DC Delivered Quality (Over / Under ships) - PPM | comments 11 | comments_function2 |
| Supply Chain Quality | Customer External PPM (DOA) | comments 12 | comments_function2 |
| Supply Chain Quality | Rolled First Time Yield (%) 1-(1-B)*10 | comments 13 | comments_function2 |
| Supply Chain Quality | Tier 1 Forward Looking Metric (JDM, GCM, etc) (0-5 scale convert to %) (Value is 5-"B" used in RC equation) | comments 14 | comments_function2 |
| Supply Chain Quality | Tier 2 Forward-Looking Metric (component suppliers) (0-5 scale convert to %) (Value is 5-"B" used in RC equation) | comments 15 | comments_function2 |
| Supply Chain Quality | Critical Issues/Stop Ships (Incident/Week) | comments 16 | comments_function2 |
| Supply Chain Quality | QMS Audit Compliance (Zero major non-conformances; 3 or fewer minor non-conformances per site) | comments 17 | comments_function2 |
I need to create some thing like below.
function name function comments metric name metric comments metric name metric comments function comments and metric comments are in separate columns in table.
Thanks,
Anil
4 Replies
Hi anilreddy128
Could you be more specific on what you want?
Normally a matrix can be do that.
Patrick
I need to create some thing like below.
function name function comments metric name metric comments metric name metric comments function comments and metric comments are in separate columns in table.
Thanks,
Anil