Forum Discussion

Aragorn's avatar
Aragorn
Helper I
3 years ago

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 ...
Need Help
v-yanjiang-msft's avatar
v-yanjiang-msft
Community Support
3 years ago

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 _ kalyj

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

  • Aragorn's avatar
    Aragorn
    Helper I
    3 years ago

    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!