Alteryx MongoDB fields to pull in tableau

Hi ,

I am trying to build a dashboard based on Alteryx Workflows runtimes ,

I need the workflow and Runtime ( job started and jod ended time)

I am currently picking the AppName, ExecutionTime(Sec) but in tableau the AppName is summed on ExecutionTime(Sec) and i do not know exactly how much time duration took for each workflow to run. Also a single workflow has multiple schedules in an each day selection.

I am using the AS_Queue and AS_Results tables.

I want to for single data , each workflow how much timeduration took. Also the format of ExecutionTime(Sec)

Workflow1 -----> 2hrs 30min 20 sec

MongoDB

Alteryx Editions

Accepted answers

KGT

You can find API details here, but looks like you've done all the work so far directly on the MongoDB, so you just need the job details.

You can find the MongoDB Schemas here. I believe that the job info is in AS_Queue and so the QueueID will be the JobID. In your dashboard, you need to include WorkflowID, QueueID/JObID/RunID, and execution time.

KGT

I don;t have a mongo to test on right now, but this is how the joins should go. There may be slight nuances, but I think it should be as simple as this. Username will be different for each table, as it will be the owner in some tables and the executor in others. I'm not sure what that field list is in the first screenshot.

AS_Applications.id join to AS_Queue.AS_Application_id and AS_Queue.id join to AS_Results.AS_Queue_ID

AS_Applications will have:
- id: This will join to AS_Application_ID
AS_Queue will have:
- id: this will be Queue_ID in other tables
- AS_Application_ID: this will be thew workflowID
AS_Results will have:
- id: This will be the run ID
- AS_Queue_ID: This will join to AS_Queue

pnaveen

thanks

All comments

KGT

You are looking to separate via JobID. When a workflow runs, it creates a job. That job will designate each run. I think it's called job in the MongoDB, it is on the API at least.

So Each Workflow will have a set of jobs (each run), and each of those will have an execution time.

pnaveen

Please see the attached, the runtime is summarized and the numbers are really inflated.

alteryx.png

pnaveen

How to get the JOB details API in the Alteryx Server/MongoDB?

pnaveen

Where to find the JOB details API in the Alteryx Server/MongoDB?

KGT

You can find API details here, but looks like you've done all the work so far directly on the MongoDB, so you just need the job details.

pnaveen

The AS_Results has these fields, please advice which field are relavent to WorkflowID, QueueID/JObID/RunID, and execution time. Thanks

AS_Queue

Join on Username

KGT

AS_Applications.id join to AS_Queue.AS_Application_id and AS_Queue.id join to AS_Results.AS_Queue_ID

AS_Applications will have:
- id: This will join to AS_Application_ID
AS_Queue will have:
- id: this will be Queue_ID in other tables
- AS_Application_ID: this will be thew workflowID
AS_Results will have:
- id: This will be the run ID
- AS_Queue_ID: This will join to AS_Queue

pnaveen

thanks

Quick Links

This months top contributors

AkimasaKajitani 387

mceleavey 383

mbarone 337

Hollingsworth 335

LanisC 335