How to change the time filter dynamically with static choice

[inu]

Hi Team,

I created a static choice monthly, quarterly, yearly. one bubble chart will display the value accordingly.
Problem is here, what logic should i write for time filter. I have column in database as [Month key], [Quarter key], [Year key].

Please suggest, appreciate your response.


Regards,
Inam

[tjohnson3050]

It sounds like you don't want a filter, but a dynamic data item.  When the static choice is 'monthly' do you want to filter for certain months, or to show months on a chart?

If it's the latter, create a data item 'Dynamic Date'

case
when ?parameter? = 'monthly' then [Month key]
when ?parameter? = 'quarterly' then [Quarter key]
when ?parameter? = 'yearly' then [Year key]
else null
end