Earn a 50% discount on the DP-600 certification exam by completing the Fabric 30 Days to Learn It challenge.
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?
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
Let me walk you through the screenshots for the solution.
Thanks for the detailed reply. How do I do the arrangement if I have multiple results in same kind of format?
Thanks, it works, but I would like to show the data in line chart or line and stacked column chart.
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
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?
User | Count |
---|---|
93 | |
83 | |
77 | |
71 | |
65 |
User | Count |
---|---|
114 | |
101 | |
96 | |
65 | |
60 |