Forum Discussion
Filtering a Related Table by Unrelated Columns
Hello,
I have two tables related by a Many-to-One relationship using the Application Name column:
Table 1
| Incident ID | Application Name | Severity | Date |
| 001 | App1 | High | 11-22-2022 |
| 002 | App2 | High | 10-24-2022 |
| 003 | App2 | Medium | 10-08-2022 |
| 004 | App1 | Low | 09-14-2022 |
Table 2
| Application Name | High | Medium | Low | Grade |
| App1 | 1 | 0 | 1 | C |
| App2 | 1 | 1 | 0 | D |
I am trying to make a line chart to show the grade value for each month per application. The Grade is a calculated column based on the counts of highs, mediums, and lows. In the chart, the X axis should be the month and the Y axis should be the grade. With the way I have this set up, is this possible? Does filtering by the date on Table 1 change the values on table 2? If it's possible, how can I create the chart?
2 Replies
Hi devenk2 ,
can you show graphically how the line chart should be? I think that you have transform the column [Grade] from text to numeric value.
I'm not sure how to show it graphically, but basically the Y-axis would show F through A, and the X axis would be each month. If the app had an A in Sept, a B in Oct, and a D in Nov, the line would move between A, B, and D between those months.
The grade value already corresponds to a number value called Weighted Grade which is a column in table 2, but when I use Weighted Grade as the Y axis it only lets me choose the count, which is 1, rather than the actual value.
