2 Replies Latest reply on Jan 24, 2018 9:30 AM by Evan Reid

    Medical Society, New to Tableau, Netforum Enterprise Database

    Ashley Morris

      I just found this group and am wondering if some of you may be able to offer some suggestions based on your experience. We are a medical society who are just starting with Tableau and use Netforum Enterpise 2015. Displaying current data is very simple for us, but comparing to previous points in time is much more challenging. How do you handle this? Ideally we'd want to look at both data sets from our live connection with Netforum, but alternatively I could connect an excel spreadsheet. The problem with that is that the filter I have on our Netforum connection automatically applies to the excel spreadsheet and thus only shows data for people who are still members. Any suggestions would be much appreciated!

        • 1. Re: Medical Society, New to Tableau, Netforum Enterprise Database
          Stephan Hampton-Valle

          Hi Ashley,

           

          I work for a membership association and we've run into the same issue when wanting to track membership as it stood each month. We're still currently working on it, but so far after meeting with our IT team we've considered one work-around. Rather than having the database on a live connection, we would pull monthly data extracts instead (Based on paid through dates, activity records, etc). Then all we would have to do is union each month and use the date dimension to show counts for each monthly extract. We should be testing this within quarter 3 of this year so I'll come back to this one and let you know. I figured I'd share in the meantime so you also a a chance to try it out. If you do- let me know if it worked for you!

           

          Best,

           

           

          -Steph

          • 2. Re: Medical Society, New to Tableau, Netforum Enterprise Database
            Evan Reid

            Ashley,

             

            I am very late to the party here, but just stumbled across your post.  One work around here is ro review the merge used to join the historical excel datasets to the current Netforum dataset.  This will alow you to control what fields are linked in the two datasets.  These linking fields are what allows the filter to be applied over the two datasets.

             

            If you are still experiencing this issue, I would be happy to discuss further.

             

            All the best,

             

            Evan