Best Of

Re: Trying to create visuals like PBI in DOMO

Welcome to Domo! Here are the steps to accomplish what you are hoping to do:
1. Click the + icon in the top right of Domo and select "Dashboard"

2. Over on the right side of the screen you'll see icons representing the various objects you can add to a dashboard, select the one that says "card" and click and drag into the dashboard.
3. Click "add content" and either select an existing card you've already created or create a new one
4. When creating a new card, select "visualization" from the new card options
5. The card type for the single value cards across the top of your screenshot are called "Single Value" and are in the Popular Chart Types when in card analyzer view.

6. The gauge cards beneath your single value cards are called Filled Gauge and are also in chart types under Popular.
7. The final chart in your screenshot is a line chart, also in Popular chart types.
8. Create all of these visualizations and add them to your new dashboard and arrange to your liking.
9. To add a solid ribbon with text select the text or header elements from the dashboard object ribbon on the right side of dashboard editor (similar to step 2).
10. If you do not see dashboard editor after your steps above, click the wrench in the top right of the page and then select "edit dashboard"

If you get stuck let me know!

ColemenWilson

1

Re: Replace part of string with another value in Domo Cards

Yes you can write a beastmode using Replace() , hopefully your values to remove are consistent.

you will need to replace within replace meaning one value at a time to replace all occurrences

for example start replacing the 1s , then a replace of 2s within the prior replace

here it is the code for your example , notice the last line is the actual beastmode to use

--  REPLACE(`String to replace`, 1, '')    Replacing the number 1

--  REPLACE(REPLACE(`String to replace`, 1, ''), 2, '')    Replacing the number 2

--  REPLACE(REPLACE(REPLACE(`String to replace`, 1, ''), 2, ''), 'Site', '')   Replacing the 'Site' values 

--  REPLACE(REPLACE(REPLACE(REPLACE(`String to replace`, 1, ''), 2, ''), 'Site', ''), ':', '') Replacing the ':' Values 

REPLACE(REPLACE(REPLACE(REPLACE(REPLACE(`String to replace`, 1, ''), 2, ''), 'Site', ''), ':', ''), 'Checkout Initiate', '')

Godiepi

1

Re: Bi-Annual graphs

Hi

Building up on DanB's logic, you can probalby need the following too

Concat( Year(DateField),'-',

Case when MONTH(DateField) <= 6 then 'H1' when MONTH(DateField) > 6 then 'H2' end

)

Thsi way you woudl get

2018-H1

2018-H2

2019-H1

And so which you will be able to use as an x-axis

rado98

1

Re: Data transformation Question

@DavidChurchman the explanation from @MichelleH was really helpful. I was able to successfully map the data. Thank you so much

Dev_

1

Re: Array Function in Beast Mode

@rmbourne I would recommend using the INSTR function instead of having to check every possible split like this:

case when INSTR(`enter_account_ids`,`account_id`) > 0 then `account_id` end

MichelleH

1

Re: Array Function in Beast Mode

@MichelleH approach seems like the more reliable option, clearly you'll need to tweak it a bit, since if for example your user provides 1013 as the Id to look for, this would match accounts Ids 10, 101 and 13 as well, if you know that the list of IDs will always be separated by spaces, then you could do something like:

CASE WHEN INSTR(`enter_account_ids`,CONCAT(' ',`account_id`,' ')) > 0 //Id is in the middle
|| `enter_accounts_ids` LIKE CONCAT('% ',`account_id`) //ends with the Id

|| `enter_accounts_ids` LIKE CONCAT(`account_id`,' %') //starts with the Id

|| `enter_accounts_ids` = `account_id` // Is the only Id
THEN 'true'

ELSE 'false' 

END

marcel_luthi

1

Re: Calculating Differences based on the Value of a Column

Here is what the beastmode would look like for column A % change between pre and post:

(AVG(CASE WHEN Survey Type = 'post' THEN Score A END) -
AVG(CASE WHEN Survey Type = 'pre' THEN Score A END)) /
AVG(CASE WHEN Survey Type = 'pre' THEN Score A END)

You can copy and paste this for Score B and C - just replace Score A with Score B and Score C respectively.

ColemenWilson

1

Custom Date & Timestamp Formatting in Analyzer View of Cards

