Best Of

Re: Is it possible to create a graph with categorical levels?

Agree with @jaeW_at_Onyx . I often use a heat map for this type of work. See below.

MarkSnodgrass

1

Re: Is it possible to create a graph with categorical levels?

@ramoshe if you want categorical values on the X and Y axis you'd need a different chart type.

Consider a heat map. or pivot table

jaeW_at_Onyx

1

Re: "The Pivot Table is Only Showing Part of the Data" Error

For future reference this is mentioned just above the "Customizing Pivot Tables" section in the knowledge base: https://domohelp.domo.com/hc/en-us/articles/360043429473-Pivot-Table#3. By default there's a limit of 25,000 rows to display. See the section " What are the DataSet row limits for each chart type?" on this article: https://domohelp.domo.com/hc/en-us/articles/360042924214-Card-Building-FAQs

GrantSmith

2

Re: Failed parse text 'NULL' from column 'Column Name' as type 'Date'

Alternatively with the new ETL 2.0 you can set the data type to be a time stamp directly on the Input Dataset Tile under the Configuration tab and then click the gear icon to define how to handle bad values - in your case you can select null:

Screen Shot 2021-10-18 at 4.28.50 PM.png

GrantSmith

2

Re: "The Pivot Table is Only Showing Part of the Data" Error

Hi @Tow, it's likely that your pivot table has too many rows to process from the size of data being pulled in. In order to fully build the Pivot, the number of rows would need to be reduced.

amehdad

8

A more flexible way to do Period over Period comparisons

Greetings! I see variations of this topic asked several times so I thought I'd write up all of the information in a singular spot for easier reference. Below I'll outline how I utilize my own date dimension table to have customized period over period charts, compare the current partial month to the same amount of time in the previous period (no more seeing your period over period percentage tank because the month isn't complete yet). I will also go over how to configure and set this up yourselves. Let's get started.

GrantSmith

6

Re: Aggregate Count of Line Items by Distinct Orders

NP. If you're looking for more Domo training or upskilling, I post tutorials and content here: https://datacrew.circle.so/home

jaeW_at_Onyx

1

Cool blog post on DDX Bricks

Written by Jace McLean, Domo's Director of Data insights. He has more than 15 years of experience in data, analytics and technology.

I thought some of you would like to read his post on DDX bricks. Check it out here.

AnnaYardley

3