Need help structuring the data

tableaucommunity@tableau.com — Fri, 02 Aug 2013 20:33:46 GMT

I am trying to generate a resource (head count) allocation model. The available information is:

1. Resource Name (usually a person's name)

2. Group this resource belongs to

3. Function within group

4. Other information, like location (site), resource type (full time, contractor, intern etc)

5. Which projects they work on for each fiscal quarter.

So, a typical Excel data page looks like:

Name Location Group Function Type FY13Q1 FY13Q2 FY13Q3 FY13Q4 FY14Q1 FT14Q2

Name1 US Eng HW FT Proj1 Proj1 Proj2 Proj2 Proj2 Proj3

Name2 India Eng SW Contr Proj2 Proj2 Proj5 Proj5 Proj5 Proj5

etc. What I want to do is plot a stacked bar chart that shows how many people are working on a given project per quarter. In other words, the one axis will be the FYnnQm and the other axis is stacked bar chart of count of resources on each project. See attached Excel pivot table example.

I couldn't get it to work starting with the data format above. All I am able to do is a stacked bar chart for ONE of the quarters and then a dashboard that has all the quarters. I am willing to re-structure my data to accomplish this in a single plot.

Any ideas?

Convert binary data to float

tableaucommunity@tableau.com — Thu, 22 Mar 2012 21:12:07 GMT

I have a data source in which one of the database columns is a binary string (in hex form) of an 2D array of float numbers. I'd like to convert it back to float. Does anyone know how to do this in Tableau? Currently we do this by using a C# program and use a built-in C# function BitConverter.ToSingle(rawData, i * sizeof(float)). I'd like to do this inside Tableau if possible.

Any help is appreciated.

Here is an example of an array to be converted:

BFB6D8C05C94D8C0E197D8C0B182D8C0C466D8C0D84AD8C0A935D8C0E121D8C0190ED8C05806D8C0C303D8C02F01D8C0BDFAD7C0B8ECD7C0B3DED7C0AFD0D7C025B5D7C07599D7C0C57DD7C0AA63D7C0F34CD7C03C36D7C0851FD7C0F00FD7C0A302D7C056F5D6C04EE8D6C006DED6C0BFD3D6C077C9D6C0DAB9D6C0F79DD6C01482D6C03166D6C0EA47D6C03F27D6C09306D6C0E7E5D5C022CAD5C099B0D5C01097D5C0867DD5C09868D5C03E55D5C0E441D5C08A2ED5C0F40FD5C006F0D4C018D0D4C08FADD4C08077D4C07241D4C0640BD4C094D3D3C0E597D3C0355CD3C08620D3C009DBD2C0DA8AD2C0AA3AD2C07BEAD1C0717FD1C0470DD1C01C9BD0C07B0DD0C01847CFC0B580CEC0A1B6CDC06579CCC02A3CCBC004F6C9C0061DC8C00844C6C01B17C4C03377C1C06CA9BEC0DF0BBBC00126B7C0F359B2C08FECACC070F0A6C04009A0C0984398C0C79D8FC031FD85C0B9CD76C0FCE45FC0A3FE46C05A122CC0181C0FC006B6E0BFCE619EBFD6272DBFD11805BEC9E0E33E1FD0873FC3AFD93F574017400E614340EBB07040

Content in Tableau Community Forums

Need help structuring the data

Convert binary data to float