Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
HI All,
i have a table like;
AccountOpen | OpenYear | ClosedYear |
AA1 | 2009 | 2012 |
AA2 | 2010 | 2012 |
AA3 | 2011 | |
AA4 | 2012 |
So in my front end, i would like to have a chart with dimension as OpenYear (which is my base year) and in expression would be the count of accounts closed
in the above table two accounts have been closed in the year 2012,
so my graph should say,
OpenYear | Accounts Closed |
2012 | 2 |
how can i achive this
Use ClosedYear as dimension instead and count(ClosedYear) as expression.
I cant use as its mandatory here, and my application is huge and has other impacts..