# Response time - Behavior Partition function

**URL:** <https://community.dynatrace.com/t/response-time-behavior-partition-function/44096>\
**Category:** Dashboarding\
**Tags:** data-explorer, user-actions, dashboards-classic\
**Created:** [February 13, 2024, 10:38am UTC](https://community.dynatrace.com/t/response-time-behavior-partition-function/44096 "2024-02-13T10:38:05Z")\
**Posts on this page:** 9\
**Page:** 1

<div class="post-metadata">

**Author:** ![gbaudart](https://avatars.discourse-cdn.com/v4/letter/g/e47c2d/32.png) [@gbaudart](https://community.dynatrace.com/u/gbaudart)\
**Post date:** [February 13, 2024, 10:38am UTC](https://community.dynatrace.com/t/response-time-behavior-partition-function/44096/1 "2024-02-13T10:38:05Z")

</div>

Hi Community,  
I’m trying to plot a distribution of response times for a user action to display in a dashboard (Classic for now).  
I’m using the partition function to create a dimension with a distribution of response times:

 ![Partition_dimension.PNG](https://global.discourse-cdn.com/dynatrace/original/3X/6/8/68a429e9b7fb329eefa94bdcc82243dd4d79e717.png)

However, when I add up all the partition results, I don’t get the “Count” result for the action:

 ![Partition_count.PNG](https://global.discourse-cdn.com/dynatrace/original/2X/d/df1ba37401e44fef7385615e84c29f0111dfa7ad.png)

I’ve read a lot of documentation, tried several ways and even used Dynatrace’s Professional Services (ACE)… But I still don’t have any reliable answers&nbsp;😞

The community remains my last chance to refine the query or at least understand the result&nbsp;🙏

-Do you know why I can’t get the total “count” of the action?  
-Do you know what the values shown in my breakdown actually correspond to?

Thank you for your help&nbsp;😀

---

<div class="post-metadata">

**Author:** ![rastislav\_danis](https://avatars.discourse-cdn.com/v4/letter/r/b9bd4f/32.png) [@rastislav\_danis](https://community.dynatrace.com/u/rastislav_danis)\
**Post date:** [February 13, 2024, 12:50pm UTC](https://community.dynatrace.com/t/response-time-behavior-partition-function/44096/2 "2024-02-13T12:50:52Z")

</div>

your partition distribution does not count each xhr action. instead it counts response time buckets.

here is what is counted - number of bucket hits per timeframe, i have 2 buckets in my example:

 ![rastislav_danis_1-1707828637302.png](https://global.discourse-cdn.com/dynatrace/original/3X/8/e/8eb8028e3de1cbf8a4be07d5cc2821a9f651d407.png)

when you remove fold(count), you will see exact points when each bucket was hit during selected timeframe (cyan is \<200ms bucket, yellow is rest bucket):

 ![rastislav_danis_0-1707828533045.png](https://global.discourse-cdn.com/dynatrace/original/2X/d/d4a3106a7cea16acb574df2fcb47f34db70944ca.png)

---

<div class="post-metadata">

**Author:** ![gbaudart](https://avatars.discourse-cdn.com/v4/letter/g/e47c2d/32.png) [@gbaudart](https://community.dynatrace.com/u/gbaudart)\
**Post date:** [February 13, 2024, 1:53pm UTC](https://community.dynatrace.com/t/response-time-behavior-partition-function/44096/3 "2024-02-13T13:53:29Z")

</div>

[@rastislav\_danis](https://community.dynatrace.com/user/38440)&nbsp;,  
Each of my recorded actions (3.84k actions) has a response time that should fit into a bucket.  
So theoretically, if I add up all the hits from all the buckets, shouldn’t I get the total number of actions?

---

<div class="post-metadata">

**Author:** ![rastislav\_danis](https://avatars.discourse-cdn.com/v4/letter/r/b9bd4f/32.png) [@rastislav\_danis](https://community.dynatrace.com/u/rastislav_danis)\
**Post date:** [February 13, 2024, 1:59pm UTC](https://community.dynatrace.com/t/response-time-behavior-partition-function/44096/4 "2024-02-13T13:59:46Z")

</div>

but in fold(count) you just count buckets, not actions. f.e in my example, lower latency bucket (\<200ms) was hit 9 times so count of bucket \<200 (mistakenly named “0,100”😉 was 9, but in reality number of xhr actions with response \<200ms was much higher (several tens of actions in that timeframe)

---

<div class="post-metadata">

**Author:** ![rastislav\_danis](https://avatars.discourse-cdn.com/v4/letter/r/b9bd4f/32.png) [@rastislav\_danis](https://community.dynatrace.com/u/rastislav_danis)\
**Post date:** [February 13, 2024, 2:16pm UTC](https://community.dynatrace.com/t/response-time-behavior-partition-function/44096/5 "2024-02-13T14:16:55Z")

</div>

if you create partitions based on value you will lost number of items in partition buckets

---

<div class="post-metadata">

**Author:** ![gbaudart](https://avatars.discourse-cdn.com/v4/letter/g/e47c2d/32.png) [@gbaudart](https://community.dynatrace.com/u/gbaudart)\
**Post date:** [February 13, 2024, 2:29pm UTC](https://community.dynatrace.com/t/response-time-behavior-partition-function/44096/6 "2024-02-13T14:29:06Z")

</div>

OK.  
So how should I phrase my query so that I can count the number of shares in each bucket?  
I’m sorry, but I’m having a lot of trouble really understanding how the partition works.

---

<div class="post-metadata">

**Author:** ![rastislav\_danis](https://avatars.discourse-cdn.com/v4/letter/r/b9bd4f/32.png) [@rastislav\_danis](https://community.dynatrace.com/u/rastislav_danis)\
**Post date:** [February 13, 2024, 3:07pm UTC](https://community.dynatrace.com/t/response-time-behavior-partition-function/44096/7 "2024-02-13T15:07:09Z")

</div>

i’m afraid that partition is not right friend for your task 😉 and i’m also afraid this is not possible with pure metrics operations, because you have decoupled response times from counts and you cannot filter count metric based on reponse or otherwise (filter response metric based on counts).

I think only USQL will help you with this

---

<div class="post-metadata">

**Author:** ![rastislav\_danis](https://avatars.discourse-cdn.com/v4/letter/r/b9bd4f/32.png) [@rastislav\_danis](https://community.dynatrace.com/u/rastislav_danis)\
**Post date:** [February 13, 2024, 3:19pm UTC](https://community.dynatrace.com/t/response-time-behavior-partition-function/44096/8 "2024-02-13T15:19:02Z")

</div>

for example:

 ![rastislav_danis_1-1707837694818.png](https://global.discourse-cdn.com/dynatrace/original/2X/f/fd5a9463271bb72071bc2d1346b557d72150d36c.png)

---

<div class="post-metadata">

**Author:** ![gbaudart](https://avatars.discourse-cdn.com/v4/letter/g/e47c2d/32.png) [@gbaudart](https://community.dynatrace.com/u/gbaudart)\
**Post date:** [February 13, 2024, 4:09pm UTC](https://community.dynatrace.com/t/response-time-behavior-partition-function/44096/9 "2024-02-13T16:09:05Z")

</div>

Thanks !  
The result looks much better&nbsp;😀  
The problem is that it’s not very readable because I can’t graph it properly as a histogram or “Top list”&nbsp;😭
