Alteryx MongoDB fields to pull in tableau

[pnaveen]

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 

[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.

[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 · Accepted solution]

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.

[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 · Accepted solution]

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 · Accepted solution]

thanks