-
Grouping dates of service to match a pay period
I have two data sets one with employee pay information that is bi-weekly. And one that has information about the employee's work services they provided The one with employee work data has dates that show when the service was performed (Date of service) and how many hours it took to do the service (Billable hours). What I…
-
Percentage of values in a column
Hello I have a data set with a column name Sale_Type. I want to create a beast mode to use in a table chart that shows the percentage of each sale type in the column. Example of what I am looking for below.
-
Pivoting Help
I am having trouble using the pivot function. Attached is a Screenshot of how I am trying to arrange my data. in the above example I am trying to take the columns AAA, BBB, and CCC and place them under a column named measure. As well as create a Compliance column to hold whether or not the measure was open or closed as…
-
How to count number of Occurrences in a Column
I have a dataset where I am trying to get a count of each occurrence a value in a specific column has: For the example above I would want the result to return that there are Two : "0's", Three: "Nulls", and Three: "1's".
-
Creating a new column using Formula in Magic ETL
Hello, I have a dataframe with a column named 'Screening Date' in that column are dates and null values. I want to create a new column called 'Completed' that looks through 'Screening date' and if there is a date in a particular row I want to Write "Yes" in my new column. If the 'Screening date' column is null I want to…
