41166_zh-CN

liliconcom

消费者研究：分类：按平均得分或总响应下降的订单

亲爱的社区，

 

我的以下脚本带有“ 平均得分顺序（ 1个 ）”，但不影响最终结果。Panel Box会产生这种影响吗？或者我做错了什么？

 

欣赏任何想法...。

 

 

 

Panel Box(
    "Resorts:YASMIN, Report:GSQ, SubReport:Marketing, Author:SaitCopuroglu,  " || Long Date( Today() ) || " "
     || Format( Time Of Day( Today() ), "h:m" ),
    Data Table( "Veri_SelectionsTest2016RESORTS.jmp" ) << Categorical(
        Grouping Option( Each Individually ),
        X( :Agency ),
        Responses( :Answer Categorical ),
        Frequencies( 0 ),
        Share Chart( 0 ),
        Legend( 0 ),
        Mean Score( 1 ),
        Std Dev Score( 1 ),
        Order by Mean Score( 1 ),
        Local Data Filter(
            Close Outline( 1 ),
            Conditional,
            Add Filter(
                columns( :Resort, :Year, :Record Date ),
                Where( :Resort == "YASMIN" ),
                Where( :Year == 2017 ),
                Where( :Record Date >= 01May2017 & :Record Date <= Today() ),
                Display( :Resort, Size( 123, 21 ), Check Box Display ),
                Display( :Year, Size( 110, 40 ), Check Box Display )
            )
        ),
        SendToReport(
            Dispatch( {}, "Categorical", OutlineBox, {Set Title( "YASMIN RESORT 2017" )} ),
            Dispatch( {}, "(Resort = YASMIN) and (Record Date == 22May2017)", TextBox, {Set Wrap( 1200 )} ),
            Dispatch(
                {},
                "Responses( Answer Categorical ) By Agency",
                OutlineBox,
                {Set Title( "Responses By AGENCY" )}
            )
        )
    )
)

 

回复：消费者研究：分类：按平均得分或总响应下降的订单

无需使用Excel即可解决该问题。  虽然解决方案不是最简单的，但分类平台的输出可以直接转换为JMP数据表。  下面是一个“非通用”脚本，显示了如何执行此操作。  可以将脚本转换为通用代码段，在大多数情况下都可以使用。

Names Default To Here( 1 );
dt = Current Data Table();
rpt = dt << Categorical(
 GroupingOption( EachIndividually ),
 X( :SECTION, :MARKET, :COUNTRY ),
 Responses( :VALUE ),
 Frequencies( 0 ),
 ShareChart( 0 ),
 Legend( 0 ),
 MeanScore( 1 ),
 OrderByMeanScore( 1 )
);

dtCountry = New Table( "Country" );

// Build the Country Coulumn
CountryString = Report( rpt )["Responses( VALUE ) By COUNTRY"][GridCellBox( 10 )] << get text;
// Buildthe list of Countries
CountryStringList = {};
WordCNT = 3;
While( Trim( Word( WordCNT, CountryString, "\!n" ) ) != "",
 Insert Into( CountryStringLIst, Trim( Word( WordCNT, CountryString, "\!n" ) ) );
 WordCNT++;, 

);
dtCountry << New Column( "Country", character, values( CountryStringList ) );

// Build the Percent Columns
dtCountry << New Column( "Çok iyi", Format( "Percent", 7, 2 ) );
dtCountry << New Column( "İyi", Format( "Percent", 7, 2 ) );
dtCountry << New Column( "Ortalama", Format( "Percent", 7, 2 ) );
dtCountry << New Column( "Zayıf", Format( "Percent", 7, 2 ) );
dtCountry << New Column( "Çok Zayıf", Format( "Percent", 7, 2 ) );
PercentString = Report( rpt )["Responses( VALUE ) By COUNTRY"][GridMultiCellBox( 2 )] << get text;
WordCNT = 1;
While( Trim( Word( WordCNT, PercentString, "\!n" ) ) == "", WordCNT++ );
RowCNT = WordCNT - 1;
While( Trim( Word( WordCNT, PercentString, "\!n" ) ) != "",
 TheLine = Trim( Word( WordCNT, PercentString, "\!n" ) );
 For( i = 1, i <= 5, i++,
  Column( dtCountry, i + 1 )[WordCNT - RowCNT] = Num( Trim( Word( i, Theline, "%" ) ) ) / 100
 );
 WordCNT++;
);

// Add the Total Responses Column
TotalString = Report( rpt )["Responses( VALUE ) By COUNTRY"][GridCellBox( 2 )] << get text;
TotalStringList = {};
WordCNT = 3;
While( Trim( Word( WordCNT, TotalString, "\!n" ) ) != "",
 Insert Into( TotalStringLIst, Num( Trim( Word( WordCNT, TotalString, "\!n" ) ) ) );
 WordCNT++;,

);
dtCountry << New Column( "Total Responses", values( TotalStringList ) );

// Add the Mean Column
MeanString = Report( rpt )["Responses( VALUE ) By COUNTRY"][GridCellBox( 4 )] << get text;
MeanStringList = {};
WordCNT = 3;
While( Trim( Word( WordCNT, MeanString, "\!n" ) ) != "",
 Insert Into( MeanStringLIst, Num( Trim( Word( WordCNT, MeanString, "\!n" ) ) ) );
 WordCNT++;,

);
dtCountry << New Column( "Mean", values( MeanStringList ) );

// Sort the table
dtCountry << Sort( By( :Mean ), Order( Ascending ), Replace Table( 1 ) );

回复：消费者研究：分类：按平均得分或总响应下降的订单

问题在于结果是交叉表报告（不是标准数据表）。  部分解决方案是将结果保存到Excel，然后在其中进行编辑。  例如：

NamesDefaultToHere(1);
dt = CurrentDataTable();
rpt = dt << Categorical(
 GroupingOption( EachIndividually ),
 X( :SECTION, :MARKET, :COUNTRY ), Responses( :VALUE ),
 Frequencies(0), ShareChart(0), Legend(0),
 MeanScore(1), OrderByMeanScore(1)
);
rpt << SaveExcelFile( "C:\Categorical.jmp",
 SeparateRowsForEachCellStatistic(1)
);

 

下一步是：

• 打开保存的Excel文件
• 手动删除不需要的Excel列和行
• 将数据保存回一个或多个JMP数据表
• 使用JMP表排序

 

回复：消费者研究：分类：按平均得分或总响应下降的订单

感谢您的回应。

我用脚本“ categorical”附加了一个简化的数据表。对于此特定分析，同样的问题是，是否可以根据总响应和均值对表排列进行升序或降序选择

我尝试对“ COUNTRY”列进行“值排序”，但是每当数据更新时，值顺序也会...

先感谢您

回复：消费者研究：分类：按平均得分或总响应下降的订单

您可以为此脚本提供样本数据表吗？