I have a dataset with start and end time. From this, I have created a DataExpression with a field for elapsed time in minutes per feature, and a User field. I am using this in an indicator to sum up the total time, and I have a category selector to filter it per User. This works fine, but what I want is to show the elapsed time in hours:minutes for all features summed up, while still being able to filter it per user from the category selector.
I tried Arcade expressions using this method, but it creates one indicator view per feature, and not summed up for all features.
I cannot think of a good solution, unless I sum up all minutes for all features already in the DataExpression, but I am not sure if this is a good idea. Help me think, how could I best do this?
The DataExpression looks like this: