ColemenWilson Coach

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…

Hi Juliane, which Salesforce connector are you using? And which data selection method?

@NateBI I was able to accomplish what you are looking to do using a Redshift Dataflow. If you don't currently have Redshift dataflows enabled you can contact your CSM, or you could attempt this same logic in Magic. First, I created a new field that gives the order of the data, similar to rank but for every row in…

You could recreate those two fields as follows and then drag them into your card in place of the current 2 fields: City_2: CASE WHEN `Number` = 1300 THEN 'D' ELSE `City` END Number_2: CASE WHEN `Number` = 'E' THEN 1400 ELSE `Number` END

There actually is a way to allow filtering from one filter but not another one. To do this, go to: Edit Dashboard > Edit Content (on your filter slicer) > Change Interaction > Apply to selected Cards. See below:

Hey Ash, I agree this would be a great feature! In the meantime, you could use filter cards on the page itself. These function as the page filters do with even greater control. They can also be rearranged in the manner you are looking for because they are cards on the page.

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