Arranging imported data to different format

[t2makela]

Hi,

My imported measurement data is in format below:

Measurement        MeasurementResult         TimeStamp

temperature          14                                     7/9/2016 6:00:00 AM

humidity                95                                     7/9/2016 6:00:00 AM

dewpoint               13.2                                  7/9/2016 6:00:00 AM

I would like to have the data in format:

TimeStamp                       temperature            humidity        dewpoint

7/9/2016 6:00:00 AM       14                            95                  13.2

How would I do the transformations?

[v-haibl-msft]

@t2makela

If you only want to show the report in your expected format. You can also use Matrix visual chart directly as below without any transformation.

Best Regards,

Herbert

[BhaveshPatel]

Let me walk you through the screenshots for the solution.

[t2makela]

@BhaveshPatel

Thanks for the detailed reply. How do I do the arrangement if I have multiple results in same kind of format?

[t2makela]

@v-haibl-msft

Thanks, it works, but I would like to show the data in line chart or line and stacked column chart.

[v-haibl-msft]

@t2makela

If you want to show the data in line chart or stacked column chart, you can do it without any data transformations. Just drag the columns into charts as below.

Best Regards,

Herbert

[t2makela]

Hi,

My imported measurement data is in format below:

Measurement        MeasurementResult         TimeStamp

temperature          14                                     7/9/2016 6:00:00 AM

humidity                95                                     7/9/2016 6:00:00 AM

dewpoint               13.2                                  7/9/2016 6:00:00 AM

I would like to have the data in format:

TimeStamp                       temperature            humidity        dewpoint

7/9/2016 6:00:00 AM       14                            95                  13.2

How would I do the transformations?