Hi,
I am trying to create a waterfall chart but have been getting stumped unfortunately.
According to this page, one should be able to build a waterfall chart using only measure (Option 2): https://docs.looker.com/exploring-data/visualizing-query-results/waterfall-options
I have in an Explore one row only comprised of measures, and I get an error of ’ Incompatible Data - Waterfall chart requires one dimension and one measure’ in the Visualization tab when I try to select the Waterfall option.
Is there a workaround or a correction on my end that needs to be done?
Thanks!
EDIT: I may be on version 6.1, so I’m wondering if it’s possible to actually hack this together without the built-in functionality