I have a simple query table showing organization in rows and # of tickets in columns. I'm breaking down the ticket count for half years for the past two years. In the query, I have a row per organization and four columns (2017 H1, 2017 H2, 2018 H1, and 2018 H2). When I export to CSV or Excel, I'm getting four rows per organization - 1 row per half year - instead of having that data in four columns.
I get that I can make a pivot table in excel for this, but it would be nice if the export gave the data as it is presented in Explore rather than having to manipulate it again after my export.
Please sign in to leave a comment.