-
1. Re: one mark per pane in text table?
Deepak RaiFeb 1, 2019 1:47 PM (in response to rachel.kell.1)
any workbook?
-
2. Re: one mark per pane in text table?
Prasanna R Feb 1, 2019 1:48 PM (in response to rachel.kell.1)Hi Rachel,
Since you have 'Course' in your view, it will split the row into number of courses a student has. You would have to remove that from the view. What is your goal after clicking the mail shape. Would be better if you could attach a workbook with dummy names to help you better.
Best Regards
RP
*If this helps, then please mark it Helpful and Correct to close this thread
-
3. Re: one mark per pane in text table?
Deepak RaiFeb 1, 2019 1:51 PM (in response to rachel.kell.1)
Either Take Out Course From View or Use This
{FIXED Full Name:MAX(Course)} to have only One Mark
-
4. Re: one mark per pane in text table?
rachel.kell.1 Feb 5, 2019 8:57 AM (in response to Prasanna R)hi, thanks. yeah i know that having 'course' in the view is the issue. :-)
my goal is to have ONE envelope per student not one per course. the client needs names, courses and emails all in the view.
i was just hoping there might be a way to get rid of the "extra" marks since each mark is a mail to with the student's email address so i only need one per student.
-
5. Re: one mark per pane in text table?
rachel.kell.1 Feb 2, 2019 8:40 AM (in response to Deepak Rai)thanks- but i tried several LOD expressions.... both fixed on 'full name' and exclude on 'course'. they still result in one mark per line.
i'd even tried the below combo and no-go. :-(
{exclude [Course Abandoned]: max({FIXED [Full Name]:MAX([Course Abandoned])})}
i was hoping there was something simple i was missing but i guess not.
-
6. Re: one mark per pane in text table?
rachel.kell.1 Feb 2, 2019 8:42 AM (in response to Deepak Rai)i'll try to post a workbook shortly. i have to de-identify the data.
thanks!
-
7. Re: one mark per pane in text table?
rachel.kell.1 Feb 4, 2019 10:54 AM (in response to Deepak Rai)here's an anonymized workbook with just that one sheet included.
my sense is that tableau will simply not let you have a text table listing multiple items yet display fewer marks. hopefully i'm wrong.
-
Test WKBK rkell 2.4.19.twbx 41.9 KB
-
-
8. Re: one mark per pane in text table?
Prasanna R Feb 4, 2019 7:00 PM (in response to rachel.kell.1)1 of 1 people found this helpfulHi Rachel,
Guess this is what you wanted.
So the calculation would be as shown below and place that on the Shape Mark.
You can duplicate these and rename then each one for Size and Color to make it perfect. So all the ones with NULL can be smallest size with white color.
Best Regards
RP
*If this helps, then please mark it Helpful and Correct to close this thread
-
9. Re: one mark per pane in text table?
rachel.kell.1 Feb 5, 2019 8:12 AM (in response to Prasanna R)yes- exactly! thanks so much, it was driving me nuts. :-)