Hi there!
I have a CSV file that contains 2 items per entry, a quarter and a number representing a count of products. I have imported it into the Issues cube, and the number shows up as an available measure. I can’t actually use it anywhere though.
What I’d like to do is take the number of story points resolved in a quarter, and divide it by the number of products from the count, something like
[Story Points Resolved] / [Number of Products]
The CSV is formatted like so:
Quarter,Products In Legacy
2024.01.01,110
2024.04.01,100
2024.07.01,90
2024.10.01,80
2025.01.01,70
I can reformat that CSV any way I need to, it’s currently just hand created. Eventually it’ll be coming from elsewhere but for dev purposes it’s done manually.
I suspect because the jira story point calculations are done per issue and put together per specific date, and the CSV values are much broader with potentially no stories completed on that particular day.
If I have the [Number of Products] measures in columns, and the Quarter hierarchy level Time in rows, nothing shows in the table.
Any thoughts on what I can do to correct this?
Thanks!