Best Of

Hi @svetlana

You could always use a Pie or Donut Chart. Just in the General Chart Properties enter 3 as the maximum slices:

You can even get more details on the "Other" category by just moving your mouse over that pie piece:

Using a table card per @GrantSmith you can do something like this:

In this case, I added a Pareto to the drill path, but there is one extra step required in order to view all of the categories. You need to first drill into a single reason,

And then click on the "x" to remove the filter:

Conversely, you could just have the top three table card displayed above this pareto in a dashboard layout:

Hi @RajNadar

It would help to understand what format `Booking Year Nbr` is in.

CASE 
WHEN `Booking Year Nbr` = YEAR(CURDATE()) THEN 'CY' 
WHEN `Booking Year Nbr` = YEAR(CURDATE())-1 THEN 'PY' 
ELSE 'Other' 
END

Some minor tweaks to your beast mode:

CASE 
WHEN YEAR(`Booking Year Nbr`)= YEAR(CURDATE()) THEN "CY"
ELSE "PY"
END

@dgsinclair are you sorting by anything? That will usually mess up totals.

When you want to exclude something that contains a certain string, you need to use NOT LIKE. So your beast mode would look like this:

case when `EVENT_NAME` like '%Add-To-Cart%' and `EVENT_PARAMS_PAGE_LOCATION` not like '%/shop/%' then 'Add to Cart from XXX' end