Jump to content
TNG Community
Sign in to follow this  
Appelmus

Frequency of causes of death?

Recommended Posts

Appelmus

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.

Share this post


Link to post
Share on other sites
Appelmus

it works.  Trial and error helped

Share this post


Link to post
Share on other sites

Create an account or sign in to comment

You need to be a member in order to leave a comment

Create an account

Sign up for a new account in our community. It's easy!

Register a new account

Sign in

Already have an account? Sign in here.

Sign In Now
Sign in to follow this  

×