Aggregation calculations on aws quicksight

Question

I am exploring Quicksight as BI UI. There are some required calculations that I am after and I couldnt find how can they be done.

1. How would you implement "count distinct" ?
2. How would you present an amount as percentage of total or of previous item in the series (I am trying to present funnel data in percentage)?

Thanks

Answer 1

1.Not Possible for now

Here is Reply from QuickSight Team -

We understand the need to count(distinct) and are working to add this into the product as soon as possible.

2.Not Possible QS teams Reply :

We currently do not support calculations across rows, but this is a planned item on our roadmap