Forum Discussion
Filtering Data for visualization
Hi Folks, needs some advice. I have a table that look something like below
| Customer Name | Label 1 | Label 2 | Label 3 | Label 4 | Label 5 |
| Customer A | Microsoft | "blank" | Customer A | Team A | Cloud |
| Customer B | Team A | Redhat | On Premise | Customer B | "blank" |
| Customer C | Apple | Customer C | Team C | "blank" | On Premise |
| Customer D | On Premise | Team B | "blank" | Customer D | SUSE |
Intention is that I want to be able to use slicer to filter out information and present the corrosponding data. Example
1. Which team has been servicing which customer
2. What customer has been using which product
Can anyone guide me in getting this done?
Have tried looking at https://www.youtube.com/watch?v=UvvS376vYSw but my data are all strewn in 8 different columns (label 1 - label 😎 and hence it doesn't work for me.
4 Replies
Yes I have a list of teams and products. How do I unpivot as the data is in my original CSV file? I was thinking of using extract if "text" but might be too much of a hassle though
Thanks for providing some guidance there. Had to read up exactly how does one unpivot in the first place. So just for reference for others who might encounter similar issue, below are broad steps that I've done.
1. Create an INDEX in my main table (this is to be used for table relationship at the end)
2. Create a new table
3. Duplicate the necessary columns that I need to unpivot (in my case are label, label1, label2, label3, etc), I used REMOVED OTHER COLUMNS
4. Make sure INDEX is also duplicated into this new table
5. Then choose UNPIVOT OTHER COLUMNS based on INDEX
6. Select Many to One relationship with INDEX as the unique value as reference
Tada.
