Trend line showing the combination of data?

[#1]

Hi,

I have two Line charts.

Chart A have

Dimension: Band

Expression: Sum(Number of Cases)

Chart B Have

Dimension: Band

Expression: Sum(Cases)

I want to combine the two charts. I need to show the trend line of sum of Cases when compared to last week and current week.

Can anyone suggest me please how to set this.

Thanks.

[#2]

Please see attached.

[bbi_mba_76]

Hi,

maybe I don't understand, but you could add an expression in the first chart with sum(Cases)

[#4]

Yes just now I did But I need the trend line which shows the decrease or increase of cases. Is it possible?

[bbi_mba_76]

So like sum([Number of Cases])-sum(Cases)?

[#6]

Thanks. I tried the same but it's not working. Any solution please?

[its_anandrjs]

Update :- Little change in the expression now check

For Week 15042014 Use

Dimension:- Band

Expression:- Sum({< Date = {'$(=date( WeekStart(Today())-6))'}>} [Number of Cases])

and For Week that is today 2304014

Dimension:- Band

Expression:- Sum({< Date = {'$(=Today()))'}>} Cases)

[bbi_mba_76]

this is not correct?

[#9]

Is it possible to show the trend line with these expressions?

[#10]

See attached.