Hi everyone,
I’m trying to create a dashboard that is able to use the ‘epic link field’ in our JIRA data to associate stories with their respective EPIC. The idea being that I can derive a value from the main EPIC to all related stories for analysis.
However, with my current solution I can’t use my calculated fields that accomplish this in a visual. I’ll detail my current approach below and would greatly appreciate if anyone can help me with this.
Attached is a picture of the functionality I want.
I am using a calculated field (cEpicLink) that finds the EPIC id value of every record via the formula below:
cEpicLink:
ifelse({Issue Type}=“Kanban Story”,{Custom field (Epic Link)},{Issue key})
Essentially, if the record is a Story then assume the ‘Epic Link’ key value, else if the record is an EPIC then use the main issue key field. Each story is related to one EPIC, so this calculated field allows me to group the epic and all associated stories via the main epic issue key.
Then I am using a second calculated field (testAssumption) to fill in a blank field of all the associated stories with the field value of the Epic. For example, the main EPIC record has an assumption field with the value “Innovation”. I want all of the associated stories to derive this from the EPIC and I’ve done this with the following formula:
testAssumption:
lastValue({Custom field (Assumptions)},[{Custom field (Assumptions)} ASC],[cEpicLink])
Thus, I’ve been able to successfully relate all EPICs and stories by creating the cEpicLink CF which groups all records by the EPIC key and then I’ve copied the value of the main EPIC 'Assumptions" field to the stories using the testAssumption CF. However, the issue is that when I try to use my testAssumption CF in a visual I can’t add it as a dimension and I get “Table calculation attribute reference(s) are missing in field wells” even if I add it as a measure. This isn’t an issue I’ve ever come across in Tableau when it comes to using calculated fields as dimensions. I’ve tried playing around with converting my calculated fields to a LAC-W but since the field I want is a string that isn’t working either. Any recommendations on this?