Option to change the default field type of numeric field on import

Peter Michael Sørensen shared this idea 14 months ago
Idea Logged

I would like to add a configuration option to allow the default import behavior of a numeric field to be changed. Currently these default to metric fields instead of any other type.

Normally the most columns are dimension values and you would have only a small portion of metrics. When you create a view on a datawarehouse you always have a date dimension ex. year will automatically be set to a metric and I have to go in and change it to dimension and set the format. In a date dimension you sometimes also have different flags (0/1) like holiday or working day, last day in month/quarter/year, day and month number etc. All of these will be set to numeric because Yellowfin assumes that you want to aggregate by sum.