Hi,
i have import scheme
It builds like
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
measure0
[Property Key].CurrentHierarchyMember.Get("KEY")
measure1
[Property Value].CurrentMember.CurrentHierarchyMember.Get("KEY")
I need this type of report
believe there’s a working solution to import data structure?
What’s the data structure?
I’m Importing simple structure from
Project Properties
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
to EasyBI report, like this
Is it possible?
Hi,
It would be possible only if the “value0”, “Value1”, “Value2” and “Value3” are numerical values, not strings or texts.
Martins