Forum Discussion
Combining Tables by Date
Sorry if a very simple answer, but I can't sort it. I have data by date that I can either put in 2 tables (red) or 1 long table (Blue). I'm guessing I may need to sort it by date (green), but not sure how. Ultimately I want a graph for Power ABC or Power DEF or sum by date. I also want a table with the peak of Power ABC, the peak of Power DEF, and the peak of the sum (column L). In this case peak of sum and sum of peak are the same (4), but in my data, they are not always the same. I'll need it to be scalable by 30-100 points if that changes your answer.
2 Replies
Anonymous just use the blue table, don't forget to name the first column and upload it. Green table can be achieved by a matrix visual where rows will be date and columns will be points(ABC, DEF). A measure can be created for sum. A multi line visual will work in this case where date as rows, power as column and points as legend.
Thanks for help on the matrix tool!
If I use the Matrix total, it takes the peak of one point, but if I do sum, it sums up all the points. I have a point every 5 minutes for a whole year. How do I sum just point ABC at a given time with DEF at that same time and then get the peak of that sum. It's important I get the peak of sums not the sum of peaks. You can see in this abbreviated chart that those are not the same. I want the greater of 3,630.80+37,67.70 and 3,642.50+3,567.00, not 3,642.50+3,767.70 for example. Does that need to be a if/then lookup formula?
