Beast Mode, text field and number together

user00087

Hi,
I want to show avg price based on the text field (section). But can't get those 2 together 

date	price	sec
12.18	120	loge 4 b
12.18	485	loge 4 a
12.19	22	loge 20 b
12.19	48.5	floor ga
12.20	18	terrace 14
12.20	527	floor
12.20	785	floor

For example, for this 14th December, It would be awesome if I could see for this balcony 3l avg price for that section for that date

Thank you in advance.

Jarvis

Hello user00087,

You should be able to find the average of this field by re-configuring it's format within the Analzyer tool, if the field is categorized as numeric. However, you may need to use a Beast Mode calculation or Dataflow if the field is not numeric. In order to get the best idea of how this would be accomplished, I would recommend contacting your Domo account team with a link to the dataset you're currently working with.

 

Thanks!

 

- Jarvis