Cannot read properties of undefined (reading 'sortOrder')

[まとめページに戻る](https://qiita.com/Keiji_otsubo/items/60afc2a8d211b6f7d89f)
[まとめA～M](https://qiita.com/Keiji_otsubo/items/f3ddedee6793bf1576f8)



定期的に見かけるエラーです。

# Group and Categorize Your Data - [Cannot read properties of undefined (reading 'sortOrder')]

![image.png](https://qiita-image-store.s3.ap-northeast-1.amazonaws.com/0/328136/ef81de91-c63a-5719-a0e7-0a079d0ed421.png)


+ [Group and Categorize Your Data ](https://trailhead.salesforce.com/en/trailblazer-community/feed/0D54S00000G3Ylz)
+ [I am getting the attached error as well as the error The 'Opportunities by Rep and Close Month' summary format is not 'Matrix'. Please Help! :-)](https://trailhead.salesforce.com/en/trailblazer-community/feed/0D54S00000HDD22SAH)
+ ['Sorry to Interrupt' Error message in Group and Categorize Your Data project](https://trailhead.salesforce.com/en/trailblazer-community/feed/0D54S00000JeFwdSAF)

:::note
I did a work-around on this.. after i toggled the "Detail Rows" i ran the report, in the report after running it, i de-selected Stacked Summaries (no error).. went back to edit mode and then saved the report while the Stacked Summaries was de-selected.. hope this work around would solve your issue! 

私はこれを回避しました..「詳細行」を切り替えた後、レポートを実行し、レポートを実行した後、積み上げ集計の選択を解除しました（エラーなし）..編集モードに戻って保存しましたStacked Summaries が選択解除されている間のレポート..この回避策で問題が解決することを願っています!
:::

+ [【未解決】Report Not Opening in Lightning](https://trailhead.salesforce.com/trailblazer-community/feed/0D54V00007T2MBT)

![image.png](https://qiita-image-store.s3.ap-northeast-1.amazonaws.com/0/328136/0297e98d-402e-aa27-4384-fbc870d3f7f8.png)


# Uncaught TypeError: Cannot read properties of undefined (reading ’parent’)

+ [In the “Create Reports and Dashboards for Sales and Marketing Managers” Project, in the “Group and Categorize Your Data” unit, I am having screen reader issues](https://trailhead.salesforce.com/trailblazer-community/feed/0D54V00007ReYWFSA3)
+ [I am in the “Create Reports and Dashboards for Sales and Marketing Managers Project”. Under the “Use Summary Formulas in your Reports” section. I am having trouble because in that section they want us to create a “Win Rate” for all closed sales.](https://trailhead.salesforce.com/trailblazer-community/feed/0D54V00007RfYlj)

:::note
I ended up having to delete the object completely and redo it. Thank you so much.
:::

# The 'Opportunities by Rep and Close Month' summary format is not 'Matrix'. の時の回答例

+ [Error: "The 'Pipeline Matrix Report Current FQ' report does not appear to be using the Matrix Format."](https://trailhead.salesforce.com/trailblazer-community/feed/0D54V000077jzRh)

:::note
Click the arrow Down arrow icon next to Size and select Group Columns by This Field.

[サイズ] の横にある下矢印アイコンをクリックし、[このフィールドで列をグループ化] を選択します。
:::

+ [Solved Now! #TrailheadChallenges issue in 'Group and Categorize Your Data' Trail, Please Help](https://trailhead.salesforce.com/trailblazer-community/feed/0D54S00000JfsDVSAZ)

:::note
 You need 2 groupings, one on rows, one on column for a report to be in a "matrix" format.
 レポートを「マトリックス」形式にするには、2つのグループ化が必要です。1つは行に、もう1つは列にあります。
:::

+ [Group and Categorize Your Data (The 'Opportunities by Rep and Close Month' summary format is not 'Matrix'.)](https://trailhead.salesforce.com/trailblazer-community/feed/0D54S00000O5zSQ)

:::note
It's happening as you Group Rows by This Field instead Group Columns by This Field. Omit it and it will work.
このフィールドで列をグループ化するのではなく、このフィールドで行をグループ化すると発生します。それを省略すればうまくいきます。

https://trailhead.salesforce.com/trailblazer-community/feed/0D54S00000A8X2OSAV
:::



:::note
I had done the challenge with a Playground created before this one. The only step that wouldn't let me complete was Group and Categorize Your Data, with the rest of the steps there were no problems. Generate a new Playground and go through the steps again from the beginning until you get to Group and Categorize your Data. I completed the step successfully and it took subsequent steps as completed even though they were with the previous Playground.

このチャレンジは、この前に作成したプレイグラウンドで行いました。完了できなかった唯一の手順は、データのグループ化と分類であり、残りの手順は問題ありませんでした。新しいプレイグラウンドを生成し、データのグループ化と分類に到達するまで、最初から手順を繰り返します。ステップを正常に完了し、前の Playground を使用していたにもかかわらず、後続のステップを完了したものとして実行しました。
:::

:::note
I would recommend checking to make sure you do not have any duplicates of 'Opportunities by Rep and Close Month' That was my issue. I had two or three of those reports because I kept getting it wrong and it turned out to be a duplicate. 

「担当者ごとの商談とクローズ月」の重複がないことを確認することをお勧めします。それが私の問題でした。私はそれを間違え続け、それが重複していることが判明したので、私はそれらのレポートの2つまたは3つを持っていました.
:::

+ [The 'Opportunities by Rep and Close Month' summary format is not 'Matrix'.](https://trailhead.salesforce.com/trailblazer-community/feed/0D5KX00000MY3qw)

:::note
I can complete just Switching to classic and selecting matrix in the report. You'll see that Tabula formatting option. That was the only way I could do it.
:::





#  Their is unable to find a button called Stacked Summaries

+ [Create Reports and Dashboards for Sales and Marketing Managers - Group and Categorize Your Data](https://trailhead.salesforce.com/trailblazer-community/feed/0D54S00000Jg8Iv)

:::note
It seems it's because you didn't group columns by the closed date and then group it by month (steps 5 and 6)

 

Opportunity owner must be grouped by ROW first, then the option to group by Column for the CLose date should become availalbe. Once they are both grouped correctly the Stacked Summaries option should appear. 

https://trailhead.salesforce.com/trailblazer-community/feed/0D54S00000A9BfXSAV
:::

# The 'Pipeline Matrix Report Current FQ' report does not appear to have the bucket field configured correctly



+ [I am unable to pass the Group and Categorize Your Data module on the Create Reports and Dashboards for Sales and marketing Managers](https://trailhead.salesforce.com/ja/trailblazer-community/feed/0D54S00000CftCV)
+ [I am stuck on Group and Categorize your Data module](https://trailhead.salesforce.com/trailblazer-community/feed/0D54S00000JgBFv)
+ [I read through similar threads and I found out that I had too much of the same report.](https://trailhead.salesforce.com/trailblazer-community/feed/0D54V000074VMLy)

:::note
I ended up having two reports with the same name.  Once I deleted the older, incorrect report, the system was able to recognize that I had completed the steps correctly.  I read this strategy from another post.  

同じ名前のレポートが2つあったことが原因らしい。消したらＯＫ。
:::

+ [I am stuck on Group and Categorize your Data module](https://trailhead.salesforce.com/trailblazer-community/feed/0D54S00000JgBFv)

:::note
 I found there was no report named "The 'Pipeline Matrix Report Current FQ" in the "Global Sales Reports" folder.

「Global Sales Reports」フォルダに「The 'Pipeline Matrix Report Current FQ」という名前のレポートがないことがわかりました。
:::

+ [The 'Pipeline Matrix Report Current FQ' report does not appear to have the bucket field configured correctly.](https://trailhead.salesforce.com/trailblazer-community/feed/0D5KX000000NvEB0A0)

![image.png](https://qiita-image-store.s3.ap-northeast-1.amazonaws.com/0/328136/88f0c72a-e737-c5c5-5fc9-2920dfe4a5b6.png)



:::note
You have a typo on the word "Medium" in the bucket settings.
:::


# The 'Pipeline Matrix Report Current FQ' report does not appear to be using the Matrix Format.

+ [Group and Categorize Your Data:The 'Pipeline Matrix Report Current FQ' report does not appear to be using the Matrix Format.](https://trailhead.salesforce.com/ja/trailblazer-community/feed/0D54S00000KhwGx)

:::note
I solved it now. The problem was that I had saved multiple reports with the same name and only the most recent was edited with salesforce classic (in matrix format). 

今解決しました。問題は、複数のレポートを同じ名前で保存していて、最新のものだけが Salesforce クラシック (マトリックス形式) で編集されていたことです
:::

# The 'Pipeline Matrix Report Current FQ' report does not appear to be grouped by the Opportunity Owner field

+ [【未解決】please help on - The 'Pipeline Matrix Report Current FQ' report does not appear to be grouped by the Opportunity Owner field](https://trailhead.salesforce.com/trailblazer-community/feed/0D54S00000JgCqE)
+ [The 'Pipeline Matrix Report Current FQ' report does not appear to be grouped by the Opportunity Owner field.](https://trailhead.salesforce.com/trailblazer-community/feed/0D5KX000000OObR)

:::note
Opportunity Name -->  Opportunity Owner
![image.png](https://qiita-image-store.s3.ap-northeast-1.amazonaws.com/0/328136/718caa64-20d6-81cb-8881-7a1f41463eb6.png)
:::




# The 'Pipeline Matrix Report Current FQ' report still contains some of the fields that need to be removed. Please check the requirements.

+ [[【未解決】Group and Categorize Your Data](https://trailhead.salesforce.com/trailblazer-community/feed/0D54S00000Jge56SAB)


# Lightning Experience のレポートおよびダッシュボードの単元「レポートの形式設定」のChallengeのエラー

+ [Lightning Experience のレポートおよびダッシュボードの単元「レポートの形式設定」のChallengeのエラーの解消方法をご教示ください](https://trailhead.salesforce.com/en/trailblazer-community/feed/0D54S00000FxcznSAB)

検索条件のフィルター項目で[作成日]を選択し、検索条件の編集画面で [範囲：常時] を選択します。[適用]をクリックします。これでクリア条件「範囲：常時」を設定できました。 

日本語の指示ではこんな感じ。訳が違っている。

標準の検索条件:
日付: オープン日
範囲: 常時

# Create Reports and Dashboards for Sales and Marketing Managers
 
+ [“Create Reports and Dashboards for Sales and Marketing Managers” Project](https://www.linkedin.com/pulse/create-reports-dashboards-sales-marketing-managers-project-amit-kumar)

+ [Keep getting 'Could not find a report named 'Opportunities by Rep' in the 'Global Sales Reports' folder.' error](https://trailhead.salesforce.com/ja/trailblazer-community/feed/0D54S00000Jd7eW)

:::note
 I completed it. I was in the wrong org.
:::

+ [Could not find a report named 'Sales Rep Win Rates' in the 'Global Sales Reports' folder. this found in use summary formulas](https://trailhead.salesforce.com/trailblazer-community/feed/0D54S00000PezXi)

:::note
 Actually there were multiple reports with the same name that is why it was stuck, sorted now.
:::


# The 'Opportunities by Rep and Close Month' report does not seem to grouped on 'Close Date' by Calendar Month.

+ [am stuck on Group Data in Reports](https://trailhead.salesforce.com/ja/trailblazer-community/feed/0D54S00000Jg5PaSAJ)

:::note
 I found that the issue was due to duplicate reports with the same name. Challenge is working perfectly after deleting the two incorrect reports.

 ![image.png](https://qiita-image-store.s3.ap-northeast-1.amazonaws.com/0/328136/69bddae2-c73f-3c52-5609-84875926b52c.png)
:::

+ [HEY, how can i fix this error? please guide me steps Thanks](https://trailhead.salesforce.com/trailblazer-community/feed/0D54V00007TsFtu)

:::note
Go to the Reports tab and check if there is only one report named 'Opportunities by Rep and Close Month' present, if there are 2 reports present delete any one of them and follow the correct steps in the report.

In this case first step is to check that you have followed all the instruction carefully and still if you are facing same error you can try this:Make sure you select the "Group Columns by This Field"  on "Close Date" and not "Group rows by this Field". 

https://trailhead.salesforce.com/trailblazer-community/feed/0D54V00007T4CMxSAN

[レポート] タブに移動し、「担当者別の商談と成約月」という名前のレポートが 1 つだけ存在するかどうかを確認します。レポートが 2 つある場合は、いずれか 1 つを削除し、レポートの正しい手順に従います。

この場合、最初のステップは、すべての指示に注意深く従ったかどうかを確認することですが、それでも同じエラーが発生する場合は、次のことを試すことができます。「終了日」で「このフィールドで行をグループ化」ではなく、「このフィールドで列をグループ化」を選択していることを確認してください。
:::

+ [【意味が分からん】Opportunities by Rep and Close Month--This topic is supposed to grouped by 'Close Date' which is done but still challenge is not passing. What should I do?](https://trailhead.salesforce.com/trailblazer-community/feed/0D5KX00000KE9iz)

![image.png](https://qiita-image-store.s3.ap-northeast-1.amazonaws.com/0/328136/206c69ea-d3c9-436b-bd17-13a5b6eb5876.png)