Select columns based on column property value

Hello everybody,

I was wondering if someone could point me in the right direction regarding column properties. I have the following situation:

  • table with n columns
  • the columns represent measurements of different devices
  • some of those devices are physically in the same location
  • therefore I'd like to be able to group those columns together to be able to work with aggregated values

Is it possible to work with column properties to assign this kind of meta information (for instance location) to the indvidual columns? I'd like to be able to store the information in a calculated column as well as using it dynamically on charts.

Pseudo code: Sum( all_columns, where column_property = "locationA")

Thank you very much in advance,

(1) Answer