-
Date Filter Calculated Field
I want to create a filter card to be applied over the Domo Page, where the filter card shows 2 checkboxes/radio-buttons with values: 'Last 7 Days' and Lat 30 Days' On selecting any of those boxes/buttons, the data for the rest of the page should get filtered accordingly. (Selecting 'Last 7 Days' check box should show only…
-
Add date filter 'with presets' to page
I want to add/show the date filter with presets (as is available on card builders) on the page level - on the filter section. I know that custom filters can be added selecting the date field dimension and then filtering out the required dates and other option is to build a date filter card and add it to the page. But what…
-
Date field not recognized while data upload
I have been using Domo for almost 2 years now and all this while, any data which I uploaded had date fields in format either YYYY-MM-DD or YYYY-MM-DD HH:MM:SS which has been the recognized date format so far. Any such data uploaded in data set via file upload or FTP pull or any other method automatically identified the…
-
Beast mode calculation based on Time range
I have a data set which consists of two columns - user_Id and visit_date on the site. the user id remains same for each user i.e if a user login in January for the first time and user_Id 123 is assigned, then for all the subsequent visits on site, the user_id would remain the same irrespective of the visit_Date. My…
-
Beast Mode for Count Distinct with Condition
I want to get count of values in a column based on a condition for another column: Example: Count(Distinct 'visitor_id' ) where visitor_called = 'Y' The above give me a syntax error. Trying with 'Case': (CASE WHEN `visitor_called` = 'Y' then COUNT(DISTINCT `visitor_id`) else '0' END ) This returns me overall counf for…
-
Replace part of string with another value in Domo Cards
I have a data set showing some page names and paths of my website, a part of which has to replace with another in the domo card. Can it be done using beast mode, using any functionality similar to 'Replace' in mysql. Example: Original Value: 'Site1::LandingPage > Site1::My Cart > Site2:Checkout Initiate:Checkout' Required…
-
Create Pie Chart for Two Columns/Measures with same data type
I have 2 columns in my data with same data type. The table looks like: DateWeb RegistrationApp RegistrationsJan-191095Feb-191472Mar-191567Apr-191089May-191595 I want to create a pie chart showing the sum of the Web logins and sum of app logins. How can the two columns/dimensions and related numbers be brought onto the same…
