Average Value calculation

[haripriya_pampana]

Hi All

in the present bex report "average days" value is calculating as - "closed days" set to average aggregation with referece to "PersonID".

please guide me how to calculate averge days in HANA studio.

i have created calculated column but there is no option "reference to characterstic"

please let me know how to calculate.

[henrique_pinto · Accepted solution]

Did you try to create a counter on top of PersonId?

Then just define your calculated column as closed days / counter.

[haripriya_pampana · Accepted solution]

i have counter in measures. i have calculated Avg value with that.

when i connected to design studio dashboard... overall result showing  sum value for all periods.

it should display average value for all periods.

for example   calmonth     AVG

                     02.2014      2

                     03.2014      1

                     04.2014       2

                    -----------------------

overall result                     5   

                    -----------------------

please help

[haripriya_pampana · Accepted solution]

i have created the average value  in the projection node.

i deleted and i recreated in aggregation node.

now the values are fine.