Hi @July, thanks for the detailed explanation.
The formula used to calculate the percentages seems to divide each number by the first number ( 103.869 ) (which corresponds to 100%) and then multiply by 100. The results are as follows:
- For ( 103.869 ), the calculation is ( (103.869 / 103.869) times 100 = 100% ), which matches the provided percentage.
- For ( 51.08 ), the calculation is ( (51.08 / 103.869) times 100 approx. 49.18% ), which matches the provided percentage.
- For ( 4.993 ), the calculation is ( (4.993 / 103.869) times 100 approx. 4.81% ), which does not match the provided percentage of ( 9.77% ).
- For ( 4.812 ), the calculation is ( (4.812 / 103.869) times 100 approx. 4.63% ), which does not match the provided percentage of ( 96.39% ).
Please can you provide the formula for the “off visual-field (customers (count distinct)” on how 4.993 and 4.812 percentage calculation is derived? Then we can find a pre-built function or create a custom formula that you maybe able to use from here.
Also, please try creating a sample dashboard with sample dataset using QuickSight Arena and share the link here.
Alex