Alteryx Server Usage Report - Setting a date range

Hi,

Is it possible to set a date range on the Server Usage Report, if so how could I do this? The report is about 5GB in size and it is expanding every month. I would like to add a date range to the report so I could run it for the past 30 days or 7 days.

Many thanks

Neil

Macros

Server

Accepted answers

vmartinez

Hi @neil480,

I have adapted the original Server Usage Report.

Note. This is not the most optimal way to filter the data (because I accommodate a filter until the end)

Here the changes I made so that you can adapt yours

All the tools in yellow were added to the Macro: Alteryx_Server_Usage_Report

As you can see is a simple filter after the output #1 of the Tableau Output Container

Filter contains this formula:

DateTimeDiff(DateTimeNow(),[Job_CreationDateTime],"Days") < 30

Also added some interface tools (To replicate what you already have when you select the PDF output)

This is how now the workflow looks like

attached is the .yxzp file so that you can see my changes. I use the version 2020.1.2

Let me know if you have any questions

Best,

Vianney

Alteryx_Server_Usage_Report_VersionFilter.yxzp

All comments

JustinBabbitt

Hello @neil480

It is possible to modify the server usage reports, although it can be tricky. At my previous company, I was able to modify to allow us to select a date range and collection to quantify how our teams were utilizing the Gallery.

This is set up like an APP with the MongoDB connections and Reporting within a macro. You will need to set up the Macro to allow for the filtering of dates, then add the UI tools to both the Macro and App.

If you have any questions or would like help please let me know how I can help.

Thanks,

Justin

vmartinez

Hi @neil480,

I have adapted the original Server Usage Report.

Note. This is not the most optimal way to filter the data (because I accommodate a filter until the end)

Here the changes I made so that you can adapt yours

All the tools in yellow were added to the Macro: Alteryx_Server_Usage_Report

As you can see is a simple filter after the output #1 of the Tableau Output Container

Filter contains this formula:

DateTimeDiff(DateTimeNow(),[Job_CreationDateTime],"Days") < 30

Also added some interface tools (To replicate what you already have when you select the PDF output)

This is how now the workflow looks like

attached is the .yxzp file so that you can see my changes. I use the version 2020.1.2

Let me know if you have any questions

Best,

Vianney

Alteryx_Server_Usage_Report_VersionFilter.yxzp

neil480

Perfect. Thank you both for your replies. I'll run the report today. 🙂

adarsh2707

Hi @vmartinez

This was very informative. Just have a doubt

How to get a text field on selecting Tableau. I am stuck with only this

Can you please help me on this

adarsh2707

Hi @vmartinez

I haver added the text box tool in the macro

But I still dont see it. Do I need to run it updating the macro and only then it appears ?

adarsh2707

@vmartinez

I was able to implement it now and I added 7 days into the text field

but the data still consists of data for more than 7 days
For example, in the scheduled jobs information - I saw the data is coming for even jobs created in 2021 when it should be just for the last week. Am I missing something here

Quick Links

This months top contributors

atcodedog05 19458

Qiu 15866

binu_acs 15708

MarqueeCrew 13708

apathetichell 13703