Forum Discussion
Line chart - Add lines based on table selection
Hi,
I have a table of objects in the main report. These objects have a seperate table with historic data.
ex:
Table 1:
| OBJECT_ID | OBJECT_NAME |
| T001 | Test Point 01 |
| T002 | Test Point 02 |
| T003 | Test Point 03 |
And the History data table:
| OBJECT_ID | RECORD_DATE | VALUE |
| T001 | 10/10/2022 | 5 |
| T001 | 11/10/2022 | 7 |
| T002 | 11/10/2022 | 3 |
| T001 | 12/10/2022 | 8 |
| T003 | 12/10/2022 | 1 |
| T003 | 12/10/2022 | 2 |
and it goes on..
I also have a LINE CHART to show this history data.
IS it possible to generate the line chart based on the selection of objects from table1 ?
i.e
If you select T001 from the table, the chart would show values for T001.
If you select T002 from the table, the chart would show values for T002.
But If you select T001 AND T002, there should be 2 Lines in the chart, 1 for each object.
We only have max 5 Objects, so If there's a way to give 5 measures as Y Values for the chart which somehow get values for each object..?
Is this something doable?
Please help!
Thank you!
2 Replies
Hi Aragorn ,
According to your description, here's my solution.
The two tables are related with OBJECT_ID column.
Put RECORD_DATE in X-axis, VALUE in Y-axis and OBJECT_ID in Legend.
Result:
I attach my sample below for your reference.
Best Regards,
Community Support Team _ kalyjIf this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
Hi,
Yes.. this works.
But Is there a way to show the "Average" of all when No object is selected, instead of showing all the lines?
In the data I have, there are 1000s of Objects. I want to show the average of all when more than 5 objects are selected. If its less than 5, then the 5 lines should appear.
Sorry I forgot to mention that earlier.Thank you so much!
