Appelmus Posted January 21, 2020 Report Share Posted January 21, 2020 Hello! I use a report by H.Savinije to show the frequency of certain causes of death. SELECT cause AS cause_of_death, COUNT(*) AS total FROM tng_events WHERE cause<>"" AND parenttag="DEAT" GROUP BY cause_of_death ORDER BY cause_of_death; This query doesn't work for me. I have recorded the cause of death under a custom event (_CAUS). How do I change the query to specify the frequency of events recorded in the custom cause of death (_CAUS)? Best regards A. Quote Link to comment Share on other sites More sharing options...
Appelmus Posted January 22, 2020 Author Report Share Posted January 22, 2020 it works. Trial and error helped Quote Link to comment Share on other sites More sharing options...
Dew Posted August 26, 2020 Report Share Posted August 26, 2020 I get no results when I run this report. I use eventtype DEAT (cause of death) to record the cause. Quote Link to comment Share on other sites More sharing options...
Recommended Posts
Join the conversation
You can post now and register later. If you have an account, sign in now to post with your account.