ST_Superman Domo Employee

The data set does not need to be the same, but the field name and values you are wanting to filter on need to be the exact same for each data set on the page. For example, if you created your icons using a field `Product Group` to identify different areas on an .svg file and the values were 'Produce','Clothing','Shoes',…

Just to be clear, the limitation is not that it is a beast mode. You can certainly use beastmode calculations as a filter. The issue is that you cannot use an aggregate function as a filter. That is true whether the aggregate function is a beastmode or not. For example, if you wanted to filter out any customer with less…

Mind sharing the settings for the alert? It might help to see what you are using for a summary number and that beast mode you mentioned

ROUND(DATEDIFF(`date of birth`,`date of interaction`) / 365,1) This should provide the age of the customer in years, rounded to the nearest tenth. Although I’m not sure I have the number right, if you get negatives just flip the two date fields

This has been mentioned in a previous post somewhere. (apologies, I was not able to find it in a quick search) This is typically an issue when you are drilling from a chart into a table view of the data. In this case, because the color rules are assigned to the entire card (including the drill path views) at the main card…

The filter cards always sort in either ascending or descending order based on the field it is displaying. I think a nice feature request would be to have to ability to sort these by another field. However, as a workaround, you could try using this as your beastmode: (CASE when CURRENT_DATE()-`date` < 8 then ' 0 - 7 days'…

I want to be able to change the schema I can pass it as a string if I read an ID consisting of numbers only from DB. Even if it is a text type by the format etc from TreasureData or Google sheet, If you import into DOMO, it will be treated as a number. (There will be no part to be filled in.) Because types are different in…

via Google Translate: When importing data from an Excel file, if there are merged cells, all but one cell will be blank. In the case of a combined cell, can you not make it a specification that all data can be included? Thank you for your consideration.

You mean like a union? try: SELECT a.`ID` ,a.`Name` ,a.`Description` ,a.`Value 1` ,a.`Value 2` ,null as `Value 3` FROM `Dataset 1` a UNION SELECT b.`ID` ,b.`Name` ,b.`Other Description` As `Description` ,null as `Value 1` ,null as `Value 2` ,b.`Value 3` FROM `Dataset 2` b

MySQL dataflow: SELECT a.`ID` ,a.`Name` ,a.`Description` ,a.`Value 1` ,a.`Value 2` ,b.`Value 3` FROM `Dataset 1` a LEFT JOIN `Dataset 2` b ON a.`Description`=b.`Other Description` Let me know if you prefer an ETL transform

I agree with @guitarhero23 ... If you need to be able to filter by the count of files viewed, then you will have to add the count to your dataflow. However, this will not allow you to change the date range or filter for different collections of files. I might suggest that you sort the visual by the count of files viewed in…

@robertc Would you mind sharing a screenshot of your Domo settings for this dataset?

What field are you filtering on? When a user selects the year 2017 they are applying a filter to look at a field and only keep the results that =2017. could you provide some screenshots of sample data, as well as how you are expecting the card to behave?

That's an interesting issue. The problem is that you can't use an aggregate field as a filter. Have you considered hiding the legend altogether? You could always add in a table or pivot card below it if you still want the data there. Another option could be to change the card to show the top 5 departments and bucket the…

Your .svg file needs to have the regions defined on it already. You also need to make sure that it has a transparent background. at about 1:55 on this video I describe how to label the objects, which adds a tag to the .svg code. these tags are how the custom map will define the different regions.…

@pimogo - In theory the custom map (the chevron image that you showed) should be able to be configured to behave like any other map. Once you define the regions and map the data to each region, then you should be able to use data label settings to provide the summary numbers. Here is a custom map I used to add sales…

You could create a custom map and map the data to it. I think this should be doable without a custom app. i have a video where I walk through converting an image to .svg and then to a custom map file here: YouTube clip

I would be surprised if you ran into any issues moving the jobs over. I would want to confirm with the support team first though. I’ve never done this myself, maybe someone else has?

Could you split the visuals up then? Maybe show two flex tables next to eachother, with one showing the graph and the other showing the change indicators? (the later using the (-1)*`value` solution proposed earlier) Otherwise, display the graph with an actual bar or line chart and then show the modified flex table below…

@StyLe - You are correct. I was thinking about the properties for the Comparative Guage card. That will teach me to try to answer dojo questions from my phone ? However, I think this is a very good feature request that should be added to the flex table. You should add it to the Ideas exchange. In the meantime, I would…

I’m pretty sure there is a chart property that allows you to indicate which direction should be green for a flex table

This is an interesting topic. I'll try to throw in my 2 cents here, but I'm also interested in hearing what others have to add... I think of skillsets for Domo as falling into 5 categories: * Data Science * Data Engineering * Data Visualization * Training * Governance I would recommend evaluating your current team's…

I think you are going about it the right way. Each sheet in Smartsheet is brought into Domo as a separate data set. If you want some more control over how the datasets are getting joined, you can join the datasets in MySQL or in ETL. I think there are still some limitations to datafusions (you can't use them as an input…

I agree with @guitarhero23 that this can be handled by a beastmode, and the case statement he provided should do the job. I also like the suggestion to use the quickfilter so you can choose to include or exclude the filter easily. However, my suggestion would be to make this kind of field within the dataflow. Beastmode…

That box should indicate which fields are missing. If not, then I think the culprit is typically buried in a beastmode field or was selected as the summary number. Interested to hear what any other users have come up with for this...

There may be other ways to do this, but I would start by ranking the dates and then filtering the data to only include the max date for each ID.

You can filter the duplicates out using either a MySQL, or magic ETL dataflow. Let me know your preference and I can try to show you the steps. If you want to keep the duplicate records in your dataset but only show one row on this card, try changing the agregation for your date column to be MAX

I believe this is posted in the ideas exchange by @swagner somewhere. Let me look for it and I'll add a link here...

I could offer a bit of HTML coding that you could add to your table to provide the desired result. However, rather then "drilling" into the data, you would be passing filters on to a new card. You would need to first build the "drilled view" as it's own card (and make note of the page and card IDs) Then modify this…

That would depend a lot on your dataset. However, there is no set function for Internal rate of return. You would need to use the mathematical formula to calculate it.