3 Replies Latest reply on Oct 30, 2015 1:55 PM by Daniel Vincent

    Extract Data when not an excel source

    Julie Jacobs

      Can I extract data when my source is a SQL server? I am trying to make a Pareto chart and am unable to use distinct count as a calculation definition for my running totals.

       

      Or, is there a way to ensure that my data only goes up to 100%? I have included a screen shot. The totals are SUM instead of DISTINCT COUNT like I need, which isnt an option.

       

      Thanks!