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 0...
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.