Trend Chart

[#1]

HI All,

I have a requirement where it should show current trend and the last month's trend in a single chart.

Can any one please help in this..

Thanks

[alexandros17]

Please send me your example and I'll try to help

[#3]

my query is something like

Facts:

LOAD "call_date" as call_date1,

     fnf,

     idd

   FROM

(qvd);

PIE_TBL:

CrossTable(PRODUCT,VALUE)

LOAD  "call_date",

"idd" as "IDD"   ;

Facts:  

LOAD 

call_date,

idd,

FROM

(qvd);

[AsOf]:

LOAD

call_date1 as AsOfDttm1,

DATE(Subfield(DATE(call_date1),' ',1)) as AsOfDttm_Day,

MonthName(call_date1) as AsOfDttm_Month,

'Current' as PreviousCurrentFlag;

LOAD DISTINCT call_date1

RESIDENT Facts;

CONCATENATE ([AsOf])

LOAD

call_date1 as AsOfDttm1,

  addmonths(call_date1,-1) as call_date1,

  '1mback' as PreviousCurrentFlag;

LOAD DISTINCT call_date1

RESIDENT Facts;

[#4]

and in the graph i need date on dimension and trend on expression (line)

In expression: one should be current month and the other one 1 month before's trend..

Is this information ok.. please let me know if u need more..

Its very urgent.. I need to do it in an hour ..

please help