Bar chart data does not match Table data in Reports (Grind report, Entity: Task)

[Laimonas]

Description:

Values entered in Tasks are not represented correctly in Chart Bars (in Reports).

Steps to reproduce:

1. Crete first Custom field in Tasks:
Administration -> Entity Manager -> Task -> Fields -> Create field -> Float -> Enter value: Name = Test

2. Crete second Custom field in Tasks:
Administration -> Entity Manager -> Task -> Fields -> Create field -> Float -> Enter value: Name = Test1

3. Crete first Test Account:
Account -> Create Account -> Enter value: Name = Test Account A

4. Crete second Test Account:
Account -> Create Account -> Enter value: Name = Test Account B

5. Crete first Test Task:
Tasks -> Create Task -> Enter values: Name = Task A; Account = Test Account A; Test = 20; Test1 = 50;

6. Crete second Test Task:
Tasks -> Create Task -> Enter values: Name = Task B; Account = Test Account B; Test = 5; Test1 = 500;

7. Create a report “Test for bug report”:
Reports -> Create a Report -> Choose: Entity Type = Task; Grid Report = Create;

8. Enter values in Report:
Name = Test for bug report; Group By = Account; Columns = “Name”, “SUM: Test”, “SUM: Test1”; Chart type = “Bar (horizontal)”

Expected result:

Table Data should match Bar Chart Data

Actual Result:

Values entered in Tasks are not represented correctly in Chart Bars (screenshots attached).

[yuri]

You should explicitly select 'Chart Columns'.



If you do not specify chart columns, it does not assume that different float fields are comparable so it displays 2 axis report with different scale factors for y and y1 axes. You can see it if you choose the vertical bar type.

[Laimonas]

Thank you for noticing!

Laimonas