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

Use the text [drill_down_value] where you want to insert drill-down value E.g, if customer_id is the drill-down field, here's a sample drill-down query
  select product, amount from sales_data where customer_id = [drill_down_value]


In your chart, when you click on table cell/pie slice or line point where customer_id=157, this query becomes

  select product, amount from sales_data where customer_id = 157

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


Apply global filters to drill-down reports

You can also add dashboard filters to individual charts by adding the text "[global_filters]" in the where clause of the chart's SQL query. This allows you to precisely apply the filters wherever you want in your chart's sql query


Individually apply global filters at different places in your drill-down report's SQL

To individually apply filters at different places in your query, add the text [global_filter1] in your query's where clause to apply only 1st global filter,[global_filter2] to apply only 2nd global filter and so on. Suitable for complicated sub-queries or nested queries.



Similarly, you can also add dynamic chart filters of parent chart to drill-down reports by adding the text "[dynamic_filters]" in the where clause of the chart's SQL query. This allows you to precisely apply the filters wherever you want in your chart's sql query

To individually apply dynamic filters at different places in your query, add the text [dynamic_filter1] in your query's where clause to apply only 1st dynamic filter,[dynamic_filter2] to apply only 2nd dynamic filter and so on. Suitable for complicated sub-queries or nested queries.