Latest Daily/Month Production against Previous Day/Month

[akpofureenughwu]

Good day everyone,

I have a set of data that captures production in daily and month interval.

I would love to visualize the data showing latest( current) day production vs previous date productions as well as current month vs previous month.

Sample data ( current month vs previous month)

Year	Month	Station	Figure (Kg)
2010	January	Edo	56,000
		Delta	67,000
	February	Edo	78,000
		Delta	69,000

Sample Data (cuurent day vs previous day)

Date	Edo	Delta	Lagos
2013/09/29	30	50	100
2013/09/30	60	25	150

Thanks

[akpofureenughwu]

Good morning sir,

I  tried the script you suggested yesterday it didn't give me the desired result (see attached)

Here is the script

LIB CONNECT TO 'Planning';

LOAD *,

if( Isnum(Date), 'Q')& Ceil(Month(Date)/3) as Quarter;

LOAD *,

    Date(Date#(Year&Month, 'YYYYMMMM')) as Date;

LOAD if(Len(Trim("Year")) = 0, Peek ("Year"), "Year") as "Year",

    if(Len(Trim("Month")) = 0, Peek ("Month"), "Month") as "Month",

    "Field",

    Figures;

SQL SELECT "Year",

    "Month",

    "Field",

    Figures

FROM " Planning".dbo.Planning;

I would love to compare the current month vs previous month for each field ( there are like three fields)

Regards 

[sunny_talwar]

Which expression are you trying? Current Month or Previous Month? Also, are you making selections in Month or Year field?

[akpofureenughwu]

I'm trying the current month vs previous month....

I am making selection in date field since the date field is the combination of both month and year field..

Regards