ColemenWilson Coach

COUNT(DISTINCT(CASE WHEN `credit score` < 660 THEN `loan id` END)) / COUNT(DISTINCT(`loan id`)) Keep date as x-axis and then drag this to y-axis.

Not sure if you'd already tried this, but you could just use the 100% stacked bar chart type.

No because you will break out the group by into a separate line in the dataflow. So from you input dataset there will be two lines: 1. All rows of data 2. 1 unique row for each ID. Then you will left join the unique rows for each ID with the original input that has all rows of data. No rows of data will be lost.

This is best accomplished in a dataflow. Using magicETL you can use the group by tile and group by ID for the field Email and select the first non-null value option, then, with 1 email per id from the output of that tile, you can join that with you data on the ID field. Let me know if you have any questions!

There is no way to ignore these rows in the connector itself, the best solution is to remove those rows in an ETL as @MichelleH suggests.

I would do it in a dataflow. In Magic you would use the formula tile to get the flag on rows with a 100 in them and then use the group by tile to group on SO # and then join on SO # back to your granular data. Then you'd have a flag for each SO # that has an order product in it with 100 as shown in my last screenshot…

Okay I think I see what you are saying. You want an output like this right:

Hi zuchu, see below for the beastmode to use: CASE WHEN 'SO #' LIKE '%100%' THEN 1 ELSE 0 END Review your data carefully because this would also pull in anything like '100' will be marked as 1. So, for example, 1001 would be counted even though it is not 100. If your order numbers don't have anything before or after the…

Thank you @GrantStowell !

I don't know if you need an argument/condition in your rows but if you do it would be: CASE WHEN [argument] THEN CONCAT(`Location`, 'has more number of ',`Course Category`, ' students') END Otherwise it would be: CONCAT(`Location`, 'has more number of ',`Course Category`, ' students')

It is doing linear regression. If you toggle between Forecast Value and Linear Regression you get the same results. My guess is they include the "Forecast Value" for those unfamiliar with data science and Linear Regression.

I would use a dataflow but keep the data granular so drill downs are possible. I would just add a formula tile that for every row in the dataset gets the value from the first day of the month. Then the beastmode or calculated field in the ETL is really clean. A + B + C / D This would be the data structure and what they…

You can pull this information using the Domo Governance dataset: Dataset Schemas with Tags. This report includes the column tags and descriptions.

The legend on the right relates to the color grouping which is the last input you shared above. The bottom legend is the size of route markers. They will be bigger or smaller depending on the values you assign them and the legend shows the value scale so those viewing the card know what the relative sizes represent. There…

This may mean that there are permissions in salesforce preventing you from seeing GSA data in SF but not in Domo. Not sure, but just a guess. If I were you the next thing I would try is using the regular Salesforce Connector (instead of the advanced one) and select "reports" for HOW DO YOU WANT TO SELECT YOUR SALESFORCE…

Okay. I am trying to replicate this issue but I only see one legend when I build a lat/long route card. Can you share a screenshot of your card configuration? Like this:

Ah it is because you are using the Lat/long route map. The option is not available for that map type. Can you accomplish what you need using the standard map cards?

See below:

Gotcha, I thought the rank was already solved for. Okay, so the results you are getting are consistent with what I would expect to see based on how your ETL is setup. To have the rank start over after a null there needs to be some other field the rank is considering, if it is just referencing date and rule2_hours_marker…

You can accomplish this using a simple filter. Set the value to the location field and select the relevant locations then assign it to the user b user or the group to which people similar to that user belong. You can also accomplish this using the custom filter option, which allows you to add multiple criteria.

Thanks @GrantSmith. I made a comment that I realized wasn't answering the question so I "deleted" the comment by just clearing out the text, but there is still a comment on the thread. Kind of annoying but not a huge deal.

The 2000 row limit is a feature of the connector when no primary key is used. Have you tried an alternative primary key that would also be unique to each opportunity such as account ID? What do you mean when you say the data you are seeing returned is wrong?

It would, but it would be a troubleshooting step to take before switching the credentials out on each dataset. Additionally, I would create a support ticket after doublechecking the password and other inputs are correct by creating the new credentials.

You'll want both rank and order fields, so keep your rank field as it was before. For order, you can use any number of field combinations to determine the order. I am not sure what other fields you have available but I would think some combination of Date, Batch ID and/or Batch last run date should get the order right.…

Have you tried creating new connector credentials for NetSuite instead of updating the existing one? I know its a hassle but it has solved this issue for me with other connectors.

Hi chrissweeney92, have you tried using filter cards on the pages instead of page filters? Doing this will allow you to only show the filters you want to show. You can then hide the filter bar so that new filters cannot be added.

What is the error message you are getting in the dataset history?

No problem! Domo also announced column- level PDP at Domopalooza. When I followed up with them a week ago on it they said that it will likely be released sometime next year. It will allow hiding of entire columns from some or all users. Hope it gets released sooner.

PII Vault in the appstore is a good tool for this. Check it out in the Domo appstore!

Hi nwentzel, I consulted with a company that provided BI as a service and hosted data of many companies in a single instance. They utilized PDP, strict sharing processes using group sharing only (Ex. Group Name = 'Walmart'), publication groups, Domo everywhere, sandbox/publish and more. It may be helpful if I had a bit…