Using Beast Mode, how can I use the last value when a value equals zero?
I joined two datasets with MagicETL, one a view of daily website visits, the other a weekly snap shot of subscribers. I would like to create a Single Value gauge card that shows the visits per subscriber (2.15 in my example below) with the latest subscriber numbers in the summary line (3,988 in my example). I would prefer a Beast Mode solution as i will need the gauge card for this month as well as last month.
Any ideas please?