When Pivot or Table widgets, the options for formatting a datetime column allow showing the date OR the time, with no option to show both together (e.g. if format was "dd/MM/yyyy HH:mm:ss" then we co...
It is really inconvenient to have to split the datetime into date and then time. Also, we work with logs and having the option to display the seconds is a must. Certainly, Sisense could do better in this respect.
Additionally, it is difficult to sort by this datetime field all at once, not having to choose between sorting by date or time but having the option to sort by both at the same time.
Our workaround was to add the datetime as a float, add it to the table, use for sorting and then use Javascript to hide the column. In this regard, it would be great to have an option to hide a column without having to use code. We sometimes need to add a column just for the sake of not having fields in the pivot grouped, as this makes the sorting by other fields a bit problematic.