Appelmus Posted February 15, 2019 Report Share Posted February 15, 2019 Hello! When I draw up a report on professions, I get a repeat of the same professions as a result. How can I formulate the query to create a type of job with the number of its frequency? Best regards Appelmus PS How can I prevent output as a csv file? Quote Link to comment Share on other sites More sharing options...
Appelmus Posted February 15, 2019 Author Report Share Posted February 15, 2019 Unfortunately that does not work ☹️ Quote Link to comment Share on other sites More sharing options...
Appelmus Posted February 15, 2019 Author Report Share Posted February 15, 2019 Please show me the result in a report, similar to my example. Quote Link to comment Share on other sites More sharing options...
Scott_Pryer Posted February 15, 2019 Report Share Posted February 15, 2019 Works for me in 12.0.3 But if you just want a summary of occupations with the subtotal of occurrences: SELECT info as Occupation, count(info) FROM tng_events Group by Occupation order by count(info) DESC; the CSV file can be opened/viewed in Excel Quote Link to comment Share on other sites More sharing options...
Appelmus Posted February 15, 2019 Author Report Share Posted February 15, 2019 Hello Michael and Scott, now it works But Michael's proposal was in line with what I already had (see above). Only more columns were issued. Scott's proposal basically brings what I want, but the issue is not limited to professions, but provides a diverse collection of counted events Can this be changed? Unfortunately, I have no idea how to formulate such a database request. Thanks for your help Appelmus Quote Link to comment Share on other sites More sharing options...
Appelmus Posted February 15, 2019 Author Report Share Posted February 15, 2019 I found the solution in Henny Savenije-Reports https://tng.lythgoes.net/wiki/index.php?title=Category:Henny_Savenije_-_Reports https://tng.lythgoes.net/wiki/index.php?title=Report:_individuals:_events:_occupations_without_names_ordered_on_frequency 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.