I Only Want Rows which has the last day of the particular month
Hi @harshal98,
you can use the datetimeformat([date], '%Y%m') to get the year and month. You can then sort your data by month, and by date and finally use a sample tool to get the last row for each month.
Hoipe it helped!