Not able to fetch past week or past month data in ArcGIS Monitor 2023.3.1

[VarunKakkar]

Hi,

We have installed and configure all the components in ArcGIS Monitor 2023.3.1. While preparing a custom ArcGIS Monitor Dashboard we observed that ArcGIS Monitor is not able to fetch the data for the past week and the past month as example we wanted to create graphs or the pie charts for the below scenarios:

1. Total number of contents created last week and last month.

2. Total number of groups created last week and last month.

3. Total number of users (Categorize by user types) onboarded last week and last month.

Below are the screenshots for the queries that we have configured for total number of contents created last week but still we can see in the graph total number of contents created till date.

1: Configured Query

2. Output Pie Chart:

Here we can see the number of layers till date and value of the number layer shows in decimal format.

Is this a defect or enhancement or if I am missing something in the configured query.

Any help would be highly appreciated!

Thanks,
Varun

[DerekLaw]

Hi @VarunKakkar,

In the example configured query in your post, it queries for the total number of portal item types in the last 7 days, which is similar to the query described in this blog ArcGIS Monitor: Analysis Elements for Enterprise portal content. See analysis element 1. 

In the output pie chart example, it looks like the query result is correct - but the pie chart's descriptive text (under the General section) says "Within the last 30 mins”, this should be changed to say "Within the last 7 days" - this is a string field and is not populated by the query.

Is this what you mean when you say: "... but still we can see in the graph total number of contents created till date"?

Items 2 and 3 in your post are covered in the blog I referenced.

Hope this helps,

[VarunKakkar]

Hello @DerekLaw ,

Thanks for the reply. 

Yes, We will update the string field to "Within the last seven days".

We wanted to say that still, the pie chart is not giving us the data for the last seven days. It is still showing us the data for the total no. of items created till date.

Thanks,
Varun

[DerekLaw]

Hi @VarunKakkar,

> ... the pie chart is not giving us the data for the last seven days.

Thanks for the additional clarification. So you'd like to create a pie chart that only shows content created in the enterprise portal within the last week or month.

You'll need to modify the data expression in your first screenshot, specifically the "Observed At" parameter,

Query: "Observed At" "is on or after" "select the date"

For example, if you want to show the items in the last week (from today 5/29/2024):



Next, when configuring the pie chart element, under Data > Statistic Type - select Count.

Hope this helps,