How do I use properties

[grandeau]

When I imported my data, into my cube, I had several fields that I can choose as Dimension and/or Properties. I understand how they are used, as dimensions, but I’m not clear on how I use them as properties. By default I have been checking both (dimension and property), when i import.

I’ve finally found where those properties live, under Measures, Calculated members, Issue properties. But when I try adding one to a report I’m building, nothing happens. Any guidance on how to use properties would be greatly appreciated.

[martins.vanags]

Hi,

Thank you for this question.

When you import some custom field as properties, a new measure in “Measures” dimension is created with the name "Issue " that you could find in a list of “Issue properties” measures.

It can be used in calculations, however, it is displayed only on issue level (see attachment).

For example, you could select property measure for issues and sort issues by property value

Best regards,
Martins / eazyBI team

[pankajmehta]

Is there anyway to customize /group the values of a property. For eg. I would like to display Team Beta (which includes Team Bravo and Team Johny)

i.e. the table would looklike
SMT-12 ilze – Team Beta

Thanks

[martins.vanags]

Hi @pankajmehta

It would not be that simple to group property values for issues.
One solution for that would be a Javascript custom code in import options that would change the field value for an issue during import.
Please read more about this on our documentation page:
https://docs.eazybi.com/eazybijira/data-import/advanced-data-import-options/custom-javascript-code

Martins / eazyBI support

[pankajmehta]

Can i please get an example of what the code would look like? Below is what i am trying to get done

Current Statuses: Backlog -> Tech Analysis -> Dev In Progress -> Unit Testing -> Peer Review -> Lead Review -> Dev Test -> Done

I am trying to group
BackLog --> ToDo
Tech Analysis, Dev In Prgress and Unit Testing --> Development Started
Peer Review, Lead Review --> In Review
Dev Test --> In Testing.

Please advise.

Thanks

[martins.vanags]

Hi @pankajmehta

perhaps, you can find this post from earlier useful:

Value substitution

Hello, Is there any native way how to change imported values? For example we will have single select dropdown in JIRA issue with values Customer A - E-mail Customer A - Web Customer A - Social Because reports will be intended only for Customer A, then there is no reason to keep it there for purpose of reporting, but other (non imported) projects have also other Customers. Therefore we want to keep it in JIRA like this. Is there any simple chance how to adjust it in EazyBI just into: E-mail W…

Martins / eazyBI

[Piero]

@martins.vanags, is there any approach to count how many tickets w/ the same properties value? Thx!

Saying: we have properties as “Customer Name”, we want to count how many tickets filed from each customer.

[martins.vanags]

@Piero

In this case, you can import the “Customer name” as separte dimension from the import options page.
https://docs.eazybi.com/eazybi/data-import/data-from-jira#DatafromJira-JiraCustomFields
Then use use this dimension to split results.

Martins / eazyB

[Piero]

@martins.vanags, looks “Customer Name” only has option to import as Properties now, any chance to enhance this?

[martins.vanags]

@Piero
In this case, you would need to enable the dimension import using advanced settings
"dimension = true"

First, unselect the field and import data without the field (to drop default settings).
Then use custom field definition where you must use Customer Name custom field ID instead of NNNNN:

[jira.customfield_NNNNN]
data_type = "string"
dimension = true 

Then import field again as dimension and property

Martins / eazyBI support

[Piero]

@martins.vanags, thx for the guidance! I’ll reach out our eazyBI admin for this change.