How to show trend line of each month values in combo chart?

[#1]

Hi,

I have Dimensions and expression as below in combo chart

Dimension1:

if(match(Status,'Open'),Status)

Dimension2:

if(match(MONTH,'Jan 2015','Feb 2015','Mar 2015','Apr 2015','May 2015','Jun 2015','Jul 2015','Aug 2015','Sep 2015','Oct 2015'),MONTH)

expression:

=Num(MAXString(MAXDATE)-(MinString(MAXDATE) ),'#,##0')

I need to show the trend line of falling days for each month. Please can anyone suggest me what expression do I need to use?

Thanks.

[pamaxeed]

Can you post the app or a sample app here?

Patric

[pamaxeed]

[vishsaggi]

You can try In the Chart properties -> Presentation Tab -> Reference lines section -> Click on Add then give an expression using Aggr function. Something like

= Aggr(Num(MAXString(MAXDATE)-(MinString(MAXDATE) ),'#,##0'), Month)

If you can upload if possible a sample qvw will be easy to work on.

Thanks,
V.