How to get the mid values from the line graph in Tableau

Question

Here I have datetime and the set of values. I am trying to find no.of. cycles in the line graph.

I would like to find the mid values from the line graph as i already found min, max values using lookup function. I need some assistance in getting mid values.

enter image description here

I need to capture the value before it rise . I can share my work book here but dont have an option here — jan nag
– jan nag, Commented Mar 21, 2023 at 14:15
I see that the points are located at an inflection. Is that what you mean by mid point. — Tarik
– Tarik, Commented Mar 21, 2023 at 14:58

Tarik · Accepted Answer · 2023-03-22 04:23:40Z

0

You can notice that all the points you are looking for are located between 12 and 16. Accordingly, filter your data with y between 12 and 16.

What you are looking for is the second derivative of the function that is above a threshold. To do that, shift your data and subtract one array from the other. That's the first derivative. Repeat the same process with the new array and get the second derivative. You can then use a threshold to pick up the points.

answered Mar 22, 2023 at 4:23

Tarik

11.2k2 gold badges31 silver badges48 bronze badges

Sign up to request clarification or add additional context in comments.

Collectives™ on Stack Overflow

How to get the mid values from the line graph in Tableau

1 Answer 1

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

Comments

Your Answer

Sign up or log in

Post as a guest

Related