Forum Discussion

kasife's avatar
kasife
Icon for Helper V rankHelper V
3 years ago

Filter last 3 months

Hi people, Guys, I'm trying to bring values from the last 3 months into a matrix and for that I used this filter   I filter the last 2 months and include today because I need the current...
Need Help
toribiolmSXP's avatar
toribiolmSXP
Frequent Visitor
3 years ago

Hi Kasife, what are the date values you have in your Date column? if you have there only one day of the month and is not within the filter context created by the 'Last 3 months' filter in your screenshot it wont show any date. i.e. if you have the 20 of each month in that column, the 20.06.2023 won't be included.

kasife's avatar
kasife
Icon for Helper V rankHelper V
3 years ago

 

toribiolmSXP What I did was use the calendar day in the segmentation

Because I would like to select a period, for example, from the 1st to the 23th of each month (last 3 months)

I have data on every day of the month.

 

  • toribiolmSXP's avatar
    toribiolmSXP
    Frequent Visitor
    3 years ago

    Hi Kasife,

    The date filter looks correct so I would start by hovering the mouse on the visual where June 2023 does not show any data and check in the funnel icon on that visual what filters are applied (just in case there is some other filter preventing this data to show).

     

    You can also add the day to the visual and review the data in table view, so you can double check what days are included.