WAE yearly stats - Printable Version +- Swisslog's Forum (https://www.swisslogforwindows.com/forum) +-- Forum: Swisslog version 5.x (https://www.swisslogforwindows.com/forum/forumdisplay.php?fid=3) +--- Forum: General discussion (https://www.swisslogforwindows.com/forum/forumdisplay.php?fid=4) +--- Thread: WAE yearly stats (/showthread.php?tid=381) |
WAE yearly stats - DG7RO - 12-01-2018 Hello i need a statistic for working wae countries each year. So this year I need a stat with confirmed lotw,eqsl,paper-qsl for qso made only in 2018. I made a self defines stat as defined in the WAE-stat. I added a filter like this: SELECT Logbook.L_DATE FROM Logbook WHERE (((Logbook.L_DATE >= #01/01/2018#))) If I click on "view" in the stat defining window all seems to be good. A detailed view in the statistic windows shows only one qso... What's wrong here? Torsten, dg7ro RE: WAE yearly stats - EA3GCV - 12-01-2018 Hello Torsten, P_WAE is a field from the PQTH table and you are adding a filter in another table (LOGBOOK). You have to join first PQTH and Logbook tables. Edit the WCA statistic and see the example. In WCA: SELECT Logbook.L_DATE, PQTH.P_DXCC FROM Logbook INNER JOIN PQTH ON Logbook.L_CALLID = PQTH.P_CALLID WHERE (((Logbook.L_DATE >= #01/01/1995#) AND (PQTH.P_DXCC <> '%'))) In your statistic, select WAE instead of DXCC field and set the same filters so that the final SQL is like this: SELECT Logbook.L_DATE, PQTH.P_WAE FROM Logbook INNER JOIN PQTH ON Logbook.L_CALLID = PQTH.P_CALLID WHERE (((Logbook.L_DATE >= #01/01/2018#) AND (PQTH.P_WAE <> '%'))) Best 73 RE: WAE yearly stats - DG7RO - 13-01-2018 hi, work after a very bad misstake on my side a... arg. how sad....: I used often the new mode FT8 and this was NOT included in the mixed field in the stastik selection window! I have to use "All modes". 73 es tnx for helping and pointing into the right direction regarding the sql-statement. Torsten |