How to filter in modelled data when there are multiple unordered rows in a parameter

I'm trying to add a column to a modelled data source that contains multiple rows. The values of these rows don't have set order but I'm only looking for the 'jira_escalated' tag to combine it with the id. When I try to add the tag column the tags aren't lining up with the id but each tag gets its own row in the column.

To take the screenshot as an example: id 9654 gets the tag 'goud' and the next id gets the tag 'jira_escalated' but they both belong to 9654.

How do I get the right tag(s) to line up with the right ids?

1 comment

  • Avatar
    Parker Selman Official comment

    Hi Kim, 

    Thanks for the post! 

    From this description, it sounds like you want to only display a tag for a ticket when that tag is 'jira_escalated'. I'll demonstrate a few different ways to get that sort of data below: 

    1) List all tickets in one column, and indicate the 'jira_escalated' tag in another:
    Column 1:
    Column 2:
    LOOKUP(&Column 1, GROUP(@/results[tags='jira_escalated']/tags/preceding-sibling::id),SELECT(@/results[tags='jira_escalated']/tags, @/results[tags='jira_escalated']/tags="jira_escalated"))

    This will align the jira_escalated tag to only appear on tickets that contain it. 

    If you're just looking for the tickets that contain jira_escalated, you can use the GROUP(@/results[tags='jira_escalated']/tags/preceding-sibling::id) formula to return the ticket ID that contain jira_escalated. 

    Hope this helps! If you have any further questions around this, let us know by logging a ticket with our support team at support@klipfolio.com



Please sign in to leave a comment.