As large organization, we're dealing with a large number of Ideas coming in. We need a way to pull various metrics type information to stay on top. Like to see fields such as <Number of days currently in particular state>, Avg time on a particular state for any given tribe/offering, etc. e.g. I have a table/pivot report of all ideas by their status. I want to show how many days each idea has been in the same state. Currently, this is not possible.
It is now possible to compute metrics like this using custom equations in reports.
To compute the time an idea or feature was in a particular status you can use an equation like
today() - field("Idea status changed to Needs review").