topic Re: Get item usage with custom range that goes over a year in ArcGIS API for Python Questions

Get item usage with custom range that goes over a year

KerryKang — Mon, 26 Apr 2021 03:05:00 GMT

Hello all,

I used to check our web apps' usage since the app was created in the mid april in 2020 . Last week, I realized that the usage search only offers up to 1 year range, and had to some manual calculation to get the cumulated total and average usage per day. It was quite inconvenient and I hope to get the number using Python API.

I searched some resources but I don't see any example which actually used a custom range. Has anyone done it? What all I need is total cumulated number and daily average.

Even if I cannot do over 1 year, if I can apply custom date range with Python API, I can probably skip manual calculation work.

Cheers,

Kerry

Re: Get item usage with custom range that goes over a year

AdamR — Tue, 18 May 2021 04:04:29 GMT

I've been doing some hocky stuff off Jason's code. I was kinda hoping I could import pandas and use that as a date, something like:

pd.date_range(start='2020-01-01', end='2020-01-06')

but I can't get it to work 😞

FYI:

from arcgis.gis import GIS from IPython.display import display gis = GIS("home") items = gis.content.search(query="type:Web Apps") for item in items: try: itemHistory = item.usage(date_range='1Y', as_df=True) # <--- Looking in the past 12 months total = itemHistory['Usage'].sum() if total <20: # <--- Less than 20 total views display(item) except: pass

Re: Get item usage with custom range that goes over a year

sblack_USGS — Thu, 01 Dec 2022 21:02:28 GMT

Bumping this thread - Has anyone come up with a way to do this yet? I can't seem to find anything that works.

Re: Get item usage with custom range that goes over a year

JoshuaFlickinger — Fri, 21 Jul 2023 17:44:30 GMT

Bumping this thread again. I've gotten custom date ranges to work with this method:

from arcgis.gis import GIS gis = GIS('home') item = arcgis.gis.Item(gis, itemid="########################") date_1 = datetime.datetime(2023,7,2) date_2 = datetime.datetime(2023,7,20) usage_stats = item.usage(date_range=(date_1, date_2),as_df=True) usage_stats

BUT, any custom dates over a year old fail. Well, technically I don't get an error. I just get an empty dataframe. Or an empty dictionary if I use "as_df = False".

Is this the expected behavior, or a bug?