Create a weekly trending report in SAP BO

[Former Member]

Hi All,

Can you please let me know how can we design such a table along with the chart:

1) Need to create a following table:

Node Drive Utilization(last one day) Utilization(Last 7 days) Utilization(Last 14 days)

a D 50 55 60

a E 65 70 80

B D 33 44 49

2) Using above table need to create a trending chart:

(i) NODE -a Drive D

Y axis -Utilization.

X axis-Utilization(last one day),Utilization(Last 7 days),Utilization(Last 14 days)

(ii) NODE -a Drive E

Y axis -Utilization.

X axis-Utilization(last one day),Utilization(Last 7 days),Utilization(Last 14 days)

...

Please can anyone help me understand on how can we achieve this.

Thanks in Advance!!!

[former_member182342]

Hi Amit,

Can you provide the sample layout .

Regards,

Anish

[Former Member]

Hi Anish,

Thanks for the reply.

Firstly need to create the attached table.

Week 1 and week2 contains average utilization.

Can you please let me know how can we create this table.

Thanks in advance.