Announcement

Collapse
No announcement yet.

Grid report group by Month/Week order

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

  • 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?

  • #2
    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.

    Comment


    • #3
      There are a full screen of my settings. Click image for larger version

Name:	Screenshot 2022-11-05 at 10.43.14.png
Views:	149
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:	193
Size:	851.2 KB
ID:	84839

      Comment


      • #4
        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:	156
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:	135
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:	138
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:	137
Size:	32.2 KB
ID:	86367

        Comment

        Working...
        X