I want to count the rising edge of a line chart

[Anonymous]

I want to count the rising edge of a line chart

There is a line chart as shown below.

Please tell me how to count the number of rising parts of this graph.

In the case of the graph below, it becomes count 3.

[Anil_Babu_Samineni]

Will you share sample application to get those?

[jyothish8807 · Accepted solution]

Hi Takafumi,

Try this:

Load *,

if(Previous(Val)=0 and Val<>0,AutoNumber(Val)) as New;

LOAD * INLINE [

    Prod, Val

    A, 2

    B, 0

    C, 2

    D, 2

    E, 0

    F, 3

    G, 3

    H, 0

];

Br,

KC

[Anonymous]

Hi Jyothish.

Thank you.

I was able to create the graph of purpose.

After that, I will make it with my own data.

[Anonymous]

thanks.

I could do it in the way below.

[jyothish8807]

You are welcome

[Anonymous]

I have another question.

What about the data in the csv file?

[jyothish8807]

Try this now

[Anonymous]

Thank you.

But what I want to make is to read arbitrary CSV files and count the edges of the graph.

[jyothish8807]

You can replace the inline table with your load script. The logic will remain the same.

Br,

KC