Incorrect Charts

PointsWell

I have 4 identical queries that search for:

FIND Finance_Cashbook WHERE Finance_Cashbook.ob_Statement.ob_Bank=LoggedInRegularUser.VPL_FinBankAcc ORDER BY Finance_Cashbook.DateTransaction DESC

Three of these identical queries are to produce charts.
The difference in the charts is the roll up of the date into days, weeks, months, years

However, except for the daily chart, they are producing nonsense.

Weeks are not in correct order (and don't add up to the total

Now not even close

PointsWell

And finally Annual comes to the same as month

Whilst the numbers should look like:

Only difference to all of these queries are the grouping on the X axis to Automatic, Week, Month, Year

aware_support

Did you specify Aggregation as SUM for the Y axis? Did you specify Base Unit for the X axis?

Have a look how this is done in the Sales Portal app.

If you are sure there is a bug please send the BSV and steps to reproduce the problem.

PointsWell

aware_support wrote
Did you specify Aggregation as SUM for the Y axis? Did you specify Base Unit for the X axis?

Have a look how this is done in the Sales Portal app.

If you are sure there is a bug please send the BSV and steps to reproduce the problem.

The issue is the Aggregation - it now works. From a usability point of view these two elements need to be closer together as the Aggregation is a completely separate popup.