Forum Discussion
Solved
Challenge with my data in Column Chart
I have some data that looks like the following ID Date Opened Closed 1 1-Jan 1 0 1 1-Feb 0 1 2 1-Jan 1 0 2 1-Feb 0 1 3 1-Jan 1 1 4 1-Jan 1 0 4 1-Feb ...
Yes, that's the type of chart I want. My problem is that my data is not as nice as the data in your example. On a single row I can have both Opened and Closed. It's like I need a way to dynamically split that row into two, an Opened row and a Closed row. I'm not controlling the data that comes in, or I'd just change it at it's source.
| ID | Date | Opened | Closed | Attribute |
| 1 | 1-Jan | 1 | 0 | Opened |
| 1 | 1-Feb | 0 | 1 | Closed |
| 2 | 1-Jan | 1 | 0 | Opened |
| 2 | 1-Feb | 0 | 1 | Closed |
| 3 | 1-Jan | 1 | 1 | Both |
| 4 | 1-Jan | 1 | 0 | Opened |
| 4 | 1-Feb | 0 | 1 | Closed |
Hi,
There is nothing like "my example". My solution is based on the data that you shared in your first post. I have thereafter transformed your data in the Query Editor. Review the solution again.
So sorry. Completely missed the Pivot in the Transform. Yes, you nailed it. Thanks much.