Ratios in Graph

[ranorga]

I have a field called “Ratio” that is calculated by dividing field A by field B. When I make the graphs I don’t find the way to calculate the “Ratio” field for a group of data, because it is not the average “Ratio” of each cell. The correct “Ratio” must be the result of the sum of the A fields between the sum of the B fields. Is it possible that AppSheet correctly calculates this case?

[Aleksi]

Are you able to take a printscreen from that situation?

[ranorga]

Hi Aleksi:
The situation is that in graph I can show a ratio of one event but I can’t show a monthly ratio, because it is not al sum of ratios or average of ratio. Look this example:

In my app only existe this part:
Field A Field B Ratio
Record 1 30 10 3
Record 2 49 7 7
Record 3 10 5 2

Then you have the following options to show in a graph the ratio of all period:
SUM: 11 (3+4+4) is not correct
AVERAGE: 4 ((3+7+2)/3) is not correct
THE CORRECT ANSWER IS 4.05 ((30+49+10)/(10+7+5))
Is possible that AppSheet shows the correct answer in a graph?

[Steve]

Something like this?

(
  SUM(
    SELECT(
      MyTable[FieldA],
      ...
    )
  )
  / SUM(
    SELECT(
      MyTable[FieldB],
      ...
    )
  )
)

[ranorga]

Thanks for your answer Steve.

My problem is that I can’t get that a graph give me de correct answer. Look this example:

In my app only existe this part:
Field A Field B Ratio
Record 1 30 10 3
Record 2 49 7 7
Record 3 10 5 2

Then you have the following options to show in a graph the ratio of all period:
SUM: 11 (3+4+4) is not correct
AVERAGE: 4 ((3+7+2)/3) is not correct
THE CORRECT ANSWER IS 4.05 ((30+49+10)/(10+7+5))
Is possible that AppSheet shows the correct answer in a graph?

[Steve]

Change all of your column types from Number to Decimal.

[ranorga]

Thanks Steve, but it is not problem of format. Is the way that AppSheet calculate ratios

[Steve]

SmartD:

Is the way that AppSheet calculate ratios

I don’t see the option to calculate a ratio, so it doesn’t appear to me that the problem is “the way AppSheet calculate ratios”, but rather that it doesn’t calculate ratios. Are you’re asking that AppSheet add a RATIO option to the Group Aggregate property?