What can we help you with?

e.g. Getting Started, Build Dashboards

1 comment

  • Official comment
    Manny Ezeagwula (Edited )

    You can use the `accumulate` C9QL function to do that. 

    For example, if your query returns 3 columns: country, state, city

    you can do the following operation:

    select country, state, city, 1 as sequence_key;

    select accumulate(sequence_key), country, state, city;

    Here's a recording to walk through it:  https://recordit.co/XgdPdnycGj

    Comment actions Permalink

Please sign in to leave a comment.