Dependent filter from date

#1

I’m having a ‘Dundas’ momement - where I realise that I’m trying to do something which may not be possible. Having scoured all help I’m hoping other users might be be able to help.

What I have:

  1. I have a Metric Set with a Date slicer and SurveyName slicer. There are rows and measures. being displayed (in a table)
  2. I have a date range filter that is connected to the metric set and correctly filters it.
  3. I also have a ‘Value’ filter showing the ‘SurveyName’ This filter is huge and lists ALL surveyNames (10k+ records).

What’s I’d like:
Because the Survey name filter is huge - I want it to be filtered by the date range filter. So the steps the user would take is to apply the date filter, The SurveyName filter would itself be filtered to only show the surveys that took place between the date range the user has selected and the user would then select one or more SurveyNames from the list to, finally, filter the metric set to their specific surveys.

I’ve tried a dependent filter. That is, I made the SurveyName filter dependent on the date range filter. When I use the dashboard and filter the dates - my visualization updates the metric set to show those records that took place between those dates - but when I open the Survey Name filter I get an error: Sequence contains No matching element.

I’ve used dependent filters before successfully, but never with a date range filter.

I’ve played with a bridge parameter too but didn’t get very far with that either

Any ideas / suggestions would be welcome.

Thanks

#2

How did you do this?
did you go into the SurveyName Filter and check date as dependent or did you go onto the date filter and check the SurveyName as dependent?

#3

As James mentioned, the correct order here would be setting the date filter to have a dependent filter which is the SurveyName filter.

For example, I have a Group (Continent) and Name (Country) columns. I added a filter on each but I need to define a dependent filter from the Group filter pointing to the Name filter.

image

#4

This has always seamed backwards to me and I usually just make every filter dependent on the other and it covers all my bases that way.
I forget to read the disclaimer text below “DEPENDENT FILTERS” saying any check filters controls will be filters by this filter, not the other way around.

#5

Thanks All,

I double checked and I’d done it the right way around. It’s a puzzle because I CAN get it to work with non date fields - but as soon as I introduce the date it throws a wobbly.

I will try with non hierarchy dates do see if that makes a difference - but now that all my data is in and warehoused - I might have to leave it for now.

My main concern was that I was doing something daft - (or there was no way of doing it with dates)

#6

It should work with dates, I would put a help ticket in.

1 Like
#7

Thanks all - So I figured it out. I thought I’d share the solution so others don’t have to waste a day going through the same pain. All fair play to Dundas though - they got in touch by email to try to help - I appreciated that.

Here’s the thing. When I was bringing a date across into my slicer - I was NOT selecting a hierarchy to use I was simply adding the field directly from the ‘add’ button in the metric set. This does not work (at least I was able the replicate the problem 100% of the time by doing this).

The weird thing was that Dundas was figuring out the hierarchy anyway in my calendar range filter - so everything SEEMED ok.

What you should do (at least what I HAD to do) was to expand the field in the explorer panel to display the hierarchies for my date field (I chose year - month - day) then drag the hierarchy into the desired location in your metric set (you can’t choose a hierarchy from the slicer ‘add’ button in the metric set).

When I did this - it worked as advertised. Boy I wish I’d know that 5 days ago!

2 Likes
#8

yea that pesky sudo date hierarchy that gets put on after the data cube not in the date cube makes it act differently.

#9

This helped me too…was facing same issue…Appreciate your help…!!!