Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
I need help in creating a line Chart with percentage of a measure along the time dimension, subsetted with a Type dimension.
So I will be able to see what is the percentage approval rate or non approval rate is for different months.
I am attaching the sample I have.
I think I have it.
=(Count({<begindate={'>=$(=Min(Date([Month Year])))'},enddate={'<=$(=Max(Date([Month Year])))'}>} country))/(Count(TOTAL <[Month Year]> {<begindate={'>=$(=Min(Date([Month Year])))'},enddate={'<=$(=Max(Date([Month Year])))'}>} country))