What I want to do is group customers according to last active date; however, I have not found a way to do this except in the query editor which I'm not very familiar with.
What I have done so far is added a custom column in query editor: DateTime.LocalNow()-[Last Active Date]
Then I've inserted a round up column
Then I've created a conditional column that sorts the customers into groupings 1-2 months, 3-6 months, etc.
The problem though is that the Last active date column does not have a value on all rows which creates an error on those empty rows. I need to have some kind of IFERROR function here. How do I solve this?
However, I do not want to remove the rows that contains an error, because I still like to keep the client name in the report although it does not have a date. I only want to change the error to for exampe "No date" so I don't have to see the error each time I refresh the data.