Grid report group by Month/Week order

Collapse
X
 
  • Time
  • Show
Clear All
new posts

  • lazovic
    replied
    partomas,

    If you remove the Order By value from your report, the months should be displayed in the correct order.
    We can consider how it works, using the example of Group By not a Month, but a Day with different Order By values.

    General settings of the report:

    Click image for larger version

Name:	Screenshot from 2022-12-15 14-24-52.png
Views:	283
Size:	37.3 KB
ID:	86364

    Order By is empty:

    Click image for larger version

Name:	Screenshot from 2022-12-15 14-15-40.png
Views:	268
Size:	29.8 KB
ID:	86365

    Order By SUM: Amount (converted) (ASC):

    Click image for larger version

Name:	Screenshot from 2022-12-15 14-15-29.png
Views:	264
Size:	26.3 KB
ID:	86366

    Order By SUM: Amount (converted) (DESC):

    Click image for larger version

Name:	Screenshot from 2022-12-15 14-15-13.png
Views:	272
Size:	32.2 KB
ID:	86367

    Leave a comment:


  • partomas
    replied
    There are a full screen of my settings. Click image for larger version

Name:	Screenshot 2022-11-05 at 10.43.14.png
Views:	276
Size:	833.7 KB
ID:	84840

    I need to sort accounts by total revenue, but there are no way to order by "created at" moths. In sample reports ordering by MONTH is available. Click image for larger version

Name:	Screenshot 2022-11-05 at 10.44.02.png
Views:	334
Size:	851.2 KB
ID:	84839

    Leave a comment:


  • lazovic
    replied
    Hi partomas,

    I cannot reproduce your problem. Could you send a screenshot of your full Grid Report settings? Of course, you can blur personal information.

    Leave a comment:


  • partomas
    started a topic Grid report group by Month/Week order

    Grid report group by Month/Week order

    I figured out that in Grid report if Month/Week is set as columns - the order of values is "random", as in sample. Does anyone has experience how to set consequenced order of months/weeks?
Working...