-
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…