Creating a waterfall chart of only measures?

[nelsonchen]

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