I have a JIRA cube, and i try calculate a funnel of recruitment process.
I put to Rows Statu and calculated measures to Columns.
I was able to calculate how much is ish is now in the status (in), how many was in a certain status (Was Ping)
But I can not calculate the metric (Was In) how much ishju was in the status from Raw but now in a different status.
I understand you would like to represent issue current status and historical statuses. For current status representation, you may use dimension Status and measure Issues created. On the other hand, to analyze issue change history, you might want to use measures and dimension designed for that, like, dimension Transition Status and measure Transition from status issue count.
One approach would be to create two separate reports, one with the current status and another with historical statuses, and place then side by side in the dashboard.
Another approach would be to represent current and previous statuses in one report by defining new calculated measures for each status. For calculations, you may use a tuple of status and measure. For example, to count issues which are currently in status “In” the tuple might look like this:
To count issues which were in status “Ping” a tuple might look like this:
([Measures].[Transitions from status issues count],
I have a workflow that an issue is sent to approval and may be rejected. If it happens, the issue must be re-worked by the agent and sent to approval again.
I would like to know how to count the number os issues rejected by time.
You may also count issues that had a particular transition, like, from status “Done” to status “In Progress”. In that case, use dimension Transition and select transition of interest Done => In Progress.
Check out those community posts on similar use cases to count re-opened issues: