Thanks for your help with this, it is much appreciated!
We have set up the import on Server as follows:
We have issues coming into the cube as you can see above and I can interrogate the attachments on each issue using the Issues dimension and the user defined measure that we made called Attachment (see screenshot below)
So far, so good.
I can also pull other information in from the Issues dimension by adding the relevant measures (see below):
However, one of the request types (this is a JIRA Service Desk Project) that we want attachment information from is a Customer Request Type called Post-trip report (see below where I’ve filtered using Customer Request Type):
These Post-trip forms are linked to the main travel form using an issue link in JIRA (we use the Blocks relationship for this):
The Post-trip forms contain their own unique information and simply link to the main travel form. As such, a Post-trip form will not have a category, it will be specified on the main travel issue to which it is linked.
We have defined a custom issue link in EazyBI as follows:
Which gives us a dimension we can use to query information through that issue link.
What I want to do, is query some of the information on the post-trip form and bring it into this table whilst retaining the attachment count for the post-trip form, and I just can’t do it:
As soon as I include the post-trip dimension, the attachment count disappears, so I go from this:
How can I display the attachment count for Post-trip reports, and on the same table show information that I’m pulling in from the post-trip reports like this:
This gives me what I need in the table, but no attachment count:
Grateful of your help as always