Best Of

Re: beastmode

@NIKKI Do you plan on having a single row per value of the Indicator Text field? If so you do not need to partition by that field in your card because your data will already be grouped by that field. Also, note that your denominator will always be 1 in this case based on your current formula. If that's not what you want, then you can remove the word DISTINCT from your formula to calculate the percentage based off the total number of rows.

MichelleH

1

Re: Calculate the number of Business Days in the current calendar year

@BonnieAnn If you are using MagicETL, there is actually a function in the Formula Tile that does this for you called DATE_WORKING_DIFF(). I'd suggest giving that a try to see if it works for you.

MichelleH

2

Re: Help with a nested Bar chart

If Invoices Keyed is actually your overall total, you could filter out that type by adding that field to your filter properties and choose Not In and then selected Invoices Keyed.

MarkSnodgrass

1

Re: Grant Smith - PraxisMetrics

Hi Grant, thank you for being such a knowledgable expert, and for always taking the time to respond back to my random questions. This community is truly lucky to have you and your amazing mind as a presence on these forums!

JasonAltenburg

1

Re: can you share a filter view if you don't co-own the page?

Correct, this is because the page is locked to prevent editing from anyone except for admins and the page owner (the lock symbol next to your Keyword Performance title).

GrantSmith

1

Re: Formula in Magic ETL

Hi @Manasi_Panov in order to compare values from different rows, you will need to first use LEAD function in a Rank & Window ETL tile ( https://domo-support.domo.com/s/article/360044876094?language=en_US ) to identify the values of Work Type and Order on the row above. Then you can use a CASE Statement in a Forumla tile like this:

case 
  when Order = Next Order and WG Combi is NULL then Work Type
  else WG Combi
end

MichelleH

1

Re: Dynamic Columns Brick - Aggregation Question

Hi, I'm new to DDX (started learning this morning) but it seems you can indicate the aggregation you want to use as part of the query. Here they talk about it in detail https://developer.domo.com/portal/ec60c4980e1b5-getting-started-using-domo-bricks#get-the-data . But basically if you're using the Query notation, after adding your fields and group by, you can add each agregtion followed by the name of the field,like I've highlighted in bold below.

const query = `/data/v1/sales?fields=${select.join()}
  &filter=${where.join()}
  &groupby=${groupby.join()}
  &sum=amount
  &calendar=fiscal
`;

Hope this helps.

marcel_luthi

1

Re: Case Statement with Count Distinct

Yes, you'd need to utilize a group by function. You can either use a function in the group by or use a formula tile to put your CASE statement in and then do a distinct count with a group by tile.

GrantSmith

1

Re: Case Statement with Count Distinct

Are you keying your admitted based off of STATUS or and ADMITDATE field?

What issues are you running into with your beast mode?

It looks like you're missing the trailing ) in your beast mode after the END.

GrantSmith

1