Best Of
Re: DOMO Conditional Formatting in Tables (Change of text color only to an RGB value, not the full cell)
If you want the end result to look like this:
Then you can use an HTML table and create a beast mode that looks like this:
Re: How can I allow end user to "see all" rows?
You could pull this off using variables as well as a window function to create a row count. To create a row count, create a beast mode like this:
SUM(SUM(1)) OVER(ORDER BY Start)
Change Start to whatever field you need to order by in your dataset.
Create a variable control. I would use a radio button control that says "Show All Rows" and have Yes and No as values.
Now create a beast mode that you will drag into your filters that checks to see whether it should limit the rows or not. It would look like this:
CASE whenShow All Rows= 'No' THEN
CASE when SUM(SUM(1)) OVER(ORDER BYStart) <= 6 THEN 'Include'
ELSE 'Exclude'
END
ELSE
'Include'
END
Drag this beast mode into your filter and then filter to Include.
Now you can toggle with the variable control to show all rows or just the first 6.
Re: Is anyone having issues with filters using selectors
@alliu The filter values available to select are dependent on the other filters that are applied to the card/dashboard. For example if, you have filters for Region and Country, if you filter the region to North America then the Country filter will only show options for Canada, USA, and Mexico. If the values you want to see are not visible, then try removing filters based on other fields until you can see what you are looking for.
Re: ZIP code leading zeros being removed
If you are unable to change how the data is coming in as @ST_-Superman-_ suggests, you can use the LPAD() function to add the leading zero, when necessary. You can do this in Analyzer by creating a beast mode, or in Magic ETL using the formula tile. It would look like this:
LPAD(zip,5,'0')
This will add a zero to the front of the string if it is less than 5 characters to make it 5 characters long.
Re: Scatter Chart
Hi @Raymond -
Welcome to the forum. I'll try to guide you through the basics, not knowing the structure of your dataset is or where you are getting stuck. Feel free to follow up with more questions if needed.
The scatter plot chart type is found in the "Data Science" collection:
Once selected, the fields at the top of the screen will allow you to build your chart. For Scatter charts, you are allowed to add "X AXIS", "Y AXIS", "SERIES", "BUBBLE SIZE".
You will likely need to create a calculated field to allow Domo to generate the profitability, unless that is already part of your data. If you need help with that, please share some more about your dataset. In particular what fields would be needed and how you calculate profitability.
Re: ZIP code leading zeros being removed
If you can, import the data as a string instead of an integer.
Re: Creating an Artificial downtime for maintenance for only week and work hours
@jaeW_at_Onyx - He doesn't want to see the datetime difference though. He is looking for the amount of work hours between the two date time fields. So, if the workday is 9am-5pm. Then the time he would want for a job starting on Friday at 3pm and ending the following monday at 11am is 4. If you just did datetime diff, you would get 68 hours (minus the 48 hours for the weekend) and you have 20. Most of those hours were not during work hours.
Re: Displaying effort per day
@harropda - Are you looking for help in creating the new dataset? Or just if anyone has other ideas on how to accomplish this task? From what you have described, creating that new dataset should allow you to create the analysis you are lookin for.
Ultimately, if you want your graph to display daily data, your dataset will need to be set up with 1 row per day. In this case, one row per day for each Story ID as you have described.
Re: sum case
I think that you could do this with a Pareto. Place BrandName in the Pareto Name and Sales in the Pareto Value. The graph will then tell you the % of total sales.
However, if it needs to be a Bar graph, you can use a formula like this:
SUM(Sales) / SUM(SUM(Sales)) FIXED (FILTER DENY BrandName)
Using this formula should let you place the brand name on the x axis and this value in the y axis to create your desired graph.
If you are running into issues, it would be helpful to see what your dataset looks like and how you expect to visualize your data.
How to "Improve" the Histogram Chart
I have always struggled with the histogram barchart in Domo. I love the idea of the histogram, but I always end up with very odd bucket ranges. You also don't get an option of adding a series to that chart. Here is an example of a histogram I am talking about:
My "improvement" is to use the scatter plot chart type.
For my x-axis, I create a calculated field. In my case, I wanted to bucket my data in batches of 10,000 for a field called StepPosition. So I used this code:
CONCAT(ROUND(SPUH step loss StepPosition/10000, 0),'0-', ROUND(SPUH step loss StepPosition/10000, 0)+1,'0k')
For my y-Axis, I place the field StepPosition and aggregate to Count.
I can also add a series, in this case a description of the position based on the value. The output looks like this:
This "Histogram" has much more clearly defined bins and is easier to read. By using the Scatter Plot, you can also have more than 20 "bins".