I have a custom object with fields:
- Date
- Measurement A
- Measurement B
- Measurement C
- Measurement D
- Measurement E
I want to create a line graph with X-axis: the date (field 1) and 5 lines, for fields 2 - 6. For some insane reason, Salesforce limits the number of Y values to just 2! But: when grouping data, it is possible to create graphs that have an arbitrary amount of Y values.
Is there some way in which I can create a grouping on my object that allows me to create a 5-line chart? I am using plain Lightning, not the Analytics license.
Update: I found the free Lightning Web Chart.js Component in the AppExchange, but to display more than one line in a graph, you need to code in JS. Simply using it with app builder is not an option with dynamic data.