Have you ever wanted to give your viewers the possibility to filter a widget with a single click? Somewhat like the image below, that lets a user click on either the Best Selling Products or Least Selling Products and see the appropriate products in the pivot and their respective sales, cost and profit...

A typical dashboard or report has several widgets that require query execution in order to present up-to-date results. Some widgets may need to be updated frequently, some on a daily basis, or on a weekly basis - and so on. After you are done creating a dashboard, you can easily refresh it (by clicking...