立即与支持人员聊天
与支持团队交流

Unified Communications Analytics 8.8.3 - Resource Kit

Using Power BI Desktop to create a bar chart for Exchange public folder item counts

The following example shows you how to create a vertical bar chart for public folders that shows the number of items in each public folder on a particular day.

3
Clear (Select All Columns).
4
Select Key, Fullpath, ItemCount, Name, and SnapshotDate and click OK.
5
Right-click SnapshotDate and select Change Type.
6
Select Date.
2
Drag the Name and ItemCount fields, listed in the Fields pane, to the Axis and Values labels respectively.
4
Locate IPM_SUBTREE and clear the check box.

Using Power BI Desktop to create a trend for item counts in an Exchange public folder

The following example shows you how to create a trend that shows the number of items in a specific public folder over time.

3
Clear (Select All Columns).
4
Select Key, Fullpath, ItemCount, Name, and SnapshotDate and click OK.
5
Right-click SnapshotDate and select Change Type.
6
Select Date.
2
Drag the SnapshotDate, Name, and ItemCount fields, listed in the Fields pane, to the Axis, Legend, and ItemCount labels respectively.
4
Clear (All) and check the public folder name that you want to trend.

About query performance

If you query for a large amount of data from the tables, the query can take a significant amount of time to complete. It is recommended that, when you edit queries, you only select the fields that you need.

30,000

3

4.5

13

30,000

23

18

47

About columns with multiple values

By default, in OData each row contains a single entity such as one message, one conference, and so on. So for columns that can contain multiple values (such as participant), if you select Count for the Count of Key, you will see duplicate values.

For example, if you selected participants and a message has several participants, the same message appears in multiple rows, one entry for each participant. In this case, change the Count of Key from Count to Count (Distinct) to get a count of distinct keys.

相关文档

The document was helpful.

选择评级

I easily found the information I needed.

选择评级