Stacked Barchart-Counting Across Barchart Dimensions
Hi-
I am trying to build a bar chart that shows the count of issues in a sprint. My main fact table is called issues and has a field for both SprintName and OriginalSprintName.
My barchart dimension is SprintName. I have another field in my table "OriginalSprintName" and on my bar for each SprintName I want to include the count of IssuesIDs where OriginalSprintName=SprintName. I have a vague sense I can maybe use the TOTAL qualifier to do this but not sure how.
NM-It was easier to just calculate this as a field associated to the sprint name in the data load. But if anyone knows how to accomplish this to set analysis I am interested!
