Forum Discussion
Trend Analysis
For the life of me I can not figure out how to do a time series plot with a trend line of several parameters. Any thoughts? My data looks like this, I'm wondering if it being row based instead of column based. If so, any thoughts on how to easily convert it? It's about 2,000 rows so I don't want to do it manually.
| Date | Parameter | Result |
| 04-27-2000 | Ammonia | 0.05 |
| 04-27-2000 | Nitrite | 0.30 |
| 04-27-2000 | Nitrate | 0.006 |
| 04-27-2000 | Kjeldahl nitrogen | 0.58 |
| 04-27-2000 | Orthophosphate | 0.00 |
| 04-27-2000 | Phosphorus | 0.027 |
| 04-27-2000 | Total suspended solids | 1 |
| 04-27-2000 | Chloride | 19 |
| 04-27-2000 | Total Nitrogen, mixed forms | 0.886 |
Anonymous , One way is you can unpivot the Parameter column.
Another way is that you use that as legend along with slicer and limit no of line displayed
1 Reply
Anonymous , One way is you can unpivot the Parameter column.
Another way is that you use that as legend along with slicer and limit no of line displayed