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
Solved! Go to Solution.
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.
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.
Fantastic! Thanks!
User | Count |
---|---|
41 | |
27 | |
27 | |
20 | |
13 |