Still not working with the newest queries I got, same error withe the group by clause (even twice this time)

Maybe this is more difficult then expected. because if I use this table and put it into an excel sheet and use pivot table then I can also get the date back, but again only per one date. Not all in once.

Example off the results I want (this is done manually now, each row is calculated manually), but want to get it automated

DateUnique logon

1-Jul0

2-Jul0

3-Jul0

4-Jul0

5-Jul0

6-Jul152

7-Jul40

8-Jul37

9-Jul217

10-Jul182

11-Jul159

12-Jul130

13-Jul135

14-Jul6

15-Jul16

16-Jul117

17-Jul118

18-Jul100

19-Jul98

20-Jul78

21-Jul6

22-Jul10

23-Jul85

24-Jul91

25-Jul75

26-Jul75

27-Jul59

28-Jul6

29-Jul7

30-Jul61

31-Jul75