8 Replies Latest reply on Apr 26, 2016 8:46 AM by Manideep Bhattacharyya

Populating Enumerations of Graphs

Hi,

I'm new to Tableau, trying to see if this is possible.  I'm building out a bar graph and the underlying data has a couple different possible enumerations for the field I'm looking at.  My team will run a process, and eventually all enumerations will be the same (complete).  However I wanted to know if it was possible to show the other enumerations (in flight values such as pending, exception, etc.), but with a value of 0 so the graph doesn't change size/shape?? Any help would be appreciated.

Thanks!

• 1. Re: Populating Enumerations of Graphs

Hello Morgan - Could you please share the excel workbook you are working with or the screen shot of the data what you want to achieve. Then this would be easy to solve. Reading your problems, it looks like this can be solved through Tableau.

Thanks,

Manideep

• 2. Re: Populating Enumerations of Graphs

Hi Manideep,

Here is a screenshot of the worksheet I'm working on now.  The below graph represents when a process is still in-flight.  The top graph shows when the process is complete. However, I want to top graph to show the EXCEPTION and PENDING columns, just with values of 0.

Thanks!

• 3. Re: Populating Enumerations of Graphs

Hello Morgan - I have created a sample data set for you.

The visualization is the following:

Now I have changed the dataset to the following:

And my Visualization would look like the following:

If that what you were trying to achieve ?

Thanks,

Manideep

• 4. Re: Populating Enumerations of Graphs

Hi Manideep,

This is close to what I was trying to put together.  How do you calculate a distinct count for just records that equal "Complete", "Pending", etc.? My calculated fields are defaulting to an aggregate count of all records?

Thanks!

• 5. Re: Populating Enumerations of Graphs

Hello Morgan - If you have observed my workbook, I have created calculated fields for each individual columns.

Example:  For Completed Status.

Like that I have created for all the statuses (Pending, Exception) and then drag that to measure to make Count([Completed]). Please let me know, if any other information is required.

Thanks,

Manideep

• 6. Re: Populating Enumerations of Graphs

Hi Manideep,

This is great, thanks for the help! Last question - Is there anyway to combine the graphs on a single axis?? I tried selecting the dual axis feature, but it changes the visual.

Thanks,

Morgan

• 7. Re: Populating Enumerations of Graphs

Hello Morgan - Please find the data arranged Horizontally.

Thanks,

Manideep