How to assign and sort value in a card? And also pivot table?

[Bori Bor]

How do I assign a value number to a card? For examples I have 5 cards and I want to assign a number from -2, 3, 5, 9.5, 11. If I do it through sentence, instead of number, then when I try to sort based on alphabetical, then the sort will be messy.

Also if possible is there a function to total, average, min, max the value of a card like a pivot table in excel? And is it possible to also filter the card based on value, e.g. Just show the card with value > 6?

[Hannah Morgan]

@Bori Bor welcome to the community! I'd suggest using a custom numerical field. You can sort lists based on this field, and it is also possible to create a pivot table using Dashcards.