Percentage Calculation in Combo Chart

[#1]

Hi there. Really hoping someone can help.

I have created a stacked combo chart that shows the amount of orders that have been completed on time and overdue. To get this I have loaded in script:

If (actfinishdate >overduedate,1,0) as OverdueFlag

Then in chart properties I have 2 dimensions:

Week(Orderstartdate)

OverdueFlag

And the expression is Count(Distinct(OrderNumber)

This works fine and I am getting the bars to how I am expecting them to look.

My problem comes when I try to add a line chart into the graph to show the percentage of orders completed on time (OverdueFlag=0). I just cant seem to get the forumla right.

Can anyone help?

Many thanks in advance.

[Gysbert_Wassenaar]

Perhaps this: Count({<OverdueFlag={0}>}DistinctOrderNumber) / Count(DistinctOrderNumber)