Hi there Nick,
I am not familiar with the Solver add-in, can you direct me where to get it and I will look at the VBA to see if I can replicate it in Tableau for you
I am not familiar with the Solver add-in, can you direct me where to get it
Paul, Solver is an Excel plug in for 'what if' and other mathematical analysis such as shortest path analysis..
I would suggest, its not really the domain of Tableau, Solver is more likely to be used in Tableau as source only.
Best of luck though, if you can do it, patent it!
1 of 1 people found this helpful
This is the kind of thing I have used Solver for >>
It was actually one about tomatoes in varying grades but cant find it now, hopefully you get the idea
Okay, now I understand more of what you are after I can see exactly what you mean!
Whilst it might be possible to create a solution to one problem via calculated fields, I see what you are asking is for something a lot more powerful than that
Hope someone else can help you out!
I have a need for Tableau to do some optimizations like the one mentioned in this Excel Article. "An introduction to optimization with the Excel Solver tool" I know if Excel can do it, Tableau can do it better. It sounds like having a dynamic field that will trigger recalculations.
Anyone have a solution for something like this?
Hi. A possible solution might be to pass data to R https://cran.r-project.org/doc/manuals/R-intro.html#Top (install Rserver locally on your desktop) and load and use the "lpsolve" library. see https://cran.r-project.org/web/packages/lpSolve/index.html
You can pass values from Tableau to R (using "script" calculations)see http://public.tableau.com/views/Irisdata/PetalDimensions?:embed=y&:showVizHome=no&:display_count=y&:display_static_image=y&:bootstrapWhenNotified=true ) and run various stats packages in R, so there may be a similar way of passing the value to lpsolve . I have a similar requirement to yourself to run a solver package so I am currently exploring this as an option, but I am still learning baby steps with R.
Starting in Tableau 10.5, you'll be able to use Analytic Solver to export your model from Excel to Tableau, This will require you to have a license to Analytic Solver in order to build the custom extension with your model in it. See www.solver.com/export-tableau for more information.