Hello,
I would like to add Penetration Rate by "count of orders" to the Viz table, the [OrderM] is a custom group, please advise if this is possible.
Thanks for your help in advance
How is penetration rate calculated? Is it the # of Orders for that OrderM divided by the total # of Orders? If so, you should be able to use a Positional Calculation. Look in Birst Help for the topic "Positional Calculations" for more info, but it would be something like this:
[Order_Date: # Orders]/[Order_Date: # Orders{[DimensionThatHasTheAttributeOrderM.Total]}
Thanks a lot Cindy.
Yes, I think this Positional Calculation should work for me. But I still can’t get the correct result, please see the table.
I used below expression, looks like the calculation is not against total of 428, but 2. Eg Phone 66/2= 33, Email 139/2=69.5.
[oeeh_enterdt: # Distinct orderno] / [oeeh_enterdt: # Distinct orderno] {[OrderM.Total]}
Do you know how I’m able to get the correct result.
Unfortunately, Visualizer never Totals percentages correctly. Designer will correctly calculate the total of a percentage expression if you put it in as a Ratio expression, but Visualizer either gives you the sum of the percentages or the simple average of the percentages, both of which are incorrect. There is a whole conversation about this on another thread in the other Birst User Group Incorrect Sub-Summary Calculations using TopN Record Filter - Admin - Report Development - Birst - Customer & Partner Community - Infor Community
I suggest you open an Infor Support ticket about this. And if you need the report now, it may be best to do it in Designer.
