Hi, everyone! I’m trying to create a calculated field with this formula:
percentileRank([{total_revenue} ASC]),
where {total_revenue} is a numeric (float) value from SQL-script.
I’m getting error ‘Table calculation attribute references are missing in field wells’ (sourceErrorCode:
VISUAL_CALC_REFERENCE_MISSING) when I try to display created numeric field in a table. When I apply similar formula to another numeric values from the same dataset (e.g percentileRank([{total_txn_cnt} ASC])) it works perfectly as I expected and displayed correctly. What possibly could be the problem with the first formula? Maybe there’s some limitation to data that can be used as an argument for percentileRank?
Hello @dianak, my initial thought is that your table may require your {total_revenue} field as well for reference on the percentileRank calculation. If you are using it in a table, you can choose to hide that field from display if you only want the percentileRank calculation to show. Another thought is that the group by values of the table are not providing enough information for the field to calculate a percentileRank. It is possible that is causing issues as well. Let me know if either of those options help or provide any more detail about the issues, and we can try to figure out a solution. Thank you!
Thank you for advice! Putting {total_revenue} field as dimension into groupby part (while percentileRank([{total_revenue} ASC]) is a measure in value part) helped.
1 Like
Hello @dianak, I am glad that worked! Thanks for letting me know.