Change x-axis in diagram from pivot table

[Alexander Finn]

Hello everyone,

I have the following diagram, which was created by the 5 small pivot tables below

as you can see, the days of the week are on the top right of the diagram and "completed", "incomplete" on the x-axis... I need it to be to other way round, resp. I need the weekdays on the x-axis... 

This is how it looks in the editor:

Thank you very much in advance

[Andrey Khaneev _StiltSoft_ · Accepted solution]

Hello Alexander,

Here is what I could get:

In the edit mode:

The SQL query:

SELECT "Count" AS 'Value',
SUM(CASE WHEN T1.'Monday' = "Completed" THEN 1 ELSE 0 END) AS 'Monday',
SUM(CASE WHEN T1.'Tuesday' = "Completed" THEN 1 ELSE 0 END) AS 'Tuesday',
SUM(CASE WHEN T1.'Wednesday' = "Completed" THEN 1 ELSE 0 END) AS 'Wednesday',
SUM(CASE WHEN T1.'Thursday' = "Completed" THEN 1 ELSE 0 END) AS 'Thursday',
SUM(CASE WHEN T1.'Friday' = "Completed" THEN 1 ELSE 0 END) AS 'Friday'
FROM T1

 

[Alexander Finn]

Legendary