10 Replies Latest reply on Sep 7, 2012 8:15 AM by michael.poteet

    Side by Side Month over month opened and closed

      I've been using Tableau for a few days now and am putting together the first of what will become many things in it. At the moment, I'm querying and pulling back open and close dates, among many other fields. All items have an open date, and close items have a close date, otherwise it returns null. I'm trying to assemble a side by side chart that compares the total items opened vs closed every month. I can get this done with two separate bar charts, and I just keep confusing myself when trying to add what I want to be the second bar for a single month. I'm assuming that I need to create a new field or parameter to act as the "master" month, and then another calculated field(s) for the number of items opened and closed where the date populated, if it exists, matches the "master". Any ideas?