I am looking for a way to do an iterative calculation based on a Tableau table.
The table is roughly a time serie and made of 2 columns:
And to illustrate a little bit more what I am trying to do, we could used as an example of what I want to do take the classical exercice of the bathtub drain.
Beside this table, I have a parameter that give me a fixed volume, the volume of the bathtub.
Knowing the coming timestamps and associated flows, I would like for any row (as if the bathtub was empty) to calculate the time at which the volume of the bathtub will be filled in (flow integration along time).
I have tried different things in Tableau, using a Python script but nothing work.
I probably miss something about how Python integration with Tableau is working
If you need I can provide a table with data and attended results
It would be great to see an example packaged (.twbx) workbook of the data you are working with to try and explore this a little bit further.
Is it also possible that you might be able to use the Running Total table calculation in Tableau to calculate when the values will reach a certain threshold?