Enable sort by hidden fields in widgets

[soporteparaptx]

Hi,

It is a prevalent scenario or use case to use hidden fields in a widget to affect a KPI but not in the visualization. For example, If we need to sort by day number, and we have two fields, day number, and day name, we want to show to users day name in a graph but ordered by day number. We cannot do that now, so we need to concatenate both fields to perform this sorting. 

The best approach (as other vendors do) is to sort by day number, hide this column, and show the day name. The result is a graph orderder: Monday, Tuesday, etc. This is just an example, but it will be a great feature. Other vendors do it OOB. 

Thanks