Comments
-
Can you describe more how you are wanting it to look? It bases the sizes off of the value field and the sorting property. You can manipulate it by creating a beast mode, but the end result would need to go in the value field. You can then make use of the different macros in the label settings and hover text settings to…
-
If you change their role to Participant, which is one of the five built-in roles, they will not have access to the admin center. Any other higher role (Editor, Privileged, or Admin) will have access to parts of the admin center. If the other capabilities that go along with the Participant role are too restricting, you…
-
Once you created the beast mode in the card, did you tell the card to use it in its specific date filter? I may not have been clear that you need to make sure each card is actually using the newly created common date field.
-
The name of your date fields need to be the same in all of your cards and your date filter in order for it to properly apply to all the cards. You can make this work by creating a beast mode with a common name such as "storyboard date" (or whatever works for you). The beast mode field only needs to contain the date field…
-
I would suggest you look into the Dynamic Textbox card to accomplish this. It could be powered by a Domo Webform or an Excel file that you or the controller updates. The dataset would have a date column and then a notes column and the notes column would go in the category field of the Dynamic Textbox card. The date column…
-
You could create a beast mode field that would group them into bi-weekly groups. You could do something like the following: CONCAT(MONTHNAME(`Date`), (CASE WHEN DAY(`Date`) <= 15 THEN '1st - 15th' ELSE '16th - EOM' END)) This would give you results, such as July 1st-15th, July 16th-EOM, etc... You would then just drag this…
-
In the General section of the Chart Properties, choose Sync Values. This will align the scales on the left and right side of the graph.
-
I would consider using a bullet chart because it has a Target Value field that is helpful to use in a case like this. You can create a beast mode field called target and put in a value of .20 and then drag this into the target value field. You might need to choose the aggregation type of Average, depending on your data.…
-
The treemap doesn't really lend itself to doing that type of colorization. In addition to the HTML table, you might look into the Shape Chart, which is found under gauges. You would need to create a card for each app_name, but you could create a story page, or a collection and have them small and right next to each other.…
-
Those are the multi-value cards found in the gauges category in the chart types. To align it the way they are, go to the General -> Layout and choose Domo Summary 1 or Domo Summary 2. Here's a link to the KB article that breaks down all the different properties.…
-
@jaeW_at_Onyx is correct that your temperature must be a string value and needs to be converted to numeric. You can do this very easily in Magic ETL by adding a Set Column Type tile to your ETL. Also, you can simplify your CASE statement since CASE statements exit out of the function once it finds a matching criteria. This…
-
You can export all of your jobs to JSON files and then import them back in on your new computer. Just click on the 3 dots icon in Workbench and go to Export on your old computer. Select all the jobs and choose Export Jobs. Save it somewhere where you can access from your new computer (network of flash drive) and then go to…
-
Another date function you can use in Redshift is Extract. I use it and it looks like this: extract(year from "dateofevent") DateofEventYear, extract(day from "dateofevent") DayofEvent, I am able to use the date_part function as @jaeW_at_Onyx suggests, so I'm not sure what might be going on with that function in your…
-
Yes, you can do this in Magic ETL or MySQL. I am going to assume you want to do this in the Magic ETL. If your data only has values in only of those 3 columns, you should try using the combine columns tile. If your data has values in 2 out of the 3 or all 3 and you want to prefer column c when there are multiple values,…
-
I would suggest the pivot table card so that you can get it in the layout you want. I would also make Building Number a quick filter and then click on the wheel cog of that quick filter and choose Single Select, so that they can only choose one building at a time.
-
It looks like you have the ability to edit toggled off. In the analyzer, there is a row of icons that let you hide different parts of the analyzer to give you more screen real estate to edit. Click on Summary and you should see the Summary Number return to be able to configure it.
-
You can do this pretty easily in a beast mode. If an empty column is truly null, you can use multiple IFNULL statements, starting with column C since that is your preferred column to use. IFNULL(`ColumnC`,IFNULL(`ColumnB`,`ColumnA`)) If you don't have null values, but there are filled with empty spaces, you could build a…
-
You can copy existing ETLs. In the Data Center, click on the Dataflow icon on the left. Find your ETL in the list and click on the wrench on the right and choose Create Copy. You can then edit the newly copied ETL and give it a new name and new output dataset name.
-
You could use a Running Total card to automatically build the cumulative totals for you. You could also create a beast mode called DisplayDate (or whatever makes sense to you) that just has a AddDate function in it that would display the next months name instead of the month it is in. This function would do it…
-
@sdarmody You might be able to pull this off with a Heat Map card. Here is a basic example. Use your date for category 1, your count of tech support incidents for the value, and then a company name or something that doesn't have multiple values for category 2 so that your don't have multiple rows. You could create a beast…
-
When you create a beast mode and click on the check box, "share calculation on dataset", it will only show up in the card analyzer when that dataset is selected. They don't ever show up in the Magic ETL. You can, however, copy beast modes from one dataset to another by changing datasets for a card in a specific way. Here's…
-
@sdarba That does seem quite odd. I would reach out to Domo Support to get an answer from them. Unless you have an input dataset that this dataflow relies on that isn't finishing in time, it seems like you should be able to have it run at the specificed time.
-
I'm not aware of a way to favorite on a user's behalf, but here is a way to get around that: Create a new page called "old" or whatever you like and move the cards that are on the page that everyone to this newly created "old page". Next, move the cards that are on your new page to the page that everyone has favorited.…
-
I would suggest you look into either of these options and see what makes the most sense for you. Both of them revolve around taking data from multiple columns and putting them in a single column. Approach 1 - Use the Magic ETL Collapse Columns tile…
-
You should have as long as you would like to take an exam after you purchase it. However, certifications only last for 1 year, so you would want to pass the higher level exams that require completion of the lower level exams while you are still certified on those.
-
The first thing I would look at is changing your initial dataset that is populated by the MariaDB Connector from replace to append. Go to that Connector Dataste and click on Settings and then Update Mode and see if that is set to Replace. Try changing that to Append. This will append each day's data to this dataset and you…
-
Are you using something like Domo Workbench to query your source data and then pushing it to Domo? If so, you could limit your query to just the previous days data if you have a date column in your dataset by using a WHERE clause like: WHERE TransactionDate = GETDATE()-1 In Domo, you can set your dataset to append rather…
-
You could create another dataset in the Magic ETL that has your filter applied and then go to that dataset in the data center and export out that data by clicking on the export option in the top right. Other than that, I typically just create a pivot table or mega table card on my overview page where no one else can see my…
-
Support got back to me and they have implemented the fix. It is working in my instances now and should be working in anyone else's now as well.
-
The Campaigns app is intended to be used for e-mail marketing campaigns while making use of your data in Domo. Think of it like a Constant Contact version of Domo. Your Domo CSM should be able to set up an in-depth look into it. You can also look at the KB documentation here to better understand its features.…