Forum Discussion

johanhallin's avatar
johanhallin
Frequent Visitor
8 years ago
Solved

Import JIRA Custom Fields using Powerbi's JIRA Connector

Hi, I have been using Power Bi for a month or so now and really love it. I have managed to set up a couple of reports/dashboards using the Jira PowerBi content pack and it works great. I have change...
  • Anonymous's avatar
    Anonymous
    8 years ago

    johanhallin,

    Do you want to directly transform the list to Text and split Text without "Extract values"? If so, I am afraid that it is not possible.

    Regards,
    Lydia

johanhallin's avatar
johanhallin
Frequent Visitor
8 years ago

Hi,

that could work but I don't really like it. The problem is that I don't know how many items there is in the list. 95% of the time, it would be just one value. But it could be two values. In the future it could be many more values depending on how we set it up in Jira.

 

The values are text strings structured as:
"P1 Response: 1d 2h 32m 34s"

"P2 Resolution: 32d 14h 2m 12s".

 

So I would prefer the values to be translated to a text (string), maybe with seperated by a colon or semi-colon or something. Is that possible?

Anonymous's avatar
Anonymous
Not applicable
8 years ago

johanhallin,

Do you want to directly transform the list to Text and split Text without "Extract values"? If so, I am afraid that it is not possible.

Regards,
Lydia

  • johanhallin's avatar
    johanhallin
    Frequent Visitor
    8 years ago

    Ahh...ok! To bad but now I know that I'm not missing anything. I'll take a look at the extract values or maybe to do the calculations based on some extra dates instead to get the same information in Power BI without importing my cusotm field from Jira. 

     

    Thanks for replies!

     

    Kind regards, Johan