You can easily setup drill-down charts in Vizard. Using ACROSS keyword in combination with AND (or ,) you can query across multiple Dimensions in your data. When you query across multiple Dimensions, you get drill-down charts. The order in which you specify the Dimensions in your query will determine the order of drill-down in the chart.
Let's say, you are interested in seeing the total Sales by each Category, and be able to drill-down into a Category to see total Sales by each Sub Category and finally be able to drill-down into a Sub Category to see total Sales by each Product. To achieve this, you may query as below:
SHOW SALES ACROSS PRODUCTS, SUB CATEGORIES, CATEGORIES
Note: The order of drill-down is right-to-left order of Dimensions in your query.