-
1. Re: Case Statement
Zach Leber Feb 16, 2012 4:38 PM (in response to allysonwinters2)I think those ATTR functions may not be working for you. I'm not used to seeing those around measures, and if there is more than one value in the data set within the dimension you're in, ATTR returns an asterisk.
If you could add a few more columns to that spreadsheet you could use it as a Tableau data source. Then you'd be able to post an almost-working packaged workbook to this thread and you'd gets lots of help.
-
2. Re: Case Statement
Shawn Wallwork Feb 16, 2012 4:55 PM (in response to Zach Leber)I worked on this a bit, and here's the excel file I was using (with the extra columns).
--Shawn
-
GM test data-SW.xls 37.0 KB
-
-
3. Re: Case Statement
allysonwinters2 Feb 17, 2012 6:57 AM (in response to Zach Leber)Hi Zach
I had put the attr function to rid myself of the aggregate non-aggregate error.
-
4. Re: Case Statement
allysonwinters2 Feb 17, 2012 7:05 AM (in response to Shawn Wallwork)Hi Shawn
I created a packaged workbook with the revised file you posted. I'm not sure how the extra columns will help.
Allyson
-
GM test SW.twbx.zip 28.1 KB
-
-
5. Re: Case Statement
Zach Leber Feb 17, 2012 9:07 AM (in response to allysonwinters2)See what you think of this, no ATTR required! A few more tweaks to the table format will get it to appear as one.
-
GM test SW+ZL.twbx.zip 22.3 KB
-
-
6. Re: Case Statement
Zach Leber Feb 17, 2012 10:12 AM (in response to allysonwinters2)Allyson, it looks like the TWBX you posted was created in Tableau 6.0 or earlier. My revision uses 7.0 but doesn't use any 7.0 features. I could redo it in 6.1 if that helps but I don't have 6.0 or earlier any more.
-
7. Re: Case Statement
allysonwinters2 Feb 17, 2012 10:50 AM (in response to Zach Leber)Hi Zach,
Yes please. Hopefully 6.1 will work.
-
8. Re: Case Statement
Zach Leber Feb 17, 2012 11:37 AM (in response to allysonwinters2)6.1 WON'T work if all you have is 6.0. Please let me know before I redo it. This is a constant problem because forum responders are typically using the latest version while forum questioners are often stuck with an earlier version because they haven't upgraded their production environment. We're still using 6.1 in production but I'm practicing with 7.0 whenever possible.
UPDATE: I found a copy of 6.0 and am redoing the changes in that version for maximal compatibility.
Workbook attached.
Message was edited by: Zach Leber
-
GM test SW+ZL TD6.0.twbx.zip 23.4 KB
-
-
9. Re: Case Statement
allysonwinters2 Feb 22, 2012 9:19 AM (in response to Zach Leber)Thanks Zach. Sorry for the delay. I will take a look and let you know.
Allyson
-
10. Re: Case Statement
allysonwinters2 Feb 24, 2012 1:27 PM (in response to Zach Leber)Thanks for your help Zach. It worked.
Allyson