HELP CENTER

HELP CENTER

Turn on suggestions

Auto-suggest helps you quickly narrow down your search results by suggesting possible matches as you type.

Showing results for

- Dojo
- :
- Using Domo
- :
- Card Building
- :
- Calculate Average and Standard Deviation with miss...

Topic Options

- Subscribe to RSS Feed
- Mark Topic as New
- Mark Topic as Read
- Float this Topic for Current User
- Bookmark
- Subscribe
- Printer Friendly Page

Highlighted

- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Email to a Friend
- Notify Moderator

11-02-2016
08:56

11-02-2016
08:56

When calculating the average usage and standard deviation for a list of parts based over a time series the results are not what is expected. The problem is not having a complete list of dates for each part number. I would need to generate the missing dates for each item number with a value of zero for the equations to work correctly. See attachment for better explanation. I am unsure of how to accomplish this in Domo.

Accepted Solutions

Highlighted

- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Email to a Friend
- Notify Moderator

11-02-2016
09:43

11-02-2016
09:43

In Domo, you could use the SQL function IFNULL(), and configure it something like this IFNULL(`Quantity`,0) so that if the Quantity is NULL then it will be replaced with a 0.

-----

I work for Domo.

**Say "Thanks" by clicking the thumbs up in the post that helped you.

**Please mark the post that solves your problem as "Accepted Solution"

I work for Domo.

**Say "Thanks" by clicking the thumbs up in the post that helped you.

**Please mark the post that solves your problem as "Accepted Solution"

All Replies

Highlighted
##

- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Email to a Friend
- Notify Moderator

11-02-2016
09:07

11-02-2016
09:07

Hi @buzz_boom - This is a great question, and a common challenge. To work around this in Domo, we have a "calendar" dataset that you can leverage to join against to fill in the days that are not included in your dataset. To get this calendar dataset set up in your Domo instance, you can simply Buzz "@DomoSupport" and request it.

Let me know if you would like any other pointers on the joining itself.

-----

I work for Domo.

**Say "Thanks" by clicking the thumbs up in the post that helped you.

**Please mark the post that solves your problem as "Accepted Solution"

I work for Domo.

**Say "Thanks" by clicking the thumbs up in the post that helped you.

**Please mark the post that solves your problem as "Accepted Solution"

Highlighted
##

- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Email to a Friend
- Notify Moderator

11-02-2016
09:21

11-02-2016
09:21

Thank you for the quick response. I have a calendar that I am matching against to smooth the data already. By smooth I mean I push Saturday and Sunday usage to the previous Friday. Could you you tell me how I should be joining the data?

My first step is to join by usage table with my calendar table by the date fields. On the calendar table there is a field called "Report Date" which performs the smoothing of weekends to Fridays. So in my example 10/29 and 10/30 would be pushed TO 10/28. See updated attachment. In Excel when this calculation is done we do a pivot table and then replace blanks with 0. I would assume a similar operation in available in Domo.

Highlighted

- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Email to a Friend
- Notify Moderator

11-02-2016
09:43

11-02-2016
09:43

In Domo, you could use the SQL function IFNULL(), and configure it something like this IFNULL(`Quantity`,0) so that if the Quantity is NULL then it will be replaced with a 0.

-----

I work for Domo.

**Say "Thanks" by clicking the thumbs up in the post that helped you.

**Please mark the post that solves your problem as "Accepted Solution"

I work for Domo.

**Say "Thanks" by clicking the thumbs up in the post that helped you.

**Please mark the post that solves your problem as "Accepted Solution"

Highlighted

- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Email to a Friend
- Notify Moderator

11-05-2016
07:38

Highlighted
##

- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Email to a Friend
- Notify Moderator

07-14-2020
07:22

07-14-2020
07:22

Hi LizWR and AdamT,

I was going to help answer this question to see if this Calendar Dataset will resolve this problem as I'm facing something simular.

However, this Post is pretty old (2016), just checking if anything has changed since then. Do we still need to buzz support for this Calendar ? I checked the Data Connectors area I got a handful of Domo-related Connectors, but nothing on Calendars ... though Google Calender showed up when just searching on "calenders".

Highlighted
##

- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Email to a Friend
- Notify Moderator

07-14-2020
07:52

07-14-2020
07:52

Gotta love it when you answer your own questions.

Domo Dimension Connector: updated May 22, 2020

Has a Calendar option and a whole bunch of goodies.

Here's the link for anyone who has gone down this rabbit hole and stuck with it.

Cheers!

Announcements

Click here to submit your story.