After looking into this and getting several different responses it sounds like the best way to do this is through the parameters function. https://docs.oracle.com/en/cloud/paas/analytics-cloud/acubi/create-parameter.html With Parameters then i would have to select the SQL function and build out the query.

Thanks for the doc @JohnW-Oracle. I didn't see it in there so maybe you can point me in a direction but im trying to do calculations based off two columns within a table. I am trying to do a Month over Month Growth between these two numbers. So the growth between 20,686 to 46,612 +124%. Then have the 124% in its own column.

Hello @JohnW-Oracle This was the answer! Enable Personalization in Workbooks. Once i turned this off it removed the "sates" as well as resets the dashboards every time you enter/exit. Only thing it removes is the "states". Also there is no longer a set back to original state. So users will have to click the undo icon a…

Hello again. It doesn't really resolve the issue. It is a work around kind of. However even if you save and configure the navigation menu…. if a user filters in the dashboard then leaves the dashboard then returns to the dashboard the filters in their previous session are saved. I want it to always be in the original state…

Hey @JohnW-Oracle , I read through the documentation and there is nothing regarding states or history or caches. Within NSAW if you filter within something, then exit and come back, the filter will still be on the page. Often users don’t see this message (screen shot below) and then end up doing more filtering and then the…

Hey @JohnW-Oracle , That doesn't really address my issue. My issue is you filter to something within NSAW, exit the dashboard, re-enter that same dashboard, your selected filters are still selected upon entry. I would like it to "reset" every time you come into the dashboard regardless of selections made previously.