Dear all,
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
Thanks
Hi Vincent,
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?
Sincerely,
Nathan