Can't aggregate virtual number column?

I got a table where I add hours and minutes sepratly with sliders. I then have a virtual column that makes it into decimal-time. (minutes/60+hours) so I can calcualte total time easy.

Thing is in my chartview I want to use this as a SUM aggregate. But doesn’t seem like virtual columns show up there. Am I missing something or do I need to switch from a virtual to an actual column for my decimal time-number?

cheers
Martin

Simple solution… didn’t have it visible. Don’t want it to show in the form but I’ll solve that with a slice instead.

Once you have it added to the view for the aggregation, you can make “invisible” again. It will still be used in the view but will not be shown in other views nor available for selection in other column lists.

2 Likes

Fantastic! Thanks!