Line Chart AOP

[jood_ahmad]

Dears,

it is possible to build in line chart two expression and pretense it on the same dimension like:

i need to build the AOP (Sales / Orders) on Day dimension  and i need on the same chart compare this AOP for each day with the previous day as long the month; so i will have for 1 month 2 line the first line for the current AOP and the second line for the AOP -1Day.

Message was edited by: Ahmad Kastero

Message was edited by: Ahmad Kastero THE LAST UPDATE WITHOUT TOTAL

[ecolomer]

Can you upload some data example and your expectative?

[jood_ahmad]

this the sample.

[jood_ahmad]

like we have 7 day in the week and i need to see with this 7 days another line to see the previous AOP on 7 days .

[ecolomer]

You have a day with no data

[jood_ahmad]

THIS IS THE TOTAL OF SALES & TOTAL OF ORDERS.

[ecolomer]

Is that you need?

[jood_ahmad]

thank you Enrique Colomer but not exactly.

can you see the attached pic the red line will be for the previous week so i can compare two week in the same time for the AOP.

[ecolomer]

I just do not understand.

Could you prepare some data in Excel and the results you expect?

[jood_ahmad]

something like the chart in excel ,

i use the first week and the 2nd week.