Hello Domo users! As a relative newcomer to this fantastic platform, I am thrilled to share my first discussion post with the greater Domo Community. I've been working with Domo for nearly a year at this point, and it has been a wonderful experience and I truly admire the insightful analytics and operational abilities this platform is able to provide to its users.

Over the past few months, I have learned how important it is to properly present and format dates and timestamps to provide insightful analysis and present accurate and impactful representations of data. Whether it is a minor use case or a monumental project, this is a reality that everyone will experience in any situation when presenting data. Today, I would love to demonstrate to the Domo community how exactly we can utilize the custom date & timestamp formatting abilities that can be accomplished in Domo.

I learned that the patterns used for custom date formatting in this view are based off the DateTimeFormatter class in Java. While there is documentation available for the DateTImeFormatter class in Java, I would like to provide specific examples that anyone can use in their own use cases in Domo. To illustrate this, I've experiemented with various examples based on the following timestamp: Tuesday, March 14, 2023 03:09:26 PM

Examples:

Full date with day of the week, month, day, year, timestamp in 12 hour AM/PM format, and AM/PM distinction: EEEE, MMMM dd, yyyy hh:mm:ss a (Ex: Tuesday, March 14, 2023 03:09:26 PM)
Full date with day of the week, month, day, and year: EEEE, MMMM dd, yyyy (Ex: Tuesday, March 14, 2023)
Date and time in the format "yyyy-MM-dd HH:mm:ss": yyyy-MM-dd HH:mm:ss (Ex: 2023-03-14 15:09:26)
Short date format "MM/dd/yyyy": MM/dd/yyyy (Ex: 03/14/2023)
Year and month: yyyy-MM (Ex: 2023-03)
Abbreviated day of the week and short month name: E, MMM dd (Ex: Tue, Mar 14)
Custom pattern for day of the week, day, month, and year: E, d MMM yyyy (Ex: Tue, 14 Mar 2023)

KEY:

Date Shorthand:

L (equivalent to "Date Shorthand" date format) (Ex: 03/14/2023)

Quarter:

Q: Fiscal quarter in numeric format (Ex: 1)

Week:

W or w: Week in numerical format (Ex: 11)

Day of Week:

e: Localized day of week (Ex: 2)
E: Short-hand day of week (Ex: Tue)
EEEE: Full day of week (Ex: Tuesday)

Day:

d: Day in one or two digits (Ex: 14, or 5 if the date was March 5th)
D or dd: Day in two digits (Ex: 14, or 05 if the date was March 5th)

Month:

M: Month in one digit (Ex: 3)
MM: Month in two digits (Ex: 03)

Year:

y: Year in two digits (Ex: 23)
Y or yyyy: Year in four digits (Ex: 2023)

Hour:

HH: Hour in 24 hour AM/PM format in two digits (Ex: 15, since 3 hours after 12pm is 3pm)
k: Hour in 24 hour AM/PM format (Ex: 15)
hh: Hour in 12 hour AM/PM format in two digits (Ex: 03)
h: Hour in 12 hour AM/PM format in one digit (Ex: 3)

Minute:

m: Minute in one or two digits (Ex: 9)
mm: Minute in two digits (Ex: 09)

Second:

s: Second of a minute in one or two digits (Ex: 26, or 9 if the timestamp was 03:09:09 PM)
ss: Second of a minute in two digits (Ex: 26, or 09 if the timestamp was 03:09:09 PM)
S: Fraction of a second (Ex: 246 if the millisecond part of the timestamp 03/14/2023 03:09:26 PM was 246)

AM vs. PM:

a: AM or PM in timestamp in lower case (Ex: pm)
A: AM or PM in timestamp in upper case (Ex: PM)

Offsets:

Z: Time zone offset (compared to UTC) expressed as hours and minutes. (Ex: -05:00 for Central Standard Time (CST) to UTC cross-comparison since there is a 5-hour difference between those time zones)
X: Unix timestamp (Ex: 1678824566, since 1,678,824,566 seconds have elapsed since January 1, 1970 00:00:00 UTC (the Unix epoch) given that the timestamp is March 14, 2023 03:09:26 PM in CST)

Please feel free to explore these formatting options in your analyzer view and leverage the incredible abilities Domo can provide to your use case! I am an active Domo user, so you are all welcome to respond with your comments and questions about this topic, and I'll be more than happy to make additional edits and provide assistance in any way I can!