Finding Median of Dataset or create function to Datawatch

Ravi_22469

Hi All

 

I have the following dataset that I have managed to Model the data which is as I wanted.

 

I required from the "Response" values to calculate the "median". I know Modeller can do all sorts of functions, but could not find this one. I assume that modeller has not got this because the system has to order the dataset and pluck out the middle value. Or it is there and I am not seeing the correct function? This maybe a silly question but can you create your own functions, somewhere in the options of "Click to Add new function" or "manage external functions..."

 

Maybe someone can give me some advise on best doing this. Here is my data set. It is very straightforward in terms of modelling.

 

 

All advise welcome.

 

Thanks

 

Ravi

Altair Forum User

Hi Ravi,

 

Data Prep Studio has built-in feature to get the median of a dataset. You can open your report in Data Prep Studio and use Report Discovery to capture your dataset then in Prep Data you can transform your table by selecting Group By and then Median as the value.

 

Or use Classic to model your report and open dprj/dmod in Data Prep Studio in order to get the median via Transform Data - Group By.

 

Hope this helps

Mela

Altair Forum User

Altair Forum User said:

Hi Ravi,

 

Data Prep Studio has built-in feature to get the median of a dataset. You can open your report in Data Prep Studio and use Report Discovery to capture your dataset then in Prep Data you can transform your table by selecting Group By and then Median as the value.

 

Or use Classic to model your report and open dprj/dmod in Data Prep Studio in order to get the median via Transform Data - Group By.

 

Hope this helps

Mela

Hi Ravi,

 

Forgot to mention that Data Prep Studio comes with Monarch Complete.

 

Regards,

Mela

Altair Forum User

Altair Forum User said:

Hi Ravi,

 

Data Prep Studio has built-in feature to get the median of a dataset. You can open your report in Data Prep Studio and use Report Discovery to capture your dataset then in Prep Data you can transform your table by selecting Group By and then Median as the value.

 

Or use Classic to model your report and open dprj/dmod in Data Prep Studio in order to get the median via Transform Data - Group By.

 

Hope this helps

Mela

Hi Mela

 

I will reply to our first post. Many thanks for replying with an answer. Seems straightforward, I think if I understand correctly I have Monarch Classic (see screenshot below)

So any alterative approaches within one model, if not then either a summary or external lookup?

 

Thanks a lot

Ravi

Altair Forum User

Altair Forum User said:

Hi Mela

 

I will reply to our first post. Many thanks for replying with an answer. Seems straightforward, I think if I understand correctly I have Monarch Classic (see screenshot below)

So any alterative approaches within one model, if not then either a summary or external lookup?

 

Thanks a lot

Ravi

Hi Ravi,

 

Ah yes what you have is Monarch Classic.  Data Prep Studio came with Monarch 13 by the way.

 

If you have Monarch 12, I don't think you get the median with a single model since we need to get the total number of rows first using the summary and getting the count. We can export that summary and use it as an external lookup.  But that means you need to create another model with the same report file.  Classic can't use summaries as an external lookup.

 

Mela

Altair Forum User

Altair Forum User said:

Hi Ravi,

 

Ah yes what you have is Monarch Classic.  Data Prep Studio came with Monarch 13 by the way.

 

If you have Monarch 12, I don't think you get the median with a single model since we need to get the total number of rows first using the summary and getting the count. We can export that summary and use it as an external lookup.  But that means you need to create another model with the same report file.  Classic can't use summaries as an external lookup.

 

Mela

Hi Ravi,

 

May I make as small suggestion?  Download the trial version of Monarch Complete so that you can see how easy it is to get the median in a data set using Data Prep Studio.  The trial version can co-exist with your existing Datawatch Modeler 12.0 version.

 

http://www.datawatch.com/try-now/

 

Hope this helps.

Mela