Hello Everyone, I have a requirement in which I need to create a dashboard, which has separate panels for each sale category it is based up sale _type selected.  This chart should show up the time stamp and the time taken for the transaction call for that sale_category. For that I need one static dropdown which lists the sale_type and second one which comes up with categories dynamically upon selection of sale item. also, each category should have a separate panel which shows up the time and the duration of each call made. The table contains columns (Time_Stamp, Sale_type, Sale_Category, Min_value, Max_value, Mean_Value, count_calls) example: Sale_type => (Refreshments, Dinner, Lunch, Breakfast) Sale_Category=> Refreshments - (Juice / Milkshake / lassi) Dinner - (Pasta, chicken wings) Lunch - (Fried rice, Pizza) Breakfast - (Toast, Donut, Bagels)  So far, I'm using this. | dbxquery shortnames=t connection=xxx query="select sale_type,sale_category, avg(execmin) as min,avg(execmean) as mean, avg(execmax)as max from (Select sale_type,sale_category,execmin,execmax,execmean,object from XXX) group by sale_type,sale_category" | search sale_type=$saletype$ Thank you. ... View more