Best Of

Re: Date formatting in ETL

@Victoria_G1 have you tried adjusting the date formatting on the card level? I find this is easier compared to adjusting it in the ETL or beastmode.

ellibot

1

Re: Time to Number value

If your goal is to get a result that is a time string like your input, I believe you want something like CAST(SEC_TO_TIME(SUM(TIME_TO_SEC(`TALK TIME`))) AS CHAR)

If you only want the hours (as a floating-point number), it would be SUM(TIME_TO_SEC(`TALK TIME`)) / 3600

If you want integer hours, invoke the DIV function instead of using the / operator: DIV(SUM(TIME_TO_SEC(`TALK TIME`)), 3600)

Magic ETL doesn't currently support EXTRACT or any of the functions in that family (e.g. HOUR, MINUTE) for time columns representing amounts of time, like you have in this case. They only work on calendric data like dates and timestamps.

Note that care must be taken when converting from text to time. These three common formats are treated these three ways:

1. '100' is treated as 100 seconds, i.e. 00:01:40

2. '100:59' is 100 hours and 59 minutes, i.e. 100:59:00

3. '100:59:59' is 100 hours, 59 minutes, and 59 seconds.

The 00:00 format is particularly troublesome, as it isn't always clear whether it was originally intended to be hours and minutes (which is the way it will be interpreted) or minutes and seconds (in which case you'd need to prepend '00:' to it for it to parse correctly).

rco

1

Re: Prevent table card from truncating columns on mobile platform?

Unfortunately... using text wrap doesn't work because that wraps the actual data as well, and makes some of the fields (especially date fields) much harder to read.

And manually setting the width doesn't really work either because the card has so many columns... and most of them vary in widths depending on the record... there would not be a foolproof way to manually set the widths of each of the columns.

There really just needs to be a "text wrap" option for just the column headers that doesn't affect the data... or an option to show entire header regardless of the length.

thanks for the ideas though...

Jeff

Jeffsnake

1

Re: How to add a Background image to the dashboard

What is the proper sizing for this without distorting the image?

ilozano

1

Re: Concat Formatting

you can add a TRIM() function around the entire concat function and that will remove trailing spaces. You can also do it around each field, which may help.

MarkSnodgrass

2

Re: how do you add the remarks in DOMO beastmode?

You use the SQL format for comments which is two dashes -- in place of a hash #

GrantSmith

3

Re: how do you add the remarks in DOMO beastmode?

You can also use this:

/*
my multi-line comments
go here
*/

MarkSnodgrass

2

Re: How do I create a MoM variance formula when the date format and interval varies for all entries?

Can you describe in plain words what you expect the above formula to do? At a Row level the MAX(Col) of something is always going to be the same value as Col making your denominator to always be 0, causing an error and therefore displaying no data.

To fix this you'll need to have some sort of aggregation function around your values, providing a table or image that illustrates what the desired final outcome would be is often helpful. If is just a single value for the current month this might be achievable (or the latest month), but if you want a table that shows this on a monthly basis, it's likely you might want to leverage Magic ETL instead.