-
Syntax error with beast mode
Trying to convert a column to seconds but I am getting a syntax error and cant figure out where the issue is.. TIME_TO_SEC(`AVG Answer`) + ( DATE_FORMAT(`AVG Answer`, '%f')/1000000)
-
Card Drill Down Issues
OnlyI have a card that I am trying to use the drill down on for some reason it will not drill down when I am on the dashboard page. But when I view the card in 'detail' and click on the section on the pie chart, it drills down as expected.. Anyone have any clue why it wont drill down from the dashboard page?
-
Beast Mode Decimal number to Time Format
Is there a way to convert the current decimal number to (HH:MM:SS) format? We are using a beast mode that currently calculates minutes for us.. SUM(Talk time to decimal) / SUM(LIVE CONNECT count) = 1,167.83 / 85 = 13.74 mins.. Can i turn that into 00:13:74?
-
Rounding Data within card
Has anyone ever had the issue where the card data table shows duplicate values, which are being rounded, but these values ARE NOT in the actual dataset. Is there a filter or something I can do in analyzer to prevent this?
-
Time to Number value
I have tried to find a few answers on this but nothing has come up - is there a way to take a time column (00:02:01) and SUM ALL the values for the total Hours? I have tried SUM(HOUR('TALK TIME')) but that is not giving me the correct summarized number of hours. I also tried to do in the ETL but the column keeps coming up…
-
Creating a separate column using magic ETL
Hi there - I am trying to part of a value that is in a column and change it to be the full name. I keep getting syntax errors whehn going through ETL formula tiles. My formula is alot larger than this but this is an example - I have tried = instead of Llike, as well as contains, nothing seems to be working (becuase the…
-
Beast Mode Combining Columns
I need help figuring out if I am doing this beast mode correctly… We have an ETL that is not calcualting the sum correctly, so I am trying to use a beast mode instead.. I have 6 Columns I need the sum of divided by 6 more columns to equal the AVG I have tried several differnt ways to complete this - each column has value…
-
Syntax Error
Can someone help me with this formula? I need to show the number of X12_Month_Scheduled_Review__c - IF the Session_Date__c is THIS MONTH. Not all Session Dates will have a Scheduled Review Date. IF(Session_Date__c = 'THIS MONTH', THEN(COUNT(X12_Month_Scheduled_Review__c)))
-
beast mode calculation
I am trying to create a card that shows the percentage of data. I have a field from salesforce that is Target_Count__c and I need to show the how many targets actually have a date in the X12_Month_Review__c section (# of follow up reviews / percentage of target count). I tried to use this formula and filters but nothing is…
-
Beast Mode Syntax Error
I am trying to do a beast mode calculation and I keep getting errors COUNT(`Target_Review_Count__c`) / COUNT(DISTINCT `Session ID`) Calculation Error : Whoops! Something went wrong & it keeps changing to DomoHttpError
