topic Re: Alteryx MongoDB fields to pull in tableau in Alteryx Server Discussions

Alteryx MongoDB fields to pull in tableau

pnaveen — Tue, 13 May 2025 23:35:40 GMT

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

Re: Alteryx MongoDB fields to pull in tableau

KGT — Wed, 14 May 2025 00:03:20 GMT

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.

Re: Alteryx MongoDB fields to pull in tableau

pnaveen — Wed, 14 May 2025 00:08:19 GMT

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

Re: Alteryx MongoDB fields to pull in tableau

pnaveen — Wed, 14 May 2025 00:05:49 GMT

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

Re: Alteryx MongoDB fields to pull in tableau

pnaveen — Wed, 14 May 2025 00:06:38 GMT

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

Re: Alteryx MongoDB fields to pull in tableau

KGT — Wed, 14 May 2025 00:14:47 GMT

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.

Re: Alteryx MongoDB fields to pull in tableau

pnaveen — Wed, 14 May 2025 00:30:39 GMT

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

Re: Alteryx MongoDB fields to pull in tableau

KGT — Wed, 14 May 2025 03:53:23 GMT

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

Re: Alteryx MongoDB fields to pull in tableau

pnaveen — Wed, 14 May 2025 22:22:03 GMT

thanks