Best Of
Re: Converting a duration time text field into a number
Try an Add Formula tile and the TIME_TO_SEC function:
name: duration_sec
expression:
TIME_TO_SEC(`duration`)
This should work as long as all your string values are in that hours:minutes format.
rco
Re: Issue in total/subtotal of the pivot
This is because how your Beast Mode is written, it aggregates everything first and then just subtracts an hour.
What you'll want is (assuming you're filtering for records where the duration is already > 1 hour:
SEC_TO_TIME(SUM(`End Time` - `Start Time` - 3600))
Boxplot & Histogram Charts
The boxplot and histogram chart types are the ones that I'd use most often but I almost always get a "Warning: Not all the data is shown" error, which leads me to believe that Domo is unable to handle the volume of records I'm trying to plot.
srosen
Re: Apply color rules based on one column's values to other columns
Thank you for the additional information.
We need the ability to apply color rules to specific columns based on the values in a different column.
- Column-Specific Conditional Formatting Based on Another Column:
- Allow numeric or text columns to be color-coded based on the values of another column. For example:
- In a mega table, color-code a numeric column (e.g., "Dollars") based on the value of a text column (e.g., "Item Type") without applying the rule to the entire row.
- Allow numeric or text columns to be color-coded based on the values of another column. For example:
- Overlapping Color Rules with Adjustable Priorities:
- Enable multiple color rules to overlap without fully overriding each other and allow users to reorder the priority of these rules via a drag-and-drop interface.
- Numeric-Based Color Rules for Formatted Text Columns:
- Extend the ability to apply numeric-based color rules to formatted text values. For example:
- A calculated field that converts seconds into a "minutes" format should still support color rules based on numeric thresholds from the underlying data.
- Extend the ability to apply numeric-based color rules to formatted text values. For example:
Re: What does the publish App do in the App studio?
Publish app allows you to create a public-facing version of your dashboard that can be accessed by users outside your Domo environment. It is used for creating dashboards intended for an external audiences.
When you add a domain as a subscriber, the published app is only accessible to users from that domain. This is a form of restricted sharing, meaning it won't expose the dashboard to "everyone" on the internet, but only to those with emails belonging to that specified domain.
If your dashboard contains sensitive information, you need to be cautious. Publishing an app creates a copy of the dashboard that is detached from Domo’s user-based permission system. This means that row-level security and dataset permissions configured in Domo do not apply to the published version.
Extend x axis past the end of the data
Is there a way to extend the x-axis past the end of the data? I'm building a burnup chart to show progress on a release. The x axis is datetime values. The y axis is points completed. I'd like the x-axis to extend to the end of the release, even though there are only data values for dates up to today.
BruceP
Re: 11/18 PRODUCT RELEASE SNEAK: Domo Mobile App Customization
This is GREAT! How can I get in on this??
Re: Group By and Drill down
Gothca! Here are the steps:
1. Create a table card and add the fields Name, Age, and Birthday
2. Save and exit the card
3. Click the wrench on the card:
4. Click "Edit Drill Path"
5. Click "Add a view"
6. Repeat step 1 but with the fields you want displayed in the drill down view.
Re: Ratio Formula
You would create a beast mode with the following code:
(SUM(`Paid Amount`) + SUM(`Savings Amount`)) / SUM(`Bill Amount`)
Then you'd create a table card with the first column being the Name and the second column being the beast mode you create.
Here is a video on how to create a beast mode:
Re: Ratio Formula
Use add beast mode to create a new calculation using a formula like
( `Paid Amount` + `Savings Amount` ) / `Bill Amount`
Domo uses back ticks to enclose field names. Name it something like "Ratio". Save it and make sure it validates properly.
Also make sure you have no null or zero values in Bill Amount. Otherwise you will get division errors.
CASE
WHEN `Bill Amount` = 0 THEN NULL
ELSE ( `Paid Amount` + `Savings Amount` ) / `Bill Amount`
END