Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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.
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
Will you share sample application to get those?
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
Hi Jyothish.
Thank you.
I was able to create the graph of purpose.
After that, I will make it with my own data.
thanks.
I could do it in the way below.
You are welcome
I have another question.
What about the data in the csv file?
Try this now
Thank you.
But what I want to make is to read arbitrary CSV files and count the edges of the graph.
You can replace the inline table with your load script. The logic will remain the same.
Br,
KC