Forum Discussion

CDavidOrr's avatar
CDavidOrr
Cloud Apps
08-11-2022
Solved

Date filter not working when specifying Months

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 fi...
dashboards & reporting
  • Angelina_QBeeQ's avatar
    Angelina_QBeeQ
    08-12-2022

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

     

harikm007's avatar
harikm007
Data Warehouse
08-11-2022

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

CDavidOrr's avatar
CDavidOrr
Cloud Apps
08-11-2022

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.