Skip to main content

Thank you for your time in advance,

 

Actually I have a data source which have columns like below

id type form status

1 t1 f1 s1

1 t2 f1 s2

2 t3 f2 s1

---------

what I am trying to achieve is

Columns are auto sub-categorizing themselveswhere the numbers are the count of id

but when I am pulling two column besides each other the columns are arranged like

image 

but this is not what I want, Can some one help me here??

Thank you :)

9 answers
  1. Oct 6, 2023, 5:08 PM

    I would do this in Tableau Prep to reshape the data per each Category of Type, Form, and Status:

    I would do this in Tableau Prep to reshape the data per each Category of Type, Form, and Status:Each of those treated separately then Union together and then output.Each of those treated separately then Union together and then output. The output in Desktop would look like:

    Screen Shot 2023-10-06 at 10.06.58 AMPackaged Tableau Prep flow is attached as reference. Prep is free with your Desktop license; just download and apply the same license key as Desktop at time of registration of software.

     

    Best, Don

    (Please, don't forget to click Select as Best or Upvote !)

0/9000