MarkSnodgrass Coach

I would suggest pivoting the data in Magic ETL so each day is a row and then you can use the rank & window tile to create a running total. This will allow you to easily determine which day you broke even on. You can then pivot it back to your original format if you really wanted to. However, I would instead suggest keeping…

Are you receiving alerts on other cards or datasets? I would try creating a test dataset or card and creating an alert and then changing the data that forces the alert and make sure that you receive it. You can use the Domo Webform to quickly create a dataset and update it, or you could upload a sample Excel file. This…

@marcel_luthi they key to consecutive days is to add the Domo Dimension Calendar which has a row for every day. Joining your data to that will ensure consecutive days.

In the activity log dataset, you would look for where Action = 'CREATED' and Object_Type = 'PAGE'

I believe you can make a request to your CSM to allow you to schedule them to run more frequently, but they are not configurable by default.

Done… but not as fast as Grant and Michelle (unsurprisingly) 😁

I might end up making this as a separate idea in the exchange, but we need the ability to sort the items in the variable dropdown list. They don't automatically sort alphabetical and if you don't enter them in the right order the first time, you are stuck with that order. Just tried removing items and then adding them back…

I have a custom chart, but I use the standard themes. I just created a new card and chose my custom chart and selected custom color ranges and it worked without issue. Did you try creating a new card from scratch to see if that is successful?

The line chart does have series option and you would put your 2nd value in the series and choose an aggregate option. It looks like Analyzer didn't fully change chart options after you changed what chart you initially started with. Try removing the field from the y-axis and then add it back. This usually refreshes the…

There isn't a native chart type that would provide that layout. You might want to look at the Domo Bricks to see if there is something that would do that. If you are familiar with Javascript, you could use the Domo Blank Brick and build the bullet list array to pull this off. You could also look at the notebook card, but I…

You can use the new Office add-in to have your Excel file be a dataset in Domo. You would then power your card off of that dataset in Domo.

You can use Michelle's suggestion to exclude today dynamically and then you can use the date range filter on the card and choose last 3 days or last 2 days, which can be easier to maintain and is an easier visual cue for the end user to know the data range of the card. It also allows them to change it to other date ranges,…

You are right, that doesn't look great. I was expecting your "x-axis" to be grouped by day and not by each individual time element. You might need to create a beast mode for your dates and use the DATE() function to remove the time element. This would consolidate things a bit. Add this date beast mode to your chart and to…

The y-axis can't be text for this type of graph. You might want to consider using the heat map chart type. You can use your text labels for the "y-axis" and then use your numerical values in the sorting properties to get it to be displayed in the low to high order that you want. Here's the KB article.…

I would put your numerical value field in the values field of the card and then put your text field in the Tooltip Field and then use the Data Label Settings in the Chart Properties to display the Tooltip Field.

What do you mean by alias? If you are referring to referencing one beast mode within another, that can't be done in Analyzer, but it is something that has been suggested in the Ideas Exchange. The CONCAT function follows this format: CONCAT(expression1, expression2, expression3,...) An example would look like this:…

You can create the user as a Social User, which is free, and then share the dashboard with them via Buzz.

If you are referring to when you export a table card to Excel, it is worth noting that Domo added a new chart property that allows you to go up to 500k rows now.

You might try looking at this video to see if it is helpful for you. https://youtu.be/gSpL1ZHshug @Ellibot has a couple videos around slack integration that might be useful for you.

I would not use the -1 as that is going to just change it from July 31st to July 30th and is not what you want. I would use this to get the previous month: LAST_DAY(DATE_SUB(CURDATE(), INTERVAL 1 month)) Also, in your NULLIF function, your 2nd parameter is just inserting a blank. That will be problematic as a denominator.…

You have a lot of parantheses going on so it is a little hard to tell, but I don't think you have a second argument for your NULLIF function. Additionally, I would recommend evaluating months by using the LAST_DAY() function instead of just the MONTH function. Depending on the date range of your data, you can be looking at…

The totals and subtotals tend to follow the aggregation type used on the field itself. If you switch to average, your subtotal should show the average. Additionally, you may want to look at using the additional aggregation types available on the field that allow you to show the percent of the row or column for that field.

I would put survey type in your filter and filter to 2 and then just have your beast mode do the summing and not the case statement like this: ((sum(Promoter Count) - sum(Detractor Count)) / sum(NPS Count))*100

I agree with @MichelleH that it would be helpful to see the beast mode. Also, check what you have in the sorting properties. That can throw off what is being displayed since the single value card will only display one row. You could also try adding your beast mode to your filter and filter to where the value is not blank.

Are you able to choose an aggregation type in the value, such as SUM? Or is your aggregation done in the beast mode that is being used in the value?

It's odd that is blank, but the first thing I would try would be go to General - No Data Handling and choose Zero Value and see if that works.

I believe L1_dist_value should be category and event_date should be category 2 to get that look.

@chetan_cricut make sure you are choosing an aggregation of SUM on both the gauge value and comparison value

You can also use a LIKE statement and use wildcard matching depending on what your data looks like. As an example, here is what the first few rows would look like as a CASE statement. CASE WHEN TRIM(UPPER(prescribingfacility)) LIKE '%BISCAYANE%' THEN 'MIAMi-DADE COUNTY' WHEN TRIM(UPPER(prescribingfacility)) LIKE '%SOUTH…

You might try wrapping a TRIM() function around your prescribing facility field in your case statement to rule out any hidden spaces that are potentially causing it not to match.