280056_zh-TW

liliconcom

圖形生成器事件的累積計數

如何製作每月事件交換發生的簡單折線圖？即月份2 = 月份1+月份2 等等。

謝謝

數據探索和視覺化大規模客製化回复：Graph Builder 事件的交互計數

抱歉......要進行計數，只需將 Summary() 中的統計信息更改為 N

names default to here(1);
dt=Open("$SAMPLE_DATA/big class.jmp");

// Summarize the data
dtSum = dt << Summary(
 Group( :age ),
 N( :sex ),
 Freq( "None" ),
 Weight( "None" )
);

// Create the cummulative sum column
dtSum << New Column("Gender Cumulative Count", formula( Col Cumulative Sum( :Name( "N(Sex)" ) )));

// Generate the graph
dtSum << Graph Builder(
 Size( 534, 450 ),
 Show Control Panel( 0 ),
 Variables( X( :age ), Y( :Gender Cumulative Count ) ),
 Elements( Bar( X, Y, Legend( 6 ) ) )
);

</CODE></PRE>
<P>&nbsp;</P></LINGO-BODY><LINGO-SUB id="lingo-sub-280291" slang="en-US" mode="NONE">回复：Graph Builder 事件的交互計數</LINGO-SUB><LINGO-BODY id="lingo-body-280291" slang="en-US" mode="NONE"><P>謝謝。 我知道如何使用連續變量來做到這一點。 我詢問了交換計數，month1 有 2 個事件，month2 有 5 個，month3 有 1 個，所以我將顯示 2-7-8。</P></LINGO-BODY><LINGO-SUB id="lingo-sub-280079" slang="en-US" mode="NONE">回复：Graph Builder 事件的交互計數</LINGO-SUB><LINGO-BODY id="lingo-body-280079" slang="en-US" mode="NONE"><P>其他人可能有更簡單的方法，但這就是我會做的</P>
<OL>
<LI>使用 Tables==>Summary 對每個 X 軸組的測量列求和。</LI>
<LI>在匯總表中創建一個新列，即匯總測量列的 Col Cumulative Sum()</LI>
<LI>數據圖表</LI>
</OL>
<P><SPAN class="lia-inline-image-display-wrapper lia-image-align-inline" image-alt="cum.PNG" style="width: 730px;"><SPAN class="lia-inline-image-display-wrapper" image-alt="cum.PNG" style="width: 730px;"><SPAN class="lia-inline-image-display-wrapper" image-alt="cum.PNG" style="width: 730px;"><span class="lia-inline-image-display-wrapper" image-alt="cum.PNG" style="width: 730px;"><img src="https://us.v-cdn.net/6038925/uploads/images/25461i2F7D9B08DD7CA7C1/cum.PNG" role="button" title="cum.PNG" alt="cum.PNG" /></span></SPAN></SPAN></SPAN></P>
<P>交互式操作非常容易。但這是生成上圖的腳本</P>
<PRE><CODE class=" language-jsl">names default to here(1);
dt=Open("$SAMPLE_DATA/big class.jmp");

// Summarize the data
dtSum = dt << Summary(
 Group( :age ),
 Sum( :height ),
 Freq( "None" ),
 Weight( "None" )
);

// Create the cummulative sum column
dtSum << New Column("Height Cumulative Sum", formula( Col Cumulative Sum( :Name( "Sum(height)" ) )));

// Generate the graph
dtSum << Graph Builder(
 Size( 534, 450 ),
 Show Control Panel( 0 ),
 Variables( X( :age ), Y( :Height Cumulative Sum ) ),
 Elements( Bar( X, Y, Legend( 6 ) ) )
);