MarkSnodgrass Coach

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. @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.

Is your data in all uppercase? The evaluations can be case-sensitive.

It looks like you are using the heat map table. If you switch to the mega table chart type, you can use the expand/collapse feature I suggested.

You could do this in the table by putting your classification in the first column and the content type as the 2nd column and the % as the 3rd column. Then, in the chart properties, go to Subtotal rows and and select Show Subtotal Rows. This will create an expand/collapse feature on the first column, which will allow the…

If you put two single quotes there instead of just one, it will know you will want to use a single quote. BISCAYANE MEN''S WELLNESS CENTER

In the Chart Properties - General, you can enter a value in "Maximum Slices Before Other" and that will limit. Make sure you also have your sales metric in the sorting properties and set to descending.

When troubleshooting these kinds of things, I will temporarily create multiple beast modes that is just extracting a single component so I can see where the logic is off. Try making a beast mode just for days using the logic for days and see if that reveals to you what additional logic you might need to add. My days logic…

It looks like your data has extra spaces at the end, which is why it is displaying the full value at the beginning when there is no day at the start. Adding a TRIM function around the field would help. Also, looking to see if there is a space towards the start of the string to see if there is a day value will work as well.…

You can use the SPLIT_PART function and CONCAT function to build this. It would look something like this: CONCAT( split_part(Time,' ',1),' days ', RIGHT(split_part(Time,':',1),2),' hours ', split_part(Time,':',2),' minutes ', split_part(split_part(Time,':',3),'.',1),' seconds ' ) You would need to add additional case logic…

Possibly. Something like this might work.

You would need to add an additional output dataset, but if you did a group by to get the max date in the dataset and then also apply the LAST_DAY() function to make normalize to a single date in a month. This should give you a single row. You can then set the alert for when the any row has changed. Hope this helps.

You might need to define closely match. The first thing I would try would be to use the TRIM() and LOWER() functions on both addresses to remove any hidden spaces and eliminate any case sensitivity issues.

@chetan_cricut here is what @GrantSmith is suggesting. From the list of charts, choose Gauges and select Multi-value Columns chart. In the date range select Previous and Last 4 Days Create a beast mode called "Last 3 Days" that looks like this: CASE when date >= DATE_SUB(CURRENT_DATE(), INTERVAL 3 DAY) THEN confirmed_total…

I see what you mean in the series for the non-hovered bars in the series. I would start with a support ticket and see if they acknowledge it as a bug. If you don't have any luck with that, I would submit it as an enhancement in the Ideas Exchange and see if it gets incorporated into the future. Glad you are enjoying my…

I'm not surprised if you are having trouble as I have found changing background colors to be problematic. I believe there is hope in the coming months with the release of App Studio that was shown at DP23. However, I tested changing my dashboard background to black and the card background to black and left the hover text…

Seems like a support ticket might be necessary. In the meantime, you could copy and paste the contents of your ETL into a new ETL and try and run it. You will have to create new output datasets in the process. I would also suggest breaking it out into two ETLs and try and determine if it is the lower smaller workflow is…