-
Take sum of seconds and display as #hrs, #minutes
I have totaled the number of seconds for several cards and need to take the sum and show it as #Hours, #minutes. I'm struggling to find a way to do this in beast mode. This is not converting a time value but altering the sum. For example, if I have a total of 8,274 seconds First, you find the number of whole hours 8,274…
-
Row Limit in Bar Chart
Hi, I have built a bar chart that counts the number of completed cards by Card Title. I limited the bar chart to return 25 rows. However, the results are not correct. Some of the cards have 1 completion are showing in the top 25 when there are 100's of cards that have more than 1 completion. How do i accurately get the 25…
-
Map Only Certain Values from One Column to Another Column
Hi, I have 2 columns. Column A has one set of values - I only want the value of Column B changed if the Column A value = Complete. Example Progress Column A ------Progress Column B ------Result Progress B Completed --------Started ------ Completed Started ------ Completed ----- Completed Started ------ Started ------…
-
Convert String To Date Format
Hello, I'm working in Magic ETL. I have two problems 1 I have a Hire Date field with a string data type that has the string in 2 different formats 01/01/19 or 01/01/2019 How can I convert the values to one format? 2 How can I convert the standardized string to a date. I tried to use str to date but it failed each time.
