Does anyone have any tips on how to clean data to use the Sankey charts, so that they don't trip up on the circular data issue. I'm finding it quite frustrating having to clean the data to avoid circular event pairs. It feels like it would be best if Metabase could filter these out automatically, or figure out a way to display them.
Thanks
How to clean data--can you describe your data pipeline?
As far as cutting out cycles, you'll need to encode some knowledge of your process so you know what transitions you want to get rid of. A cheap way is to enumerate your stages using increasing numbers and remove any transitions where the end index is less than the beginning index.
That, or I see A Competing Product™ supports circular sankey charts.... maybe it can be ported to Metabase?