Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 
sqlpuzzle
Contributor III
Contributor III

Percentage Line Chart

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.

1 Reply
sqlpuzzle
Contributor III
Contributor III
Author

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))