Hello experts,
I have two questions regarding the calculation of percentage by dimension values in my straight table.
I have this dimension called "Reasons" and the values are reason1, reason2,....,reasonN.
1) total IDs that have a reason is :
count(total {<Reasons={"=len(Reasons)>0"}>} ids)
and for percentage or each Nth reason in table I did:
count({<Reasons={"=len(Reasons)>0"}>} ids)/count(total {<Reasons={"=len(Reasons)>0"}>} ids)
First of all the total in table shows 102,4% (??!?! 😂), secondly, if i pick 2 reasons the percentages DON'T sum up...
and
2) I have another straight table with a drill-down dimension. I did
count( ids)/count(total ids)
but when i go to second level of drill down the percentages go crazy. I mean, if the first shown percentage was 10%, the second level i would expect to get divided into the subcategories, but that certainly doesn't happen...
I'm confused with what should be so simple 😫Help?