Best Of

Re: DOMO Connector for google sheets not working correctly

Hi @user019029, how did you go with this?

It could be that in the Domo connector settings, under 'Advanced Options' or similar, make sure you have selected the correct range of data.

amehdad

11

Re: Align headers to bottom

Hi @User_32265, the only changes you can make around header positioning for this chart option are:

Header Alignment 'Centre'
Header Row Font Size to something smaller to reduce the empty spaces below your current headers

Alternatively, you can switch your chart to 'HTML Table' as the headers for this particular table type are evenly distributed.

amehdad

10

Re: Facebook Ratings Connection

Hi @imelendez, it's odd that in the article [https://domohelp.domo.com/hc/en-us/articles/360043434413-Facebook-Advanced-Connector], it mentions the metric you are after but not which report it would sit under when you set up the connector. Have you tried 'Custom Insights' in Report and then searching the columns for "ratings"?

amehdad

6

Re: Formatting Heatmap and Table card

Hi @tleong - I do not believe titles are supported at the top of Heatmap cards (although if you are creative enough, you can do pixel art with them, as one colleague did!)

Screen Shot 2016-11-02 at 9.10.27 AM.png

The closest I can suggest for getting a title on top of your Heatmap is to leverage the Summary Number label.

If you are looking to get more details out of a "Heatmap-like" card, I would recommend using a Sumo Card, where you can turn on subtotals/totals and use conditional formatting on columns that behaves similarly to a heatmap.

Depending on what your end-goal is, a "Heatmap Table" card will let you have column labels, but does not support totals.

As for showing a blank column in the middle, you can do a Beast Mode where the formula is simply an empty text string (i.e. '').

As for using multiple colors, you can see with the Mario pixel art above that you have flexibility in which colors are used for different number ranges, but as for controlling the colors used in different columns, I am not sure if that can be done.

AdamT

2

Re: How to create dynamic X range from backend or Beastmode?

You can build your range dynamically in Magic ETL with the use of the formula tile. I broke it up into groups of 10, but you could break it up into different groups by changing the numbers around if you wanted to. In the screenshots below, I am building a range dynamically using a few formulas:

This is what it result in:

You would then place the rangetext field in the x-axis of your card to get and it would show the necessary ranges based on the data.

MarkSnodgrass

2

Re: Difference in Business Hours

I think I have something for you to get your started.

/* check to see if the start hour is too late */
(CASE WHEN HOUR(`startdate`) >= 17 THEN
((UNIX_TIMESTAMP(`enddate`) - UNIX_TIMESTAMP(
 /*move it to the next day and start at 9 */
 	ADDTIME(ADDDATE(DATE(`startdate`), interval 1 day),9*60*60)))
/ 3600)
ELSE
 /* subtract and then divide by 3600 to get the hours */
((UNIX_TIMESTAMP(`enddate`) - UNIX_TIMESTAMP(`startdate`))
/ 3600)
 /* if there is a difference in days, subtract 16 hours per day */
 -
(DATEDIFF(`enddate`,`startdate`)*16)
END
)

You will need to add some additional case statements to deal with weekends by using the WHEN WEEKDAY(startdate) IN (1,7) which is Sunday and Saturday as I wasn't sure how you want to handle those. Hopefully the above makes sense. For a deeper dive into unix_timestamp, you might want to look at this post.

https://dojo.domo.com/discussion/52682/domo-ideas-conference-beast-modes-time-difference-formatting

With my testing this is what the above beast mode produces.

Hope this helps.

MarkSnodgrass

5

Re: Is there a way to create Running Total using Beast Mode?

Hi @lvtrujillot

You can utilize window functions in beast modes to accomplish this. You'll need to talk with your CSM to get it turned on. I've done a previous write up of window functions and running totals before. You can read up on it here: https://dojo.domo.com/discussion/52681/domo-ideas-conference-beast-modes-running-totals#latest

GrantSmith

3

Re: Share DataFlow (all input datasets)

Yes! It would also be great to see who already has access to a dataflow, similar to the dataset "Overview" tab.

MichelleH

2

Re: Is there a way to suppress sections (collections) in a page/dashboard?

Thanks @MarkSnodgrass , even though I don't like your answer :), I appreciate the quick response.

Idea submitted!!

jvanis

1

Re: Where can I find the logic for custom built dimensions?

@Joe_M, if you aren't the owner of the dataset, you should also talk to the person that is managing that platform where these 'Segments' fields are coming from. They may have a taxonomy doc that will have each field defined.

amehdad

9