Announcement

Collapse
No announcement yet.

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

Collapse
X
 
  • Filter
  • Time
  • Show
Clear All
new posts

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

    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).
    Attached Files

  • #2
    You should explicitly select 'Chart Columns'.

    Click image for larger version  Name:	Screenshot at 2021-07-13 13-20-38.png Views:	0 Size:	31.1 KB ID:	72414

    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.
    Last edited by yuri; 07-13-2021, 10:29 AM.

    Comment


    • #3
      Thank you for noticing!

      Laimonas

      Comment

      Working...
      X