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
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