For context the data set image linked is a representation of the data I am working with to protect our real customer data. I do not have the ability to reformat the data coming in, only use magic ETL and SQL transformations to convert this data into the format it needs to be in.
I can not find a way to make the funnels categories be column headers and the counts to be a sum of the column by UUID. The UUID will act as a filter that our customer applies at the dashboard level, I know how to do that. I mainly need help with either how do I reformat this data to work with the funnel or how do I get the funnel to work with this format.
Thank you in advance.