McSQL Contributor

This isn't available today to my knowledge. Are you able to use the external APIs to pull the data into a domo data source?

@Casey_Dorman I believe this is on the radar of the team. I'm not sure the timelines.

@Jen Domo has some "Writeback" connectors to do things like this. S3, sftp, google sheets, box, and others are available. You can get the appropriate tile unlocked by contacting your Domo representative.

I will share this, it is always helpful to have the community submit the feedback as well directly (under "More ->FEEDBACK). This feedback is reviewed by the Domo team.

@MB_Dem I'm glad you have a way to resolve the issue. if the original dataflow is still in existence, I would suggest sending to the support team as it may help fix the bug. Would be nice to have the root cause fixed so that you and others don't run into this in the future.

GrantSmith's suggestion should work fantastic. Another option is to restructure the data in an ETL. Add a column to the data set that is MAU instead of having it as a dedicated row in the data source. Either way will work, just depends on what technology you are most comfortable with.

@bjavery87 How I have done this in the past is almost identical to the suggestion from ArborRose, but here is more detail. I created two beast modes. beast mode 1:case when value>=(target value) then value else 0 end beast mode 2: case when value<(target value) then value else 0 end use a line stacked bar chart. set color…

@mattAnonomatic using the domo cli tool or directly via the api, you can upload an empty file to the data source and it will effectively truncate the data set. This statement isn't fully accurate: "We even tried importing a single blank row into the source dataset but because the dataset was not created via API, it cannot…

You can also try the new Jupyter integration. There is a library called domojupyter. It's fairly easy to import the data into the workspace and from their you can use python to perform any other tasks you need.

Agree with what ArborRose said. If you need more customization than this, you can use the new Jupyter integration. Within Jupyter, you can write custom python code to parse the information and transform it in to the desired format.

The original question around data sets. Sandbox doesn't copy data between instances. You can use sandbox to copy connector definitions. Other options to get the raw data in place: virtual data sets or dataset copy connector.

@renee12345 When promoting a "Connectors" repository, you need to have the connector account defined in both instances. This is because Sandbox doesn't copy through credentials. There are also scenarios where people have a "Dev" credential and a "Prod" credential. This mapping functionality allows you to choose the…

This is a good suggestion. I would recommend submitting through the feedback portal in Domo. I can't think of a way to convey what you are describing with a pie chart look. A grouped bar or symbol bar chart can show $ and count together and may be an alternative approach.

@Rsandoval It's hard to know exactly what is happening, but I did come up with one possible explanatino. There are some advanced settings that can be applied in Magic ETL inputs. It can be set to only process new rows (see 2 below in screenshot or in documentation…

@mhouston I did a test with this beast mode and the logic seemed to work as expected so I think you are on the right track. It is essentially the same is as what you described but without the actual margin calculations. case when `margin1` is null and `margin2` is null and `margin3` is null then 'filter out' else 'keep'…

Agree with Ashleigh's comment. I haven't seen this behavior before.

@renee12345 Here is an example that I believe will work for you. I changed two things. I changed the DAY() function to Date(). The DAY() function returns the numerical day of month (i.e. 15 for Dec 15th, 2022) and Date() will return the actual date (i.e. 2022-12-15). Another change I made was that I added in date_add to…

@mroker can you provide more details as to where this is happening?

@zuchu I think this will cover what you want to do. If not, can you provide an example screenshot (maybe in excel) of what the input looks like and output. You can use the group by tile. In the "Select what columns identify the grouping" you would choose the account number. In the new aggregated columns, you would choose…

This is great feedback, I would submit this through the "More>Feedback" location in your Domo instance. This feedback gets routed to the correct team at Domo.

Assuming this data is in the same dataset, you can do the use beast mode to get the two numbers side by side. The beast mode would look something like sum(case when year(`date`)=year(NOW()) then `value` else 0 end)

The first thing that comes to mind is to use python to copy the file to a consistent directory for workbench to pull from. There is a python library called os that has a "walk" command that can traverse all subfolders and files in a directory and if they match the search criteria, you could have the file copied.

I reviewed this and I think I have a solution/work around for you. First off, the main issue is with the data structure. The data structure doesn't allow the calculation to be completed using beast mode. The way that I resolve this is to union the data to itself and advance the month of the second data set by one month. I…

There is a beast mode that converts a number to the format: sec_to_time(AVG(`columnname`)). This could be used in a table card to show the exact time component. Unfortunately, I think you may lose your color differences if you use this in the card, because it may not be able to compare the resulting values. Another…

This will take a little more in depth review. We will reach out offline to review in more detail.

The reason for this is that our card builder has the ability to drill across different data sets. When changing the data set on the top level we don't always want the drill down to change as well. I like the idea of having a way to choose whether you want to change all levels on a card or just the current level. Please…

Are you starting with raw dates and the "week-1 2015" is generated by the domo card or does the raw data have a column with "week-1 2015" in it?

Can you provide a sample visual of the report that you maintain? (excluding any sensitive information)