Count total Aggregation in Heatmap

[Ambers_sp]

Hi all,

I am wanting to display a heatmap with %. I'm doing the below but it is not working:

(count({<[Order_Complete]={'Y'}>}[Order_Hash]))/
//(count(total Order_Hash))

aggr( count(total [Order_Hash]), [YearWeek], [Weeks_Open_To_Closed] )

The heatmap has the X-axis as YearWeek and is the raised order date, Y-axis is the number of weeks it took an order to close. All I want to do is have a % of how many orders were closed in that YearWeek. If I select one particular Yearweek then the above code works, but want it to do it without selecting one week only.

[Ambers_sp · Accepted solution]

I managed to solve this in the end, allowed to show nulls in the dimension field of the heatmap and changed the code slightly too:

(Aggr(RangeSum(Above(Count({<[Order_Complete]={'Y'}>}Order_Hash), 0, RowNo())), YearWeek, (Weeks_Open_To_Closed, (NUMERIC, ASCENDING))))

/
count(total <YearWeek> Order_Hash)