Skip to main content

I am attaching the twbx file.in that I have kept the Dateselector parameter where in the year ,quarter and month is selected.I am getting the data according to the selection.But the date axis for quarter and month is the same,it is not changing.It should change according to the selected month and quarter.And in the param_no I am entering the number of year, quarter and month.The sales data should be displayed according to the number of year, quarter and month depending upon the user given number form the latest date available to the given number.I have tried many ways, I am not able to find the solution.Please help me in this.Thank you In advance.

6 answers
  1. Oct 18, 2022, 9:41 AM

    see the 10th example of https://jimdehner.com/2022/07/05/parameters-how-tos/ it will show you how to use a parameter to select the data level in the chart

     

    and this set to true will filter to the number of values you want to see

    window_sum(countd( date((  DATETRUNC([DateSelector],[Order Date])))),first(),0)<=[param_no]

     

    Glad to help out and if this solves your problem please mark the response Best to make it easier for others to find and to close the thread

    Thanks

    Jim

0/9000