I am hoping someone can help me formulate an expression that counts how many dimensions meet a specific requirement.
In the attached dashboard, I need to populate 3 fields in the straight table: 1 Try, 2 Tries and > 2 Tries.
1 Try = # Components that were tried only once
2 tries = # Components that were tried a sum of two
> 2 Tries = # Components that were tried greater than sum of 2 times.
I truly appreciate it.
Solved! Go to Solution.
Can you please include your expected result? You can create that manually in an excel to illustrate it. It is not clear what is the expectation.
The table are behaving in certain way as some of the dimensions are not part of the table, so values are getting grouped based on the dimensions that are part of that table.
If you look at the # Tries per Component Straight Table, the expected result should be:
1 Try = 1 component (1123)
2 Tries = 2 Components (1124, 1123)
> 2 Tries = 3 Components (1124, 1122 (for Jeep), 1122 (for Dodge))
|Industry||Make||Components||1 Try||2 Tries||> 2 Tries|
Let me know if the above helps, so each car line (Dodge, Jeep) will go through three types of testing and we want to find out how many tests it took to complete each component (1, 2, >2)
hey Sunny, what if Make = Dodge and Component = 1122 had two instances of 1 on 1st Try? So then the 1 Try would have to be counted twice, is there any way of counting Distinct in the expression?
Not a problem, please see attached.
I created Component 1121 associated with Jeep and it is showing 2 Tries for a value of 2, when it should be two 1122 line items each completed once.
Dodge Charger 1122 should show two 1 Tries, one 2 Tries, and one > 2 Tries