Automatic chart generation

[Syndicate_Admin]

Hello!

I want to generate the following report:

I have a series of articles with parameters assigned to each article. For example:

	parameter
article	Temp1	Temp2
1	x
2	x	x

I would like the graphs to be automatically generated to display the parameters. That is, if you filter by article 1 that a line chart with the history of Temp1 be generated for article 1. If you chose Article 2, two line charts would be generated, one for Article 1 and one for Article 2.

Would it be possible to do such a thing?

Thank you!!!!!

[v-easonf-msft]

Hi,  @Syndicate_Admin 

I’m not  clear about your needs.

Can you explain it in detail through actual sample data?

Best Regards,
Community Support Team _ Eason

[MFelix]

Hi,

You need to go to the query editor and Unpivot the columns temp1 temp 2 , you will get a table with 3 columns:

Article

Attribute

Value

Now use the attribute column on your Chart has legend.