EazyBI dimensions in columns

Question

Hi,

I preparing raport for my sale department. For now i put dimensions in row and this is quite OK. But my coworkers would like to have dimensions in columns. Problem is that, when i put dimension named Month of expected in column i get wrong results (look on screanshot).
 Value 54000 should by only in column 2, rest should be empty. Is any way to crate raport like that:

2019Q1Q2Q3Q4123456789101112            Issue 11234    1234      Issue 2            Issue 3  213

Month of expected is advanced custom field crated with Javascript, here is a code.

[jira.customfield_month_of_expected]
name = "Month of Expected"
data_type = "integer"
dimension = true
javascript_code = '''
var month = new Date(Date.parse(issue.fields.customfield_10810)).getMonth();
issue.fields.customfield_month_of_expected = month + 1;
'''

Janis Plume (eazyBI) · Answer

Hi,

Your approach with the Javascript custom field could be possible, but it will require a bit more complicated script and additional parameters.

Please, check the proposed solution of how you can import the Expected data as a measure and use the standard Time dimension to show the monthly Margins. That is the standard solution provided by eazyBI for your use case.

Note also that you are using the "Issue Margin (PLN)" measure in the report columns which is a property and works only at the Issue level. Please use the "Margin (PLN) Expected" measure, once you have imported the Expected date as a measure.

Kindly,

Janis, eazyBI support

Tomek_r9zug9 · Answer

@Daina Tupule eazyBIcould you help with that?