Planet MySQL Planet MySQL: Meta Deutsch Español Français Italiano 日本語 Русский Português 中文
Showing entries 1 to 3

Displaying posts with tag: Reports (reset)

Useful Reporting Queries for Your Business
+0 Vote Up -0Vote Down

I have rehashed a list of useful reporting queries from my blog which I hope people would find useful for their business or clients. These are not MySQL specific, by any means.

Orders

  • What is the total revenue (by segments)? - You are looking for 'peaks and troughs'. For example, found a peak season? you can plan better for it next year. Found an off-season? perhaps offer some deals for that period.
  • What is the total placed orders, completed orders and abandoned/uncompleted orders?
  • What is the total paid revenue vs outstanding orders? 
  • What is the total number of returned/cancelled …


  [Read more...]
Kontrollbase – graph “no data to display” on new install has been fixed
+0 Vote Up -0Vote Down

If you have been wondering why the overview and graphs pages say “no data to display” on the graphs when you first install Kontrollbase, it’s because there’s no data in the database being returned from the queries that generate the graphs – this is because a new install has no data to graph. This has […]

The Baden-Württemberg Brief
+0 Vote Up -0Vote Down
  • Two days in Frankfurt, two days in Munderkingen and two days in Heidelberg between December 5th and 17th. Mostly just ordinary working and travel days.
  • Visited Sandro Groganz of Init Marketing in Munderkingen. Worked from Sandro's house after a nice dinner on Sunday.
  • Caught up with (and was interviewed by) Rory MacDonald of Init Marketing while he was vacationing near …
  [Read more...]
Showing entries 1 to 3

Planet MySQL © 1995, 2014, Oracle Corporation and/or its affiliates   Legal Policies | Your Privacy Rights | Terms of Use

Content reproduced on this site is the property of the respective copyright holders. It is not reviewed in advance by Oracle and does not necessarily represent the opinion of Oracle or any other party.