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.
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)