Skip to main content

Hi All,

 

I have a requirement where in the Order Date Range Filter I need to show 'Start of every month' and 'End of every month' date values together in the range filter as one slider. I tried to use two different parameter but it was not working. Please help and suggest.

3 answers
  1. Jul 29, 2022, 12:06 PM

    your data, in general, will not have records for the first day and for the last day in each month so you will need to create a calendar using a scaffold to have those dates in the data set see the first example of https://jimdehner.com/2021/02/19/faq-series-when-and-how-to-scaffold-data/- but more to the point you don't say what you are going to do with the dates - are you calculating sales by month _ (there are easier ways) or ending and beginning inventory (the problem is much more complex than simply knowing the start and end dates of each month

     

    Please explain the objective and when you can explain the goal please create a tableau workbook that reflects what you are trying to do so we have something to work from

0/9000