Ubiq allows you to create drill-downs, drill-up and even drill-throughs
On your dashboard, Click 'Options' on top right corner of chart. You'll see the option to 'Add /Edit drill-down'. Click it to add or edit drill-down.
You'll see form where you can select the type of chart/table you want to display for drill-down, type the sql query to be used for drill-down chart and also provide the chart title
In your chart, when you click on table cell/pie slice or line point where customer_id=157, this query becomes
Click Save to save the drill-down. You can use joins, and complex queries in your drill-down chart. Ubiq supports them all.
Now, when you click on your chart, you'll see the drill-down for the corresponding value of the field you had dropped in X-axis box of your chart.
Here's a sample drill-down chart when you click on 'NYC' slice of pie chart