Best Of

@Parkerains I re-read your original question and if you are trying to apply a filter for a certain input then the "Add Constants" tile approach is definitely the way to go. My method is for identifying which field came from which source, not which rows.

@akshat7j a lot of the visual customisations you mention can be achieved in the new domo app studio

@Lu_zhang - you're looking at period over period cards. You'll want to use the line + stacked bar option, which will have the ability to set the number of series you want on the left scale. You can find this by going to "Vertical Bar" and then looking for Line + Stacked Bar.

Keep in mind that for this to work, you'll need to have all of these in a single series. In other words, the series groups must be defined in a single column.

When you accept an answer, please accept @mcih and not mine. Just wanted to chime in so that you could continue to make progress.

This case my suggestion we can process using SQL in DOMO

@Lu_zhang

There are 2 types of timezone settings in Domo.

Anyone can define their personal time zone in Domo to determine when they receive alerts, notifications, and scheduled reports. Admin-level users can define a company time zone for the entire instance to standardize how visualizations display.

If there is a company defined timezone, Domo assumes that all data loaded in is in UTC.

To set the company time zone, you must be an Admin or have a custom role with the following grant enabled:

(Admin-level) Manage All Company Settings — This grant permits the user to manage company metadata, authentication rules, security, publishing, and more.

Go to Admin>Company Settings>Company Overview>Formatting>Time Zone.

Since Domo expects that all input DATETIME values are in UTC, note the following:

• DATETIME values are not converted to UTC during import from self-managed DataSets (such as Excel, Box, Google Sheets, or file upload). Data in these sources must be stored in UTC before import.