4 Replies Latest reply on Aug 20, 2018 2:12 PM by Adam Payne

# Bar graph question

Hi Everyone,

I know I must be missing something simple, but need your help to figure out what it is

I am trying to do a simple bar graph showing how many donations we received to a certain campaign vs a donor RFM score. The RFM score is a number 1-15. The RFM score field has 3 nested calculations:

[Recency Score]+[Frequency Score]+[Monetary Score]

The count of donors who have given to the campaign is pretty simple:

countd(IF [Campaign ID]='7011J0000004FKmQAM' OR

[Campaign ID]='7011J0000004FKrQAM' OR

[Campaign ID]='7011J0000004FKwQAM' OR

[Campaign ID]='7011J0000004FL1QAM' OR

[Campaign ID]='7011J0000004FL6QAM' OR

[Campaign ID]='7011J0000004FLBQA2' OR

[Campaign ID]='7011J0000004FLGQA2'

Then [Donation ID]

Else NULL

End)

The total number of campaign donors is correct but it's being plotted as a single bar as shown in the screenshot. What I want is for Tableau to plot the number of donations per possible RFM score. So, I know it must be simple, I just don't know what to do

• ###### 1. Re: Bar graph question

Would it be possible to attach a Sample Dashboard - this will help in creating a solution to your question. You can create a dummy data set or take a sample of 100 rows and delete any sensitive information before uploading packaged workbook here.

• ###### 2. Re: Bar graph question

Is there a way to save a packaged workbook with just a sample set? I have it connected to our SF database so a packaged workbook is like 450mb :/

• ###### 3. Re: Bar graph question

Hi everyone, I know that this is a really big workbook, but if anyone is willing to help me with this I'd HUGELY appreciate it!

• ###### 4. Re: Bar graph question

Could it have something to do with the fact that my RFM score is a table calculation on sheet 1 and the graph is on sheet 2? So when I pull the RFM into the graph on sheet 2, there isn't actually a calculated value for Tableau to use?