Comments
-
Change it to this: CASE WHEN COUNT(Parent_Brand) > 1 AND COUNT(Product_Category) > 1 THEN SUM(0) ELSE SUM(Age_Market_Share) END
-
Ok. Try this instead: CASE WHEN COUNT(Parent_Brand) > 1 AND COUNT(Product_Category) > 1 THEN 0 ELSE Age_Market_Share END If Parent_Brand and Product_Category are your two filters, then when unselected, this will count how many are in the list. If either one are unselected then the count of the items in that list will be…
-
Can you do a slight tweak to your case statement so that it will be zero until both are selected. Something like this: CASE WHEN Parent_Brand IS NULL OR Product_Category IS NULL THEN 0 ELSE Age_Market_Share END
-
You can do this much easier and quicker using Magic ETL. Here are a couple videos that walk you through how to do it:
-
I would look into using the Dataflow History DomoStats report and then filtering to Execution Type = Schedule and then looking at the Start Time. That should give you what you are looking for.
-
I think you are running into a limitation with the Period over Period chart types. They are notoriously light on flexibility. I'm guessing you have a beast mode for your X-axis as that chart type doesn't allow for any date formatting on that field like other chart types do. You can often accomplish the same visualization…
-
I would consider using the DomoStats Activity Log dataset. You can filter to Action = Viewed and Object_Type = Card to get those counts. You would need to join to the Cards dataset in your ETL to get the card name.
-
I would try creating a new app and create a couple pages with a card on each page and then add a button and see if it works. That might help you isolate the issue. Otherwise, I would probably open up a support ticket with Domo at support@domo.com to have them investigate the issue.
-
Hmm.. I was able to have it persist when opening a new tab. The column names of the datasets on the various pages would need to match exactly for it to work. Did you already check that?
-
You can't directly update a value of a dataset, but you can create a Magic ETL and use the formula tile to update a value. You would just write a CASE statement to find the right record to update it.
-
You can turn off the filter icon by clicking in the whitespace of a page in your app to reveal the page settings. You can then click on filter options and toggle off the Show Filter and PDP icons.
-
I received the Report Builder PDF in one of my instances today as I requested, but I am not seeing some of the features that are referenced in the document that I received when I was told the feature was live. For instance, I am not seeing any preview icons or PDF button.
-
Have you tried using the same YouTube video in the new brick that you are using in the old one? This would ensure that your new code is correct and it is something specific to the particular video you are trying to use, such as the video is restricted.
-
That's interesting that those are now deprecated. It looks like you will need to use the DomoStats Card Permissions dataset and filter the AccessLevel to Owner and then join that with the People dataset based on the Entity Id in the permissions dataset and the User Id in the People dataset.
-
Thanks for this announcement @Tasleema . Much appreciated.
-
The text generation tile is a new feature. @AndreaHenderson would likely be interested in your experience and may have some ideas on optimizing.
-
Assuming it is not a bug, I would open up the ETL and see what logic is in place that might need to be looked at more closely that could prevent the data from populating the 3rd dataset. I will often temporarily put in a filter tile when editing the ETL to focus on the current time period and troubleshoot.
-
You can check the status.domo.com to see if there are any reported outages going on. If it is still happening for you today, I would submit a support ticket to support@domo.com
-
If you go to the DomoStats connector, there are now two new DomoStats reports that will help you with this. AI Readiness Report and AI Readiness Details Report. The Details report lists the columns and their context and synonyms. The main report lists the dataset Ids. There is a DictionaryID that links the two together.
-
You should look into the Virtual Datasets feature in the Admin - Governance Toolkit of your Prod Domo instance. It is a great way to federate data to other instances without consuming credits.
-
This seems pretty straightforward so it makes me think you have some sort of data issue that is causing the issue. Here's how I would make sure your data is clean in Magic ETL and doing the math you want to do. You can do it in 3 tiles. Use the Alter Columns tile to force it to be a decimal. Use the Group By tile to sum up…
-
Great post @DavidChurchman ! I agree that much of what gets submitted into the Ideas Exchange gets lost or overlooked. It seems like Domo could use AI to mine the Ideas Exchange and group similar ideas together as well as do some other prep work to help the product or engineering team asses if something could be put on the…
-
I tend to use dynamic textbox card and place it right above the card that I am informing the user about. However, if you want it to be part of the card, you could use the summary number to display the information. You can use the CONCAT and DATE_FORMAT functions in a beast mode to construct your date and then choose that…
-
Domo has multiple ways to create "federated" data. One likely way this is now set up for you is through Virtual Datasets. The source Domo instance (your vendor) would have created a virtual dataset job in the Governance Toolkit to select which datasets should be federated to your instance. It is essentially a view and…
-
You can watch all of the sessions here: https://www.domo.com/domopalooza/resources I don't believe they are making the actual presentation slides available, though.
-
That is highly unusual. Is it one particular dashboard? Or is it any dashboard that you try and edit? Either way, I would log a support ticket, but the more information you can give to support as far as if it is one dashboard or all, will help them a lot.
-
Yes, there is a DomoStats dataset called Dataset Tags. This will give you a list of all dataset Ids and the tag(s) name.
-
Yes, you can use the office add-in to update data in Domo from your Excel sheet. Here is the KB article that walks you through it: https://domo-support.domo.com/s/article/000005143?language=en_US#update_datasets_in_excel Other options would be the Microsoft SharePoint Online Rest Connector. You can have the connector point…
-
You are right. I'm not seeing anything either. I would use the card description area to inform the user as to what each axis represents.
