If I understand correctly then you are basically looking to see the data at a particular granularity (not fixed) based on user’s choice or desire. That kind of flexibility can be attained using parameter. There’s a similar post which can give you some idea on that. Please take a look at it.