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
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
Community 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.