我有两个表 ， 表A的数据：
| month | orderid | type | qty | | 1 | L130111231 | BZX | 83 | | 2 | L130111232 | BZC | 69 | | 2 | L130111238 | BZC | 89 | | 3 | L130111233 | BAS | 91 | | 3 | L130111237 | BZC | 63 | | 4 | L130111234 | BAS | 74 | | 4 | L130111239 | BAS | 74 |
表B的数据, 这里的数据只是举例, 实际数据中failtype大概有3000+个：
| orderid | failtype | failqty | | L130111237 | short | 15 | | L130111237 | electronic | 10 | | L130111233 | short | 16 | | L130111234 | sample | 19 | | L130111231 | electronic | 10 | | L130111232 | sample | 17 | | L130111239 | sample | 10 | | L130111239 | sample | 14 | | L130111238 | electronic | 20 | | L130111238 | sample | 11 | | L130111233 | electronic | 16 | | L130111234 | lead | 18 |
这两个表有一对多的关系，可以用orderid关联起来，我需要在一个组件上展示一个比率，计算方法是 SUM(表B的failqty) / SUM(表A的qty)，这个该怎么做？ 我看了很多FineBI自带的demo，好像都只能用一个表来在组件上分析的 如果用自助数据集把这两个表合并起来，A表的数值就会变成多个，数据就不对了
最终计算的结果应该是这样的，这是我在excel里面算的： | Row Labels | Sum of qty | Sum of failqty | yield_ratio
| | L130111231 | 83 | 10 | 12.05% | | L130111232 | 69 | 17 | 24.64% | | L130111233 | 91 | 32 | 35.16% | | L130111234 | 74 | 37 | 50.00% | | L130111237 | 63 | 25 | 39.68% | | L130111238 | 89 | 31 | 34.83% | | L130111239 | 74 | 24 | 32.43% | | Grand Total | 543 | 176 | 32.41% |
| yield_ratio | failtype |
|
|
|
| | orderid | electronic | lead | sample | short | Grand Total | | L130111231 | 12.05% |
|
|
| 12.05% | | L130111232 |
|
| 24.64% |
| 24.64% | | L130111233 | 17.58% |
|
| 17.58% | 35.16% | | L130111234 |
| 24.32% | 25.68% |
| 50.00% | | L130111237 | 15.87% |
|
| 23.81% | 39.68% | | L130111238 | 22.47% |
| 12.36% |
| 34.83% | | L130111239 |
|
| 32.43% |
| 32.43% | | Grand Total | 10.31% | 3.31% | 13.08% | 5.71% | 32.41% |
|
1min目标场景问卷
立即参与
