This is another way to adjust how the Date column will be modified:įeel free to experiment with the available options, resetting to the original when done. Reset the Date column back the the default (use "Remove date truncate" or the back icon if you are in edit mode).Ĭlick on the Date columns down arrow and select Format date. If you select the Day option, notice that the column name is changed to Day of Date This is one way to adjust how the Date column will be modified. We are mostly interested in the Date column right now but will use the others as we add logic later.Ĭlick on the Date columns down arrow and select Truncate date. Let's start simply by presenting the standard ways to alter/adjust a date column.Ĭreate a new Workbook and place the PLUGS_ELECTRONICS_HANDS_ON_LAB_DATA table on the page. Date logic can be confusing so we will start with the basics to show how Sigma makes the simple stuff easy and then get more complex to show how Sigma makes the hard stuff possible all through an easy to used interface. We will cover a large number of methods for working with dates in Sigma.
Sigma computing functions how to#
How to apply Sigma functions to date challenges. It does not matter which browser you want to use. Prerequisitesġ: A computer with a current browser. Target AudienceĪnyone who is looking for solutions to date challenges or just want to learn new date methods.
We will use the Sigma provided PLUGS_ELECTRONICS_HANDS_ON_LAB_DATA table so that you can recreate each QuickStart Step in your own Sigma environment. This QuickStart assumes you have a working instance of Sigma and the Sigma Sample Dataset. Suggestions and feedback is always appreciated. Not every solution is covered and you may even found a better method. There are many ways to solution with dates in Sigma. Sigma can be used to manipulate dates to get the desired results, quickly and easily. This QuickStart presents common challenges when working with dates.
0 kommentar(er)
