Converting multiple true/false fields into one dimension while keeping linkages

[#1]

Example data:

ID	State	Deleted	Updated	Saved	Reverted
101	AL	TRUE	FALSE	FALSE	FALSE
102	CA	FALSE	TRUE	TRUE	FALSE
103	CO	TRUE	FALSE	FALSE	TRUE
104	TX	TRUE	TRUE	FALSE	FALSE
105	MI	TRUE	FALSE	FALSE	FALSE
106	FL	FALSE	FALSE	FALSE	TRUE

The real data I'm working with is confidential, but the table above is an example of the same situation I'm facing. The raw data is set up like above, where there is an ID, state, and other identifiers, as well as multiple "Status" columns that have TRUE or FALSE.

What I need is a pie chart that would read this raw data and display four slices for Deleted, Updated, Saved, and Reverted, counting when a record has TRUE for each field. I initially just manually created a new table that has two fields, "Status" and "Status Count", with a row for each status and the corresponding count. However, I still need the data linkage between the other fields. For example, if I select "Deleted" from the pie chart, I need the filter to also filter my other visualizations to only display records that have Deleted = TRUE.

Any insight on how to accomplish this? Thank you in advance.

[sunny_talwar · Accepted solution]

I think you need to transform your data in the script using The Crosstable Load

[#3]

I just figured this out from researching and finding another similar discussion post. CrossTable worked exactly as I needed. Thank you!

[sunny_talwar]

See if the attached is what you would want to see

[#5]

Thank you. That is helpful and what I'm going for, but there's still one issue. I added another pie chart for States in the attached file. What I want it to do, is when I select a Flag, for example Deleted, in the Flag pie chart, I want the State pie chart to filter on records where "Deleted=True". Is there a way I can make a crosstable, but only include records where the Value is TRUE? Does that make sense?

Thanks again.