6 Replies Latest reply on Mar 21, 2013 12:49 PM by Ashley Howard

# plotting aggregated data on single bar in chart

I have a bar chart with a few dimensions plotted.  In one case, I have calculations that find new customers and existing customers, i.e. aggregated data.  I need to plot both of these on a single bar in this chart.  I'm sure this is simple but I can't figure it out.  Can anyone help?  Thanks!

• ###### 1. Re: plotting aggregated data on single bar in chart

Elizabeth - Without seeing your data its a little confusing what you are asking.  Are you wanting to combine the two together into one bar?  If so, you could write a new calculation:  [New Customers] + [Existing Customers].

Thanks,
Ashley

• ###### 2. Re: plotting aggregated data on single bar in chart

Thanks, Ashley.  My 'new' and 'existing' customers are each sums over a time period so I'm having trouble aggregating these already aggregated measures.  Is it possible to do the calc you suggest?  Essentially doing a sum of two sums?

• ###### 3. Re: plotting aggregated data on single bar in chart

Oh, and for some reason my question got posted under my other name, Elizabeth Morrison.  We are one in the same.  As I say, I'm new to this so not sure why this is happening.

• ###### 4. Re: plotting aggregated data on single bar in chart

You might need two if then statements in your calculation.  Any chance you can upload an example?

• ###### 5. Re: plotting aggregated data on single bar in chart

Unfortunately, I don't know how without violating confidentiality. Am getting from client better definition of new/existing customers measure calculation to use in an if then statement. May be able to do with true/false filter you showed me in other project. What are the two if then statements you were thinking of?

• ###### 6. Re: plotting aggregated data on single bar in chart

Not being able to see it my best guess would be to use either:

count(If [Customer type]="New" Or [Customer type]="Existing" then [Customer Name] end)

or

count(If [New Customer]=True Or [Existing Customer]=True then [Customer Name] end)

If you have multiple data points per customer you can used countd() which counts distinct records, but your data must be extracted to do this.