I'm trying to make a simple chart to show the number of records (executesql count(*) )present with data in y for each record in x (which is a date). The problem is the chart only shows the count for the first record.

 

How do I get the the calculation in the y-axis to be done for each record in the x-axis?

 

Code:

x-axis:

ExecuteSQL ( "select distinct Event_Date from Log order by Event_Date asc" ; "" ; "")

y-axis:

 

ExecuteSQL("select count("An Event") from Log where Event_Date = ?"; "";"" ;Log::Event_Date)

Using delimited data, data source

 

 

Thanks for your help

 

 

The problem is the chart only shows the count for the first record.

ExecuteSQL("select count("An Event") from Log where Event_Date = ?"; "";"" ;Log::Event_Date

 

The WHERE clause in your query restricts the result to the first related record in the Log table. Since the x-axis calculation gathers all existing dates, do the same for an aggregate calculation of the y-axis values:

ExecuteSQL ( "
  SELECT COUNT (*)  
  FROM Log 
  GROUP BY Event_Date
  ORDER BY Event_Date
  " ; "" ; ""
)

Thanks for your help, and for getting me to understand.