Watch Build the Pumpjack Pro Sample App Webinar
Results 1 to 2 of 2

Thread: need help in creating query for DataSeries to make a graph

  1. #1
    Member
    Real Name
    Sylvain Amyot
    Join Date
    Oct 2012
    Location
    Montreal, Quebec, Canada
    Posts
    38

    Default need help in creating query for DataSeries to make a graph

    I need to create a graph per months. I am able to get my query working using 2 tables to gather the information needed, but if one of the table has no data for that
    month then it does not return anything. I need to show 0 for march if there is no data.
    This is the en result
    TIFGRAPHIC.png

    To get the data series I need to get data from 2 tables in order to calculate the values going in the graphic.

    My graphic needs to calculate TIF (TotalTifInjury*200000/TotalHrs) for every months. so if not data in march I have to show 0.

    I tried and now my head is not seeing it if anyone can direct me in the right direction it would be appreciated.
    Thanks.
    Sylvain

  2. #2
    "Certified" Alphaholic Stan Mathews's Avatar
    Real Name
    Stan Mathews
    Join Date
    Apr 2000
    Location
    Bowling Green, KY
    Posts
    24,473

    Default Re: need help in creating query for DataSeries to make a graph

    To have the graph show zero for a month with no activity you will have to add records for those months with no activity and put zero values in the fields you are graphing.
    If you're the smartest person in the room, you're in the wrong room.

Similar Threads

  1. How to make XY graph in Report?
    By nhchola in forum Application Server Version 11 - Web/Browser Applications
    Replies: 0
    Last Post: 09-19-2012, 11:03 PM
  2. Make Table query
    By MValentine in forum Alpha Five Version 8
    Replies: 9
    Last Post: 03-04-2008, 08:01 PM
  3. Creating a Template to make a Table
    By MoGrace in forum Database Design
    Replies: 10
    Last Post: 04-20-2007, 03:21 PM
  4. How do I make a browse display a query?
    By Brian Moses in forum Alpha Five Version 5
    Replies: 3
    Last Post: 07-27-2002, 01:31 PM

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •