Best Of

Re: Rounding Data within card

It'd seem many of your Count and Average columns are being retrieved from actual values from the Dataset your ETL generates, rather than being an aggregation at the card level:

This would explain why you get two entries for the same half hour period for the same account. Ideally any aggregation and calculation that should be dynamic and that can be affected by locally applied filters should not be performed via ETLs but either by using Aggregation on existing fields, or via Beast Modes that do the aggregation and oppertaions needed (like if you need a ratio or the like, you'll do something like SUM(value1)/SUM(value2))

marcel_luthi

1

Re: Wildcard for numbers not characters in Beast Mode or Magic ETL?

You'll need to start specific and then work your way down the list to be more generic with a case statement that way the more specific (BC or BW in your case) will be evaluated first.

CASE WHEN `Col_ori` LIKE 'BC%' THEN 'H'
WHEN `Col_ori` LIKE 'BW%' THEN 'H'
WHEN `Col_ori` LIKE 'B%' THEN 'B'
END

GrantSmith

3

Re: Standardizing Names

If you have a table like the one you shared, you could join column B to your data on column A. Then you wouldn't need a formula at all and as new mapping is added by the other department the values in the reclass column will update dynamically.

ColemenWilson

1

Re: Standardizing Names

Why not just do a left join in an ETL on your lookup table based on the InsCo field to pull in the Reclass value? This way you don't have to keep tweaking a regex

GrantSmith

1

Re: aggregating average value of a month

Do you have any sorting going on in your chart?

Also to simplify your beast mode you can use the LAST_DAY function to get the number of days in the month instead of having to use a case statement like you are:

SUM(`any_hva`) / MAX(DAYOFMONTH(LAST_DAY(`event_date_id`)))

GrantSmith

1

Re: How can i use alias with concat function in beast mode?

The name of your beast mode you use to create the formula is your alias. So you can create a beast mode with the CONCAT function and reference it by the name you give it.

GrantSmith

1

Re: Ability to turn off the "REQUEST MORE ACCESS" button for Social users

I agree with this. Generally we give social logins because there is a reason we don't want them to have full access. If someone needs a full license that request is handled through other channels, so we don't have a need for this button.

MichelleH

3

Re: Combining Multiple Flags Using Concat() and case stmt

Hi Larry,

It will work when the conditions are met, when they are not it will be completely null.

The solution here is to account for when the holds do not = 'Y' by adding ELSE to your case statement:

CONCAT(
CASE WHEN New Logo Hold = 'Y' THEN 'New Logo Hold' ELSE '' END,
CASE WHEN My Product Customization Hold = 'Y' THEN ', My Product Customization Hold' ELSE '' END
)

This is working for me and I believe giving the results you are looking for.

ColemenWilson

4

Re: Create a card that provides details of used licenses and total rows from all dataset combined

@Vineeth I don't think there is a way to make those Domostats datasets update more than once a day on a schedule. You can check with your CSM whether there is a way to make those datasets update more frequently if you need them to be more real time.

MichelleH

1

Re: Paritoning beta. Where to start?

@user029082 In that case I would recommend reaching out directly to Andrea or the beta team to help you with the your specific use cases.

MichelleH

1