Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
4 years ago

Dynamic Filter by Today's Period/Date

Sample File https://drive.google.com/file/d/1lysTi_VPXBGhGB1WUF05BDdF6DWOxUhE/view?usp=sharing     I have a date calendar table, and my Sales Table has an "Accounting Period" and "Shipped Date" Co...
Need Help
v-xiaotang's avatar
v-xiaotang
Icon for Community Support rankCommunity Support
4 years ago

Hi Anonymous 

Your sample file is currently unavailable. What problem are you experiencing now? What is not working as you expected?

 

Best Regards,

Community Support Team _Tang

If this post helps, please consider Accept it as the solution to help the other members find it more quickly.

  • Anonymous's avatar
    Anonymous
    Not applicable
    4 years ago

    Hi v-xiaotang, I shared my sample file with you yesterday. I accidently had the privacy settings on. 

     

    Basically, I want the a dynamic filter in the table with my shipment/sales data, that will only filter to rows in our current fiscal month, based on today's date.

     

    So, today 6/09/22 is our fiscal june. All rows with shipment data in june are considered for the values in my vizulization. 

    • v-xiaotang's avatar
      v-xiaotang
      Icon for Community Support rankCommunity Support
      4 years ago

      Hi Anonymous 

      Thanks for your reply. (and sorry for my late reply....

      Since the sample is not under import mode, I cannot see data in it...

      >>So, today 6/09/22 is our fiscal june. All rows with shipment data in june are considered for the values in my vizulization. 

      You want to filter the shipped dates in visual by today's date, for example, when today = 6/9/22, you want to get all the shipped dates in June, right? 

       

      Best Regards,

      Community Support Team _Tang

      If this post helps, please consider Accept it as the solution to help the other members find it more quickly.