-
Pagination Configuration Question using JSON No Code Connector
I have configured the JSON connector and have the first 100 rows in my preview however, I am having difficulty in configuring the Pagination settings. This is the instructions for how to address from the provider of my source data. Would anyone have thoughts on the Domo configuration I need to pull the additional pages?…
-
Period over Period Comparison of Two Date Columns
I am using a Period over Period card that's fairly simple. Gauge Value - Count of Windows OS machines from the asset software (KACE specifically) Time Period - MAX LastSyncDatePatch (most recent sync date in that column) My card date Date Range is Month to Date and what I need to compare to is a column called…
-
Beast Mode to Add "Warning" for Data Point
I have the Beast Mode below for a card that reflects IsShortAbandon "Good" when <=.07, else "Bad". I want to add "if .06 - .069 then "Warning". I am struggling a bit with the logic and appreciate in advance any assistance. Thanks Michael
-
How would I filter date field for only the most recent date?
How would I configure a BeastMode to filter only the most recent date? My data is machine name / last_sync, which is creating duplicates for the machine name and each reported last_sync date. I only want to capture the most recent date, which should also display one machine name per date. Thanks, Michael
-
Is there a Beastmode I can configure for Rolling 30 period?
The caveat is the 30 day period I want to configure is Previous Month Second Tuesday to Current Month Second Tuesday. Any assistance is appreciated in advance. Thanks Michael
-
Average of tickets by hour question
I have a card Daily Ticket Flow that has Count of tickets by hour for the previous week. My users want to see an Average of tickets received for that hour instead of actuals. I saw something in the old Community platform about Beast Mode using buckets and then averaging the bucket. Any thoughts? Thanks in advance! Michael
-
How to display the weekly average of all timestamps in date/time field?
I have a card that I need to display the previous week's average of tickets created in each hour. The example of the data is attached however, the short story is 24 hours display and the average total tickets created over the previous week by hour. Also attached an example of my attempt of the card filtering Previous Week,…
-
How to display the mean value of a total instead of average?
I have a dataset where I am counting Completed Surveys, Total Survey Score, and 5 Scale Conversion. I am trying to display the mean value of the 5 Scale Conversion, for example - Completed Surveys = 114 Survey Score = 427.30 5 Scale Conversion = 534.13 Result when I enter into a calculator 534.13 / 114 = 4.68535 or 4.7.…
-
Beast Mode Calculation for Specific Email Domain
I have a column called Owned by Email and I want to create a calculated field that displays "Yes" if the email address is @mydomain. Two part question, would that be accomplished better with a dataflow or would a Beast Mode shared on the dataset work as well? To clarify, there are half a million rows of data in the…
-
Question on Alert Creation and Task
I have a card that has a machine name column and a Beast Mode that basically states In One, In Two, In All. I want to create an Alert based on "In Two" as well as a Task to review the machine name. I understand I need a summary number based on the "In Two" Beast Mode to create the Alert however, I wanted to know if there…
-
Beast Mode not selectable in Summary Number
I have the Beast Mode code below using a CASE statement and it is populating the column Review CI. I want to count the number of "Yes" results (or In Two) in the column and display in the Summary number. I am not able to select Review CI when choosing Use all values. Any assistance would be helpful and much appreciated.…
-
I have a card that displays Total Tasks and Performance per Task (Minutes).
When I use Beast Mode to modify the Summary Number, the I receive an error "unable to load at this time". My Performance per Task (Minutes) Beast Mode due to TotalTaskTime is decimal. SUM(`TotalTaskTime`*60) My Minutes per Task Beast Mode which displays valid formula. CONCAT(SUM(SUM(`TotalTaskTime`*60)/`TotalTasks`)) An…