Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
I have a dataset which have three fields
1. asset_serial_no (Not Unique)
2. created_on ( Date Field)
3. job_sheet ( Unique)
I have to count the no. of repeated serial no within 30 days and the condition is as follows:
I have implemented the below mentioned logic:-
Try this
COUNT({<Flag={'repeatRepair'}, YearMonth={"$(=Max(YearMonth))"}>} asset_serial_no)
Thank you for your response @Chanty4u .
It's not working.
I need the year and month selection based on the users choice for this I have created the Year and Month filter pane using created_on field.