Syntax Question

[Adam_Harper]

Hello, I’m needing syntax help for a formula. I have 3 columns, a column with employee names, a column with transaction ID#s and a column with totals for each transaction. Is there a formula that could tell me, for each employee what number of transactions in excess of $100 were processed in the given time frame? I already have the date range set.

I’ve tried count(if({$employee_name}=“insert name here” AND {$transaction total}<100))
and sum(if with similar arguments but am getting syntax errors. I am sure it is either something simple that I am overlooking or the functionality isn’t there yet. Any help would be greatly appreciated.

[Cyril_MTL_Analy]

Hello and welcome @Adam_Harper!

You won’t be able to do that using the transactions_total measure.
What I would suggest:

From a new Explore (remember, dimensions are blue, measures are orange):

• Add the Employee Name dimension to the data panel
• Add the Transaction Amount dimension (not the measure) as a filter
• Filter the above dimension on “is greater than or equal to 100”
• Add the Transactions Count measure
• Add any other relevant filters

I assumed the names but essentially it should look like that:

[Adam_Harper]

Thank you! This was just what I needed.

[cachilihu]

Hello,

I am trying to create this in SQL, can anyone assist?

• Using the sq.transactionfull table as input, select and group the report by CustomerID.
Create the following columns:
• TotalTransactions using the COUNT(*) function to count the number of transactions for each value of CustomerID.
• SuspiciousTransactions as SUM(Amount >= 500) to count the number of transactions greater than 500.
• PCTSuspicious by dividing SuspiciousTransactions by TotalTransactions. Format the new column with PERCENT8.2.
• Select only transactions where the Service value is not equal to University.
• Filter the output to display only summary rows where PCTSuspicious > .05.
• Order the report by descending PCTSuspicious.
• Add the title Customers with High Percentage of Suspicious Transactions.
• Run the program and review the results.