Date and Time Functions
Hello, is it possible to add the Add features to sisense cloud-hosted environment Formula Editor? We don't have any of these functions available inside of the Formula Editor. ADDYEARS(datetime, number) ADDQUARTERS(datetime, number) ADDMONTHS(datetime, number) ADDDAYS(datetime, number) ADDHOURS(datetime, number) ADDMINUTES(datetime, number) ADDSECONDS(datetime, number) Sisense Documentation: https://docs.sisense.com/main/SisenseLinux/date-and-time-functions.htmSolved1.6KViews0likes1CommentSwitchable Dimensions with Datetime
Hello Everyone, I am trying to use Switchable Dimensions on a line chart with a datetime table. The objective is to switch from yearly, monthly, and quarterly timeframes using switchable dimensions. In Sisense's documentation, they give an example that I have tried with no luck. Has anyone tried this before and it working? prism.registerSwitchDimension({ widget: widget, dimensions: [ { panel: 'categories', dims: [ { "index":0, "dim":"[dimDate.Date (Calendar)]", "datatype": "datetime", "title":"Weeks", "level": "weeks" }, { "index":0, "dim":"[dimStrategy.strategy]", "datatype": "text", "title":"strategy" } ] } ] });1.1KViews0likes2Comments