cancel
Showing results for 
Search instead for 
Did you mean: 

Date filter not working when specifying Months

CDavidOrr
9 - Travel Pro
9 - Travel Pro

I have a widget that is filtered by a date field.  When I set this filter, using "Calendar", it works fine.  When I set the filter using "Time Frame" and selecting any option under Years, it works fine.  Selecting any option under Quarters, it works fine.

However, when selecting any option under Months, it doesn't filter anything.  It is as if the filter is turned off.

I am looking for any suggestions that may help me troubleshoot this.  I'm sure it must be something in my specific configuration that is causing this but I don't really know where to look to see what may be going wrong.

I am currently on a standalone Windows version 20.21.4.10058.

1 ACCEPTED SOLUTION

Angelina_QBeeQ
10 - ETL
10 - ETL

Hi @CDavidOrr,
Check the widget behavior when it is filtered. It looks like you have the highlight option enabled

Angelina_0-1660311475534.png

 

View solution in original post

4 REPLIES 4

harikm007
13 - Data Warehouse
13 - Data Warehouse

Hi  @CDavidOrr , 

Can you share the formula you are using in widget? Just to check if you are using something like 'ALL([Months in Date])' in calculation.

-Hari

Of course.  This is a pivot table widget and the date field is one of the Row entries.  The type on this entry is Months.  There is no formula for it.  I am just including the date field from one of my Fact tables.  I then have a dashboard filter on that same column.

Here is some more interesting information.  I also have a Chart widget that contains this same date field as a Category.  It also does not filter correctly when I select Months.

I tried going to my pivot widget and disabling the dashboard date filter and adding that same filter directly to the widget.  When I did that, it works fine.  So it seems to be something in the interaction of the dashboard filter with the widgets.

Angelina_QBeeQ
10 - ETL
10 - ETL

Hi @CDavidOrr,
Check the widget behavior when it is filtered. It looks like you have the highlight option enabled

Angelina_0-1660311475534.png

 

CDavidOrr
9 - Travel Pro
9 - Travel Pro

Hi @Angelina_QBeeQ,

You nailed it.  That is precisely what the issue was.  I'm still getting used to the effects of that setting.

Thank you for your insight.