Import string property as measure

Hi,

i have import scheme

It builds like
image

What should I do to get value0, value1 as Measure?

@cybertachikoma
Only numerical values can be imported as measures.
In your case values are detected as strings. eazyBI can not calculate string as number.

Martins

May be there’s a way to transform Property to Measure after Import?

Hi,
Measures in eazyBI must be numerical values.
Please elaborate how can you transform a string value into a measure after import exactly?

Can you share some examples of “Value1” and “Value0” from your column mapping?

Martins

Just as experiment -

I can deal with value0, value1 as measure
image

measure0
[Property Key].CurrentHierarchyMember.Get("KEY")
measure1
[Property Value].CurrentMember.CurrentHierarchyMember.Get("KEY")

I need this type of report
image

believe there’s a working solution to import data structure?


What’s the data structure?

I’m Importing simple structure from
Project Properties
image

Hi,

“value1” and “value0” is not a number.
1, 2, 5, 19.2 are examples of a number.

eazyBI won’t let you import text or string as a “measure” for arithmetical calculations.
You can create properties that you already did, but those can’t be used for mathematical expressions.

If you want to use values as measures they must be numbers, not textual values like “value0” or “value1”

If “value1” is a number, you mast map it to “Measures” dimension and choose the measure name not to “Property value” dimension. And “PropertyID” field can be imported as separate dimension.

Perhaps you can illustrate the layout you want to build (not the one you got)?
How would your report look like?

Martins

Hi, sorry for mashed question

Let me start from beginning.
My task is to send this data from Jira
image

to EasyBI report, like this
image

Is it possible?

Hi,
It would be possible only if the “value0”, “Value1”, “Value2” and “Value3” are numerical values, not strings or texts.

Martins