Good afternoon, I would like some help regarding the calculation below.
ifelse(contains(House,“Green”) = true,1,0)/count(house)
Hi @GuiFox
The high-level steps involve, creating multiple variables with the correct order of evaluation. Here is a good example - click here). Then, perform the calculations based on this video.
Click here - full list of Pre-built functions.
In case you need further assistance with your problem, please create a sample dashboard with sample dataset showing your problem state using Arena and post it here. (Details on using Arena can be found here - QuickSight Arena
Alex
1 Like