question

Anusha Kodimela avatar image
Anusha Kodimela asked ·

Splitings on a transaction

Hi ,

I have a transaction has so many diferrent status numbers as shown in the below screenshot.

But i need to build a dashboard which should give result as follows.

     Measure                                                                          count

transaction1/status-------------------------------  10

transaction2/status-------------------------------  20

when i drilldown the transaction 1 all the 10 transactions,might be some having different number should come.

How am i supposed to split

10 |2000000 characters needed characters left characters exceeded

Up to 10 attachments (including images) can be used with a maximum of 50.0 MiB each and 250.0 MiB total.

Matthew Singleton avatar image
Matthew Singleton answered ·

Hi Anusha,

You have told me what you expect to happen but not what is happening. Your BT 'looks' like it should work, without the knowledge of the results are I cannot help.

Share
10 |2000000 characters needed characters left characters exceeded

Up to 10 attachments (including images) can be used with a maximum of 50.0 MiB each and 250.0 MiB total.

Anusha Kodimela avatar image
Anusha Kodimela answered ·

Hi Mathew previously we succeeded in getting all the status transactions getting split based on status.

For ex status.jpg has few requests with different status number.So my BT is giving count=10 and when I drilldown all the status transactions are coming.

Now my requirement is all the transaction that are coming for that BT should have a response time >=10 sec.For that reason i have used a filter measure as shown in the document attached.Could you please cross check and confirm ?.


status.jpg (49.5 KiB)
Share
10 |2000000 characters needed characters left characters exceeded

Up to 10 attachments (including images) can be used with a maximum of 50.0 MiB each and 250.0 MiB total.

Matthew Singleton avatar image
Matthew Singleton answered ·

What is happening?

Share
10 |2000000 characters needed characters left characters exceeded

Up to 10 attachments (including images) can be used with a maximum of 50.0 MiB each and 250.0 MiB total.

Anusha Kodimela avatar image
Anusha Kodimela answered ·

The BT should give all the status url's that have breached threshold of greater than 10 sec and the split measure is doing the job properly as configured.Kindly help me in this

Share
10 |2000000 characters needed characters left characters exceeded

Up to 10 attachments (including images) can be used with a maximum of 50.0 MiB each and 250.0 MiB total.

Anusha Kodimela avatar image
Anusha Kodimela answered ·

Hi @Matthew,

Please find the below BT that was configured and let me know the data that comes out of it.

The splitting measure will give the split of for example 10 status transactions,and my measure should give the transactions >10 sec for those status url's

psp-statusbt.docx


psp-statusbt.docx (83.3 KiB)
Share
10 |2000000 characters needed characters left characters exceeded

Up to 10 attachments (including images) can be used with a maximum of 50.0 MiB each and 250.0 MiB total.

Anusha Kodimela avatar image
Anusha Kodimela answered ·

 I tried to find the match found for the transformation regex as per the screenshot   BT_STATUS_4.JPG but it couldn't.

Share
10 |2000000 characters needed characters left characters exceeded

Up to 10 attachments (including images) can be used with a maximum of 50.0 MiB each and 250.0 MiB total.

Anusha Kodimela avatar image
Anusha Kodimela answered ·

Hi Matthew,

As per the above shown configuration,there was no data being captured bu the BT.

In BT_STATUS_3.JPG i have given the  URI pattern vale as Complete URI path.

Share
10 |2000000 characters needed characters left characters exceeded

Up to 10 attachments (including images) can be used with a maximum of 50.0 MiB each and 250.0 MiB total.

Anusha Kodimela avatar image
Anusha Kodimela answered ·

Hi Matthew,

The figure attached 2.JPG is the filter measure(not the splitting measure)

please find the configured BT screenshots attached.Made the splitting measure configurations as you have suggested.

BT_STATUS_1.JPG

BT_STATUS_2.JPG

BT_STATUS_3.JPG

Share
10 |2000000 characters needed characters left characters exceeded

Up to 10 attachments (including images) can be used with a maximum of 50.0 MiB each and 250.0 MiB total.

Matthew Singleton avatar image
Matthew Singleton answered ·

Change your filter to a Web Request - URI Pattern value, use value as /status/ and then use transformation regex as : (?:/[^/]){4}/([^/]*/[^/])

 

Share
10 |2000000 characters needed characters left characters exceeded

Up to 10 attachments (including images) can be used with a maximum of 50.0 MiB each and 250.0 MiB total.

Anusha Kodimela avatar image
Anusha Kodimela answered ·

2.JPG

 

Please note that there are overall 9 transactions which contain "status"

and each of the 9 transactions have multiple status numbers.

the screenshot status.JPG contains 1 of the 9 transactions which has 10 status numbers.

Share
10 |2000000 characters needed characters left characters exceeded

Up to 10 attachments (including images) can be used with a maximum of 50.0 MiB each and 250.0 MiB total.