-
1. Re: Count people across columns
Deepak RaiAug 14, 2018 2:21 PM (in response to veer.vithalani)
Just Pivot your data to get This. Pl see attached.
Thanks
Deepak
If It Helps, Pl Mark it Helpful and CORRECT to Close Thread
-
pivot.twbx 18.2 KB
-
-
2. Re: Count people across columns
veer.vithalani Aug 14, 2018 2:27 PM (in response to Deepak Rai)unfortunately, I can't pivot since I'm using SharePoint as the data source
-
3. Re: Count people across columns
Deepak RaiAug 14, 2018 2:36 PM (in response to veer.vithalani)
Well, If The Data is not Too much , You can Extract and Pivot or Use Tableau Prep.
Thanks
Deepak
-
4. Re: Count people across columns
Hari Ankem Aug 14, 2018 3:10 PM (in response to veer.vithalani)-
Sharepoint Cases.twbx 43.4 KB
-
-
5. Re: Count people across columns
veer.vithalani Aug 15, 2018 7:37 AM (in response to Hari Ankem)Thanks - Unfortunately, the number of people is very large (300+ and growing every day), so doing a calculated field for each of them would not be feasible. I don't have access to Tableau Prep either, unfortunately.
-
6. Re: Count people across columns
Deepak RaiAug 15, 2018 9:04 AM (in response to veer.vithalani)
1 of 1 people found this helpfulHello Veer,
If you are using Tableau Desktop, Then Tableau Prep is available to you Free to use.
Thanks
Deepak
-
7. Re: Count people across columns
Hari Ankem Aug 15, 2018 9:52 AM (in response to veer.vithalani)Well, all you need to do now is have a separate single list of persons, and join it with your Sharepoint case data with a calculated join and get your output with a single calculated field as shown below.
Will this solution work now?
-
Sharepoint Cases.twbx 65.1 KB
-
-
8. Re: Count people across columns
veer.vithalani Aug 15, 2018 11:55 AM (in response to Hari Ankem)Interesting - this looks like it would work, but the only list of the people I have are accessed through Mirosoft SQL server, and it's not letting me join SharePoint Lists with Microsoft SQL
-
9. Re: Count people across columns
veer.vithalani Aug 15, 2018 12:11 PM (in response to Deepak Rai)I think we have the older Dekstop-only license. I'll look into getting Prep too
-
10. Re: Count people across columns
Hari Ankem Aug 15, 2018 12:17 PM (in response to veer.vithalani)Well, now I may not be able to assist you with that except to suggest checking with the most recent version of Tableau to see if the join may be allowed.
-
11. Re: Count people across columns
veer.vithalani Aug 15, 2018 12:19 PM (in response to Hari Ankem)I think I found a user list within the same SharePoint list on a different table. I'm trying the join you suggested (1=1) but it's failing the create an extract. Thanks for your help so far.