Edited - that what i wrote was wrong.
I added after first getResourceModel:
->join('designer_product', 'report_viewed_product_aggregated_daily.product_id = designer_product.product_id', array('designer_product.product_id as p_id', 'designer_product.designer_id'))
->where('designer_product.designer_id=' . Mage::registry('designer_data')->getId());
And before it switch, with period type checking.
If daily is selected, it is ok.
But when i select monthly, or yearly i have error:
SQLSTATE: Cardinality violation: 1222 The used SELECT statements have a different number of columns
Ok, there are magically generated unions, and probably i have to create join to each union, am i right?
If yes, how can i do it?