Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hello
I would like to exclude a value within a dimension when I do a graph/table.
For example, my dimension is "Age" and I have three categories: "24 and below", "25 and over" and "Other".
What should I do to exclude "Other" from a graph/table?
I would like to exclude it in a particular chart/table and not the whole data-set uploaded.
Thanks
Ewa
Try this attachement,
= sum({<[Ethnicity general]-={'Unknown'},Attempts={"1"},Outcome={"COMPLETE"}>} FPE) / sum({<[Ethnicity general]-={'Unknown'}>} FPE)