idafx / IDA-Framework

Intelligence Data Analytics Framework
http://ida2.krimnet.com
11 stars 3 forks source link

ida2.2 : new db table for daily data #63

Closed rajaiskandar closed 13 years ago

rajaiskandar commented 14 years ago

we need to move the daily data from palo to mysql.

this requires :

  1. using db table : data_daily (day, month, year, item_id, entity_id, geography_id, type, value)
  2. new spreadhsheet function : ida.day(dd, mm, yyyy, item_id, entity_id, geography_id, type) = value
  3. new data entry form for manual updating of the data
  4. new report for displaying the data in standard format

the date fields should be in the format: day : 01,....,31, month month : 01,....,12, year, quarter, half year : 1957,......

if this is workable, then we may want to test out either :

  1. using this table for all cummulatives
  2. having a data_month, data_quarter, data_halfyear, data_year for the respective cummulatives
towfx commented 13 years ago

feature done. closing issue.