This is regarding one of the issue which we are facing while generating report
We have column A , B and C value for this column contains data of type numeric
We have another column named "Date Reported" with the data type "date", we are applying some formula to calculate the value of column A, B and C. For the formula we need the value (like below) selected from Column named "Date Reported"
Since user can apply filter on the "Date Reported" , example filter selected is "Current : Month" then I want to get the number of days in the current month. Example 30days or 31days.
Similarly if user is selecting the filter with "Current : week" then value I am expecting is 7days.
These value shall be used in the formula for generating value in column A,B and C.
Please guide us with examples how it can be achieved.
Hello,
Thank you for contacting us.
Flexmonster does not support getting the number of days in a month or week from the filter out of the box. However, you can use the filterclose
event and the getFilter
API call to get the filter that the user has set. Please check the following example: https://jsfiddle.net/flexmonster/ybehnmjq/. Then, you can use the filter to identify, for instance, the number of days in the current month on your side.
We hope that the information provided is helpful.
Kind regards,
Nadia