Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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.
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)
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)