EazyBI dimensions in columns

[Tomek]

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:

	2019
Q1	Q2	Q3	Q4
1	2	3	4	5	6	7	8	9	10	11	12
Issue 1	1234					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_]

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]

@Daina Tupule eazyBIcould you help with that?