-
1. Re: Why don't my calculated fields match?
Jim DehnerMay 15, 2018 8:57 AM (in response to Jessica Singer)
Good morning
I remember your original question - trying to figure out what you were counting -
The answer to this question lies in the data - see the example below - this totals 2 seasons but one participant -
but it I add address there are 2 separate records - look at the address - they are not the same - probably a data entry error -
there are others also
Jim
If this posts assists in resolving the question, please mark it helpful or as the 'correct answer' if it resolves the question. This will help other users find the same answer/resolution. Thank you.
-
Jessica_v10.2.twbx 2.5 MB
-
-
2. Re: Why don't my calculated fields match?
Jessica Singer May 15, 2018 9:46 AM (in response to Jim Dehner)I had a feeling this might be the answer. My data is awful, and there's only so much cleaning by hand can fix it.
Thank you!
Jessica
-
3. Re: Why don't my calculated fields match?
Jessica Singer May 15, 2018 10:00 AM (in response to Jim Dehner)It seems like I need to pull out duplicate registrations. How do I pull rows where ID, FY, Season, and Site are all the same?
Jessica
-
4. Re: Why don't my calculated fields match?
Jim DehnerMay 15, 2018 10:01 AM (in response to Jessica Singer)
1 of 1 people found this helpfulBefore yo clean it by hand try Tableau Prep (you can access a free trial at Tableau Prep
it is a new Tableau product developed to clean, join and restructure data
see the link below - https://onlinehelp.tableau.com/current/prep/en-us/help.html#prep_clean.html%3FTocPath%3D_____5
I was on the Beta and it does a really nice job for data like yours
Jim
-
5. Re: Why don't my calculated fields match?
Jessica Singer May 15, 2018 10:06 AM (in response to Jim Dehner)I'm sure I would like Tableau Prep, however my management isn't willing to sink any more money into my Tableau foray as of yet, and I have a LOT of data to clean. I'd rather figure out how to do it the slow hard way, so that I can do it after the free trial runs out!
Jessica
-
6. Re: Why don't my calculated fields match?
Jim DehnerMay 15, 2018 10:30 AM (in response to Jessica Singer)
I hear you -
good luck
Glad to help out
Jim
-
7. Re: Why don't my calculated fields match?
Bruno G. F. e Silva Jun 4, 2018 9:31 AM (in response to Jessica Singer)Hi Jessica, If you have Tableau Desktop License you also have the Tableau Prep License. Check the Tableau customer portal in the My Keys area:
https://customer-portal.tableau.com/s/my-keys
-
8. Re: Why don't my calculated fields match?
Jessica Singer Jun 4, 2018 10:08 AM (in response to Bruno G. F. e Silva)1 of 1 people found this helpfulHi Bruno,
Unfortunately, while I do have a Tableau Desktop License, my license is Personal instead of Professional and so does not include Tableau Prep. ☹ My bosses want to make sure this Tableau thing is “worthwhile” before they throw more money at it.
Thanks for the heads up though!
Best,
Jessica
-
9. Re: Why don't my calculated fields match?
Bruno G. F. e Silva Jun 4, 2018 11:25 AM (in response to Jessica Singer)Oh, right... Sorry
Good luck. Hope your company commit to Tableau world.
Best Regards,
Bruno