Hello Colleagues & Community,

I have a data column in HANA DB related to *duration*. For example, I have instrumented a mobile library, and am recording the results of various timers, together with information on the current conditions.

Since I am interested in a statistical view of the values, I would like to use a Box Plot in SAP Lumira (MIN, Q1, MED, Q3, MAX). I am exposing the data to Lumira via an Analytic View created in SAP HANA Studio. The Analytic View logically joins a data foundation containing the fact and dimension tables, with a time-series attribute view.

The issue or question that I am running into is: **How can I define a measure on the ***duration* column in the Analytic View, *without *specifying an Aggregation (COUNT, SUM, MIN, MAX) type?

The reason I think I want this, is that Lumira should be able to access the raw data points of the *duration* column, in order to calculate the Box-Plot quartiles. Instead, I'm seeing it attempt to calculate quartiles on the SUM of the *duration *column over the period, and it's just returning the SUM for all quartile values--a horizontal line.

Any ideas?

Thanks!! Stan

**Screenshots:**

Here is the raw data in HANA Studio

Here's the Semantic definition of the Analytic View (TIMERDURATION has Aggregation options: SUM, MIN, MAX, COUNT)

And, here's the Box Plot in Lumira (note that both values are the sum of the raw data above)

## Add comment