@scott Thank you so much! I tried a pivot earlier but I had the aggregate window AFTER the pivot and it was dropping columns I needed but your solution of aggregate window before pivot and map at the end works beautifully! I appreciate you!
Related topics
| Topic | Replies | Views | Activity | |
|---|---|---|---|---|
| Sum in map function | 1 | 1419 | January 5, 2022 | |
| Mathematic to different columns | 2 | 339 | April 10, 2023 | |
| Table view with multiple fields from multiple measurements/tables with where clause | 3 | 2328 | April 20, 2022 | |
| Problem with Map syntax | 6 | 436 | April 6, 2022 | |
| Compare values in 2 columns | 18 | 3370 | July 22, 2022 |
