Skip to main content
Announcements
SYSTEM MAINTENANCE: Thurs., Sept. 19, 1 AM ET, Platform will be unavailable for approx. 60 minutes.
cancel
Showing results for 
Search instead for 
Did you mean: 
farheenayesha
Creator
Creator

Problem with combo chart

Hi,

Can anyone help me to solve the problem displaying the proper values of discount % as line.

I have created a combo chart in which, Avg of order price are represented as bar and discount % as line.

Chart.PNG

I am getting proper values for avg of order price but i am getting 100%(straight line) for discount ,

Can anyone explain me why i am getting straight line and please suggest me how can i display proper discount %.

I want the graph as below:

Chart1.PNG

Please find the values and formulas below for reference:

Table.PNG

AOP=avg(ExtendedPrice)

vDiscount = (if(((sum(Order_List_Price)* sum(Orders_Quantity))-sum(ExtendedPrice))<0 or sum(ExtendedPrice)<0,0,(sum(Order_List_Price)* sum(Orders_Quantity))-sum(ExtendedPrice)))

Discount%  =  $(vDiscount) / Aggr((sum(Order_List_Price)*sum(Orders_Quantity)),O_BA_DESC)



0 Replies