Forum Discussion
Merge (Union) or Measure or Pivot?
Hi kintera,
I am not sure your query and data sample, so I can't reproduce your design. If possible, could you please inform me more detailed informantion(such as your sample data and your expected output)? Then I will help you more correctly.
Please do mask sensitive data before uploading.
Thanks for your understanding and support.
Best Regards,
Zoe Zhi
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
Hi again Zoe Zhi! ...and anyone that might be able to help
My sample data is here
https://1drv.ms/x/s!An0PAO7bbUt9gc0RR5pmqmoFl7uIzg?e=E7IGFU1st Query
In my previous post, I referred to "Mtg1Late" and "Mtg1Late" (trying to make the communication easy). The data actually includes many "...Late" columns (7 in total). They all should be "OR" to result in "Late" ie (PrepareBasePlansLate=YES) OR (PlanReviewLate=YES) OR...Then, we can show which "Tsc" is late (ie Taylor, Oakland, etc). This is one of the series (or rows), renamed to Area (see linechart below)
2nd Query
The other portion of the dataset is for ysnRegion. It results in new Area's (two) called "RegionPM" and "NonRegionPM". I created a new column Area, and set the Area as follows: if ysnRegion = TRUE, then Area = "RegionPM", else "Non-RegionPM". This is another one of the series (or rows) and doubles the number of records.Both of these recordsets are used to count the number and show % of late jobs.
3rd Query
Again, I wanted to show the Total number of late jobs on the line charts.So in my description above, the "A, B, X, Y, Total" are the lines on the linechart above.
i hope I've explained it well.
I'm wondering if there is a more efficient way of doing it.
Thank you for any advise!
