ST_Superman Domo Employee

Each card needs to have a single dataset powering it. However, you can combine multiple source datasets and tables using a dataflow in Domo. You would then use the output of the dataflow to generate your visualizations. You can choose between: ETL dataflows https://knowledge.domo.com/Prepare/Magic_Transforms/ETL_DataFlows…

This kind of calculation would need to be handled from inside a dataflow. Are you always going to want to look at the trialing 6 week average (where event='N')? What do you do when you don't have 6 weeks of trailing data? for example, if the data is from three weeks ago, I would only have 2 weeks of trailing data, do I…

Thank you @cwolman and @Godiepi I'm not sure how many answers I can accept as a solution, but I've got this conversion working now.

Is the user listed if you click share on one of the cards in question? do you use PDP?

You could keep it unbounded in a redshift dataflow

I thought we had a solution here, but I'm not able to get the long timezone name to work:

I feel like this runs into the same issues. At some point you would need to change from CONVERT_TZ(now(),'UTC','EST') to CONVERT_TZ(now(),'UTC','EDT') I can't find a way to automate the switch, given that the actual date changes each year

Ha. Talk to @chucki to get added to the beta emails and he will keep you updated on what's available as they release the betas. You have to opt in to each beta program separately.

How do you determine the number of hours to subtract though? I would like to prevent the need to change my dataflow every 6 months or so

Apologies. It is very possible that is a part of a beta I am participating in. I forget which beta programs have gone live and which are still not fully available yet.

Are you using the text box as part of the Dashboard layout? Or the card "Text Box" card type? If you are using the Dashboard layout, you can select the kind of aggregation to be performed:

If you are creating a table card, and you have it sorted by `Job` then you should be able to get something like this to accomplish what you are looking for: COUNT(DISTINCT `PO #`) OVER (PARTITION BY `Job`) However, if you sort your table by something else, then this beastmode will break

Google translate: Twitch connector becomes "Twitch Account" in the data center account list, It is difficult to know which channel is connected.I'm glad that the account name is displayed like other Twitch and Instagram.

I'm assuming there must be more to this case statement, or else why not just use SUM(`quantity`) and format the summary number as a number with comma seperator? That being said, could you provide a screenshot with the summary number setting for the card that isn't working? As well as the beast mode formula:

If you are just appending rows, can't you just use a POST call? function uploadFile(name, description="", isPublic=true, file){ const formData = new FormData(); formData.append('file', file); const url = `/domo/data-files/v1?name= ${name}&description=${description}&public=${isPublic}`; const options = { contentType:…

I would try to get your first option working. You would need to first create your new dataset via the API. Once you have run the API and created the dataset, you should then be able to use that dataset in your ETL. When you say updated by API, are you wanting to append rows? Join new columns? Replace rows?

I don't have much experience with redshift, but I did find this article that may point you to some better performance: https://aws.amazon.com/blogs/big-data/top-10-performance-tuning-techniques-for-amazon-redshift/

In order to acquire quarter columns in ETL, processing was performed to acquire quarters of dates using "calculation of dates", but January to March becomes one quarter because the accounting calendar is not applied . I would like to adapt the accounting calendar to the processing in ETL. (just translating in case there…

I would suggest using the "Notify Moderator" option and ask them to delete the post:

You can try this: case when `mysql_major_version` > 5 then 'false' when `mysql_major_version` < 5 then 'true' -- if the major version is equal to 5 the case statement will move on to the next when statement when `mysql_minor_version` > 7 then 'false' when `mysql_minor_version` < 7 then 'true' -- if the Minor version is…

Have you had any Domo consultants look through your dataflow to make sure that it is optimized? I am surprised to hear that 50M rows is taking a full day to process. Are you using MySQL or ETL?

I have a few questions around this one. First, it looks like you are calculating the average spend by just dividing by the number of calendar months that a project spans. For example, project C would indicate 700 dollars for March even though it is only going through the 15th. Would it be better to calculate daily spend?…

I'm not sure if this is a question for the Dojo community, or more specific to your Domo instance. I would need more information about what datasets you have available and how you want to view this data in order to help you try to build something here.

Rather than drilling, you could set this card up on a dashboard and have the interaction apply a filter. This way you could place another card below this one that would provide individual user trends. When a user clicks on a group from the top card, it would filter the second card to only the users in that group.

I would probably create a card just for this alert. Your summary number would be a beastmode. Something like this: SUM(CASE WHEN `Date_Field`=CURDATE() THEN `users` else 0 end) You could then schedule an alert on this card to contact you anytime the summary number was equal to 0. You can even schedule the time that the…

Yes, you will have to join the datasets before using the calculator tile. I would not recommend a cross join. You should be able to join on the Currency Iso code. I would first select only the currency iso code and exchange rates from that table and then join those two rows to your main data set on the iso codes. Once you…

I have alerts built around age of datasets, an alert when total sales = 0, an alert around the last date that we received a service ticket... What, specifically, are you wanting to be alerted on? I am not aware of an ability to add SQL like assertions to Domo datasets.

yes, you will need to aggregate it. There should only be one Item Description for each Item though, correct? In which case MAX(`Item Description`) will provide the same result. However, if there are multiple descriptions for the same item, then you may not be able to make this work.

It looks like the tool tip field needs to be an aggregate calculation. I can't tell what field you are dragging into it, but it looks like you are trying to drag Item to the tooltip. If that is the case, then you don't need to use tooltip, you can use %_CATEGORY_NAME However, if you want to use the tooltip, you will need…

What kind of chart are you creating?