Best Of

There's an edge case which is causing the wrong labels. Try the following:

CASE WHEN `maint_count_between_restarts` = 0 THEN 0
WHEN `maint_count_between_restarts` > 50 THEN 50
ELSE CONCAT(FLOOR(`maint_count_between_restarts`/5)*5+1, '-', FLOOR((`maint_count_between_restarts`+5)/5)*5)
END

Since your buckets are the same size you can use some math and concat to calculate your buckets for you: You can take care of the end buckets first otherwise calculate the bucket name dynamically.

CASE WHEN `maint_count_between_restarts` = 0 THEN 0
WHEN `maint_count_between_restarts` > 50 THEN 50
ELSE CONCAT(FLOOR(`maint_count_between_restarts`/5)*5+1, '-', CEILING(`maint_count_between_restarts`/5)*5)
END

This will allow you to more easily calculate the buckets. In this example the bucket is 5 but you can change the 5 to whatever size bucket you want, just makre sure it's updated in all 4 locations.

You can create a separate beast mode for sorting:

CASE WHEN `maint_count_between_restarts` = 0 THEN 0
WHEN `maint_count_between_restarts` > 50 THEN 50
ELSE FLOOR(`maint_count_between_restarts`/5)*5+1
END

Hi Ritesh! It looks like you have it sorted by Alphabetically even though the X-Axis is a date type.

Click the little "ZA Arrow" sort button on the Y Axis, as shown in my screenshot, to toggle through different sort options. One of the sort options will be by date, as you are intending.

Doing it this way, you won't need the "Sorting" field populated because it'll sort in the card itself.

Let us know if this works,