Comments
-
You should be able to do this. Edit your dashboard and then choose Change Interaction on this card and see what the settings are. I have a bar chart like this and I can uncheck items in the legend. Here is what my interaction settings look like. You can also check the filter exceptions. Mine look like this.
-
You can do an @ mention to a group name, so if you know the name of the group or groups that have access to the dashboard, that should notify all of them. It would be a good suggestion for the idea exchange to have a @page or something to notify everyone that has access to the page.
-
To do a running total with the rank & window tile, choose Sum and then choose unbounded and 0 following and sort by date ascending. I'm not sure how you are determining lost clients, so you may need to explain more how that is determined if you need help on that.
-
@MaryAl Here are a couple more links for you as this has been a common question in the Dojo. https://dojo.domo.com/discussion/52677/domo-ideas-conference-beast-modes-number-formatting#latest https://dojo.domo.com/discussion/comment/44279#Comment_44279 Hope this helps.
-
Hopefully the history tab will be helpful for you. I would also suggest looking into rebuilding your dataflow in Magic ETL. Complex joins can be accomplished by using filter tiles after the join statements and other additional tiles, but the end result typically results in a much faster runtime.
-
Does the issue persist when you save the card and view it outside of Analyzer? Either way, here are a couple options for you. In the Data Label Settings, you can toggle the Allow Overlap checkbox and see if that helps. Use the Hover Text Settings instead of the Data Label Settings. You can have multiple fields of…
-
Are you using Magic ETL 2 for you dataflow? That will run faster than MySQL or Redshift dataflows, so I would switch to that if you aren't already using it. You can also investigate the individual steps of a dataflow by going to the history tab of your dataflow and then going to the far right of the latest run and click on…
-
I agree that it could be improved and it is more obvious to the end user which type of scheduling is being used. Glad it helped. If you can mark the answer as accepted, it will help others in the community that have the same question.
-
I agree that it is a bit confusing. When you go to the scheduling section of your dataset, if it is actually using Advanced, it will show you that first when you click on scheduling. If it is not using advanced, it will show you the basic. If you click on Advanced, it defaults to putting in the current time (in UTC) in the…
-
Pivot table is a good way to go. There is also the transpose property in the regular table that can be useful for turning your rows into columns.
-
Amazingly fast answer by @GrantSmith :) Beast modes also accept /* */ as comment blocks, such as this: /* check to see if the shift is in the same day */ (CASE WHEN DATE(`startdate`) = DATE(`enddate`) THEN /* same day*/ /* check to see if the start hour is too early */ (CASE WHEN HOUR(`startdate`)< 9 THEN /*move the start…
-
You could do a case statement to look for each color in the string, but I think you will need to create a beast mode for each color. For example, the red beast mode would look like this (CASE when `String` LIKE '%Red%' THEN 1 ELSE 0 END) Blue would look like this (CASE when `String` LIKE '%Blue%' THEN 1 ELSE 0 END) You can…
-
You can separate the multiple answers out into separate columns using the Split Column tile in Magic ETL. You would need to use multiple tiles to account for the maximum number of answers that a person might have selected. Once they are all separated, I would recommend adding an Unpivot tile so that you have a single…
-
@vgupta DDX bricks were just released by Domo and one of the new charts is called DDX Dynamic Columns. You may want to look into this and see if you can implement it. They are configured differently than traditional cards, but Domo has tried to make it as easy as possible to power it up. You can find it by going to the app…
-
Have you looked at the connectors in the Domo Appstore? Those are by far the easiest way to ingest data from other services. The Amazon S3 connector is popular connector, for example.
-
@CTBH if you go to your data center and then click on ETL it will open up an empty Magic ETL workspace. Highlight the code block above and press ctrl+c to copy it and then go to your empty Magic ETL workspace and press ctrl+v to paste it in. This will create all the tiles that I have shown above. You can then connect your…
-
When time elements are uploaded into Domo, it assumes they are in UTC already and then displayed for you in the timezone in your company settings, which is why you see a shift. If you can't make use of the option in Workbench for this file, you can adjust it in Magic ETL by connecting a formula tile to the input dataset…
-
You can't turn them at an angle, but I would suggest you make your chart a horizontal bar chart instead of vertical bar chart, which will make the labels easier to read.
-
@NathanDorsch The div tags cause them to be on separate lines. I haven't played around with formatting it like you want too much, but you could try div style="float:left" for your first div and div style="float:right" for your 2nd div. Here's a link to more info on the css style. https://www.w3schools.com/css/css_float.asp
-
I believe I came up with a way for you to do this using multiple rank and window and formula tiles in Magic ETL. If you copy this into a blank Magic ETL, you should be able to see all the tiles and what they are doing. {"contentType":"domo/dataflow-actions","data":[{"name":"Test…
-
You can use the summary number field to display this information. Read this post here on how to do the directional arrows, specifically cwolman's post on June 2019. https://dojo.domo.com/discussion/42497/summary-number-conditional-format-colors-with-directional-arrow#latest Alternatively, you can build a dashboard and use…
-
Some chart types have a setting for the text color to be complimentary, but it doesn't appear that the line + bar chart type has that setting. Unfortunately, you are stuck with changing the other colors or looking into a different chart type.
-
In the Chart Properties, under the data label settings, you can choose if you want line and bar, line only or bar only.
-
I think your best option is to reach out to support@domo.com and ask them to do a bulk delete. If you are an admin, you can individually delete threads, but not do a bulk delete. I would also ask support to disable buzz for the organization as the admin section only lets you turn off the general channel.
-
there is not currently a way in a table card to allow the end user to conditionally hide columns. You could use PDP to hide values if you need to hide sensitive information.
-
there is not currently a way in a table card to allow the end user to conditionally hide columns. You could use PDP to hide values if you need to hide sensitive information.
-
If you use the limit rows property and set it to 3 and then sort by point descending, you can use the LISTAGG() function to list them in a summary number in order. LISTAGG(playername) to show the name and the score you try: LISTAGG(CONCAT(playername,' | ', score))
-
If D365 Finance Operations has an accessible API, you may be able to use the JSON No-Code Connector to import the data, which helps you avoid the trouble of building a custom connector. You can read more about it here. https://domohelp.domo.com/hc/en-us/articles/360043433473-JSON-No-Code-Connector
-
To change the color of the line or bar without it adding additional items in the legend, use the color rules but leave the condition as "always" and then choose your color. This will allow to change the colors of each.
-
I believe @KenTravels is having this same issue. I would suggest opening up a support ticket and see if that gets Domo to look into the issue further.