RE : Getting Daily / Weekly in one filter to changes view at that level

Q&A
, , ,
1

Hi Team,

I am looking to build a filter where I can click on Daily / Weekly and the views in the dashboard/ tab will change. I asked Q and it told me to first create a parameter having daily/ weekly in it and then creating field but that method doesn’t seem to work for my case. Any help me would be greatly appreicated ?

2

Hi @parthprj,

There are two ways you could accomplish this based on the route that works best for your current setup:

  • Build an ifelse calculated field that checks what your parameter value is, then handles the time aggregation with truncdate function. Then use this field in your visual.
  • Or, you can build two separate visuals, one aggregated to ‘day’ and the other aggregated to ‘week’. Then create rules for each visual that hides/shows the correct one based on the parameter selection. This will have to be done in ‘free-form’ layout as that is the only layout that allows rules to be utilized.
3

Hi,

I have created a parameter and then trying to create calculated field but just seems to be not working. Below is the formula I am using

ifelse(

${DateGranularity} = ‘Weekly’,

truncDate('WK', parseDate({cpt_date}, 'yyyy-MM-dd')),

truncDate(‘DD’, parseDate({cpt_date}, ‘yyyy-MM-dd’))

)

4

Hi @parthprj,

What about it does not seem to be working? How are you utilizing that calculated field in your visual? If you could provide a more detailed breakdown of the whole scenario, feel free to include a screenshot to better illustrate what’s happening so that we can better assist.