4 Replies Latest reply on Mar 15, 2018 6:32 AM by Yuriy Fal

    Index vs Running Sum Performance

    Michal Mokwinski

      Hi All,

       

      I'm currently building an org chart in Tableau. I calculate a position of every node as (Index())/(TOTAL(COUNTD([<node_name>]))+1) but it's very slow. I thought about changing it to

      Running_Sum(1/(TOTAL(COUNTD([<node_name>]))+1), which will give me the same result. But will it be faster? I'm also open for other solutions. I am aware, that the performance issue may also be due to the COUNTD run over strings.

       

      The chart will be dynamically generated (there are some filters) so performance is crucial.

       

      Michał