topic Re: Arithmetic expression with calculated metrics in Dashboarding

Arithmetic expression with calculated metrics

Malaik — Mon, 25 Oct 2021 07:43:22 GMT

Hello Members,

Im facing an issue.

I have 2 calculated metrics on RequestCount.

Example, in the last 1 Hour, I have 20 calls for one and 5 for the other showed in separated tiles on Dashboard.

I have another tile including the addition for both.

When I select the same time frame, I get No Data.

Please help us to fixe, its very urgent for the customer.

Good day.

Re: Arithmetic expression with calculated metrics

Julius_Loman — Thu, 21 Oct 2021 09:29:59 GMT

Not sure what is the issue here, but you are missing aggregations definitely and I can also see the timeseries are sparse and you want to have a single value anyway.

Can you try the following expression?

(calc:service.accountopening_success_requestcount:splitBy():auto:fold)+(calc:service.accountopening_notsuccess_requestcount:splitBy():auto:fold)

Re: Arithmetic expression with calculated metrics

Malaik — Thu, 21 Oct 2021 09:33:23 GMT

Thanks Julius for your help and feedback.

Yes I found it quickly before your poste, so with only adding

:splitBy()

Re: Arithmetic expression with calculated metrics

gilgi — Thu, 21 Oct 2021 14:54:36 GMT

As someone who is only getting to know the metrics expressions I find it the easiest to add 2 metrics to the data explorer, presented the way I want them to be and then just create the 3 by using the metric operation.

Re: Arithmetic expression with calculated metrics

Malaik — Sun, 24 Oct 2021 06:24:13 GMT

Hi @gilgi

With a screenshot, your comment will be better to understand.

Thanks.

Re: Arithmetic expression with calculated metrics

Malaik — Wed, 27 Oct 2021 10:14:10 GMT

Hi @Julius_Loman
Im facing a bug reported to Dynatrace.

When 1 of both metrics have NoData as result, the addition show NoData which is wrong.