ST_Superman Domo Employee

I think it would be something along the lines of... sum(`N` * `X-Y Average`) / sum(`N`)

Thanks, that's helpful. Do you know which field, or fields, could act as a unique identifier? From your previous example, it does not appear that either SurveyID or ResponseID are unique. Maybe some combination of IP address, email, start date, end date? Basically, you need to uncollapse the "Question" and "Answer"…

You could use a drill path to have the user click on the month they want to explore and have the underlying view aggregate at the week level. Also, would having them use the "Graph By" option work for you?

I feel like there needs to be an extra column in this dataset somewhere. Otherwise, there is no way to distinguish between the two different dates for the HR survery results. Is there a batchID field, or something similar that is missing from the sample dataset you gave?

This is how I would do this in MySQL: Transform 1: SELECT `Clusters affected:` ,substring_index(`Clusters affected:`,'| |',1) as `First Cluster` ,substring_index(substring_index(`Clusters affected:`,'| |',2),'| |',-1) as `Second Cluster` ,substring_index(substring_index(`Clusters affected:`,'| |',3),'| |',-1) as `Third…

Have you tried using the Magic ETL "Split Column" tile? You should be able to delimit the column by "| |" and then do some more clean up for the first and last column

I don't like seeing all of those nested case statements. Could you try something like this? Just to clean it up a little bit? case when `mysql_major_version` > 5 then 'false' when `mysql_major_version` < 5 then 'true' -- if the major version is equal to 5 the case statement will move on to the next when statement when…

I think that you could write a beastmode that would let you filter your data: CASE WHEN `Verison` < '5.7.12' THEN 'Less than 5.7.12' ELSE '5.7.12 or Later' END

https://knowledge.domo.com/Optimize/Notifications_and_Alerts/03Creating_a_Custom_Alert_for_a_KPI_Card View the section on "Customizing Your Alert Message"

This required me to use a dataflow. I am more comfortable using MySQL, so that is how I built this data set. If you would prefer me to walk through the ETL side of things, please let me know. Step 1: You need to add a calendar data set. This dataset needs to list every day that you would be interested in being able to…

IFNULL (`country`, `country_1`)

Go to the knowledge base and search for: Changing the Date Format in Your Chart There red is a chart property that should let you do this, the macro for weekday name is E

I can't think of an easy way of doing this. Seems like an enhancement request. You could play with creating beastmodes to create those preset values you are looking for and then use that for your filter card instead of the date selector.

What we could really use here is the FORMAT() function. @DaniBoy (hint, hint) However, as that is not an option for beastmodes, we will have to get more creative with our solution. It's going to look something like this... but I have not had the time to test it out: CONCAT( COUNT(`Meeting Identifier`) ,' Meetings and $'…

You will need to bring in some kind of an aggregate column to your table. Something like Count of Clicks. This will agregate your table to only show unique emails. If you want me to get more specific, I will need to understand more of what your data looks like and how you are trying to display it.

You should only filter a field one way. If you want to place that filter at the page level (which I agree sounds like the right approach here), then you should remove any other filters for that field that were placed on the cards on that page. For example, if you select the last 30 days on a page filter, but the card was…

I apologize in advance for not knowing if this is part of a beta I am in or a part of the general release. Do you have access to Tooltips? If you do, then you can create a beastmode for the calculation `%positive sentiment` - `%negative sentiment` Then place that field in the Tooltip Field 1 axis and set the Data label…

This looks like you want to create a bubble chart with quadrant lines: https://knowledge.domo.com/Visualize/Adding_Cards_to_Domo/KPI_Cards/Building_Each_Chart_Type/Bubble_Graph

You could also use DATE_FORMAT() DATE_FORMAT(`Date of Invoice`,'W%V-%y') But that will also result in a text field. It does not look like the chart properties supports the week outputs: https://knowledge.domo.com/Visualize/Adding_Cards_to_Domo/KPI_Cards/Chart_Properties/Changing_the_Date_Format_in_Your_Chart This might be…

It is a tile in a ETL dataflow. If you aren't an Editor or higher, I don't think you will have access to the ETL dataflow option. If you are, and you need help creating one, let me know and I can provide some more screenshots.

If you are comfortable with REGEX, I'm sure you could accomplish this that way. However, you can also use the "Split Column" tile.

@swagner built this tool using power query, you might get some error messages if your version of excel does not support it. CONCAT('<a href=''https://superman.domo.com/page/########?pfilters=[' -- Replace superman with your account name; ####### with target page id -- Page filters to pass to landing page ,'{"column":"field…

I'm going to refer you back to my original post where I suggested some data engineering. Taking your screenshot, I have tried to replicate this process for you: I started by Collapsing the columns in an ETL: Output Dataset Then you can graph the data to show what you are looking for. How many tickets were created in a…

Does the database that your workbench is pulling the data from still contain your historical data? If so, you could run the job once as a full replace and then switch it back to an append

OK, then you need to place that beast mode as the series and select "no aggregation"

You can also use the "Split Columns" tile to accomplish this:

I do think that "Publish Dashboard Design" is on the development timeline. You may want to reach out to your CSM to see if there is a beta yet. @DaniBoy - Are you aware of any beta programs that would let @user17827 publish his dashboard layout?

Then what is the beastmode that you are using to classify the status of each ticket? Are you using the beastmode I provided? CASE WHEN `Resolved` IS NULL THEN 'Open' ELSE 'Resolved' END

I'm not sure what is going on with your visualization. If each row of your source data has a created date, and issue #, and a resolved date (which is null if the ticket is opened), then the beastmode that I provided should only give one status per issue #. Does your data source have two rows of data for each ticket? one…

Use another beast mode for y axis: COUNT(DISTINCT `Issue #`)