Best Of

Re: Can there be a filter in the Webform while in edit mode.

Currently, filtering in webform edit mode is not supported. You can create a new idea in the ideas exchange if one does not already exist.

brycec

2

Re: Faceted Bar Chart Labels

@Backslash

You can also use the chart properties to only label the datapoints for the line if that makes it cleaner. Another option to increase visibility would be to make the line thicker.

ST_Superman

1

Re: WOW comp calculation not correct

@Anna_Otake Awesome, glad I could help! I'd appreciate if you marked my solution as the answer :)

ColemenWilson

1

Re: Create Conditional coloring based on a value not displayed in card

Hi,

Could you please add the details here? Only users with access to your company's support tickets can view the content at the link.

Thanks!

akeating

2

Is anyone importing their Domo datasets into Power BI?

Is anyone currently importing/exporting data from Domo into Power BI to combine data? I recognize that this is the purpose of Domo, but I'm exploring ways of getting datasets that are currently in Domo into Power BI as a work around for sales data governance. I know in the June release Domo came out with Domo ODBC Data Driver which allows for Domo data to be queried in Excel, but would the new feature allow for the same to be done in Power BI?

joshuajfleming

1

Re: What are the maximum row limits and column limits for a table card?

There are some limitations to the columns and rows for a table card. This article helps outline some of those limitations and the limitations of Excel if you're attempting to export the data

https://domo-support.domo.com/s/article/360043429573?language=en_US#row_limits

Also, visualizations have a default row limit of 25k for visualization but that can be changed in Analyzer however that will likely give a more negative user experience attempting to load that much data into a computers memory for visualization.

https://domo-support.domo.com/s/article/360042924214?language=en_US

GrantSmith

1

Re: Combine tables using ETL inner join

Is it also possible that some of your rows don't have leading zeros and some do? If so, you can use the LPAD() function to add leading zeros if everything should be a certain number of characters.

MarkSnodgrass

1

Re: Combine tables using ETL inner join

Second what Mark said.

Also, for problem solving. I'd take a small sample of the ones that didn't join and compare them between the two tables. Will probably find what Mark said and there are some leading or trailing blank spaces or case sensitivity.

AdamC

1

Re: Combine tables using ETL inner join

Here are a couple common issues with joins in Magic ETL

It is case sensitive
Leading or trailing spaces

An easy way to address both of these is to add a formula tile to each table prior to the join and use the following functions

UPPER() - converts the text field to uppercase

TRIM() - removes any leading or trailing spaces

You can do this in a single function like this TRIM(UPPER(fieldname))

Try doing this prior to your join and see if that works.

MarkSnodgrass

1