14 Replies Latest reply on Dec 20, 2016 8:21 AM by jose hernandez

# Calculations

Hey tableau community i have a quick question. How can i create a calculation that grabs number of credits taken in the term 16 fall?

For example using excel i see that 16602 credits total were taken for 16 fall. When using tableau it says 824,687 credits where taken? Any ideas ob how i can get an accurate number?

• ###### 1. Re: Calculations

Hi Jose,

Without seeing what you are looking at we can't answer your question. Please provide a Tableau packaged workbook (.twbx) with some sample data and a mockup of your desired goal.

Thanks,

Jonathan

• ###### 2. Re: Calculations

I am using an excel to verify if the credits are correct which they are not.

I would like to be able to get as close as possible to the number of credits.

• ###### 3. Re: Calculations

Jose,

Unfortunately your workbook is connected to SQL server and we cannot see the data.

Could you extract data first then create packaged workbook, please.

And the excel total is 16,609, not 16,602.

Could you also verify 16,609 is correct?

Thanks,

Shin

• ###### 4. Re: Calculations

16609 is correct sorry for the typo

• ###### 5. Re: Calculations

Jose,

I'm totally confused..

Could you illustrate the issue?

where is 824,687 and what is the expectation and what do you want to measure and what is the data excel shows?

It's quite difficult to investigate with poor formation.

Thanks,

Shin

• ###### 6. Re: Calculations

So I'm looking at the data that Tableau is seeing in your workbook.  See attached excel.

I just chopped out the first two colleague_IDs for 16/UFA.  First ID has all zero values.  Second one has a bunch of repeating values.  What should the SUM([CREDITS]) for the second ID actually be?  Excel shows it as 97.  Right now you don't have another dimension to use to determine the average of those repeating values if, in fact, you should not be adding up all those repeating values.  A simple SUM([CREDITS]) right now is adding them all up, and that's why you are seeing such an inflated number in Tableau.

• ###### 7. Re: Calculations

hey shinichiro the 824,687 was a mistake given that I had not added any filters to it.

• ###### 8. Re: Calculations

Yes, what kind of filter do you have and again, what is the expected result?

Thanks,

Shin

• ###### 9. Re: Calculations

Hey Joe here on my end I see I don't have any repeated colleague_id's.

how can I prevent sum [credits] from showing inflated numbers?

• ###### 10. Re: Calculations

The filter that I am using is the term fiter 16/ufa which according to excel it should return a sum of 16609 credits

• ###### 11. Re: Calculations

In the example, that's what you have.  The excel data I attached is a cut-and-paste from "View Data" on your example's data.

Look closely at the example data.

Maybe there is some other field you didn't replicate into the example.  Something that would let you cluster all those repeating values.  Or maybe they aren't repeating values and they actually SHOULD be added up!  My question is just asking for clarification on that.

• ###### 12. Re: Calculations

I see for the colleague id there should not be any repeating values.

• ###### 13. Re: Calculations

I'm not sure what I can do to help you here.  The way you have that data set up, there are duplicates.  If there shouldn't be, then you need to do something different in the way you are generating that data source.

• ###### 14. Re: Calculations

Thank you Joe and shinichiro for trying to help.

On a different Note I would like to get your opinions on What type of desktop would be recommend to run Tableau efficiently. as of now I am running a desktop with an i5 processer and 16 gb of ram yet when using tableau and other programs like excel it just comes to a complete crawl .

thanks guys