meadow_ryan Member

so I have it as the attached where I first set my column type for bank_id to text which was decimal then run the string operation LPAD contains bank_id padded to length: 10 from side: left, then did the replace text LPAD with a space in the term to search for and replace with 0, but still isn't adding the leading…

So I've done the first part but where do I add the second string operation....see attachment

I can add it to the sql data flow but how do I write it to select all columns but do lpad() on bank_id field? thanks

In here? What is LPAD()

problem I'm seeing now is that its not just ones with 8 digits, any of the bank_id field which as a leading zero is getting removed.

so the column was a decimal and I changed to text by using the set column type to text but it still isn't showing the leading zeroes

that worked, thank you

thanks that worked

just a table card....attached is what is showing when I have CASE when `Link Agency ID` LIKE 'BKR' then '' else `Link Agency ID` END

that didn't work either

that didn't seem to work, so what I'm looking for is if link agency id = BKR then show a blank value, else show whatever link agency id is thanks

I have it set to include all columns, have included a screenshot of the way I have it built...the filter rows each are for a specific equipment type, so equipment_type_id = 'D' is drivers, equipment_type_id = 'T' is trailers, equipment_type_id = 'L' is tractors

that worked...thanks again

so I wrote as below, added an ending parenthesis as it was giving a syntax error if not, but when adding to the card is stating "An Issue occurred during processing, we are unable to complete the request at this time" CASE WHEN `override_payee_id` = 'MEADBIMT' THEN AVG(.15) ELSE (SUM( `total_charge` - `override_pay_amt` -…

that didn't seem to change anything...I understand what you're saying about breaking apart the case statement but its like its still taking into account the case with the division even when the 'override_payee_id' = 'MEADBIMT'

ok, so its pulling in data but just not all teh service failures for each user as its only brining in 5 for my summary number is there anyway for me to share my card with you as what I'm trying to show is we have a table called orders and each order there is a place where an sfuser1(user) and orderservicefailure1(service…

can you not make your summary number on your card the count of one of the case statements? As I believe I would want the summary to be the count of what is below, as along with the 3 different sfuser's they can record 3 different service failure types CASE when `ORDER SERVICE FAILURE` IN…

so would this be then what I put on the category instead of just sfuser1, to have when the user is in sfuser1 or sfuser2, or sfuser3 use case when sfuser1 is not null then 'sfuser1' when sfuser2 is not null then 'sfuser2' when sfuser3 is not null then 'sfuser3' end

so I got the formula to calculate , but when adding to the filter its not asking to filter off of 1 or 0 just to put in a value greater than, less than, etc. Also, I'm doing a grouped bar and for the category on the x axis I would like to show if the users are in sfuser 1 or sfuser2, or sfuser3, is there a way to do this?

so I wrote it like the following and its not accepting it? CASE (when `sfuser1` is not null or `sfuser2` is not null or `sfuser3` is not null then 1 else 0) END

I got it...just as you suggested...thanks

so I have it written as: case WHEN `ORDER SERVICE FAILURE` IN ('CCN', 'DE', 'FN', 'IN', 'IT', 'NC', 'R', 'RCN', 'SN') OR `ORDER SERVICE FAILURE 2` IN ('CCN', 'DE', 'FN', 'IN', 'IT', 'NC', 'R', 'RCN', 'SN') OR `ORDER SERVICE FAILURE 3` IN ('CCN', 'DE', 'FN', 'IN', 'IT', 'NC', 'R', 'RCN', 'SN') THEN 1 ELSE 0 END But when I…

So each the fields that I'm filtering on are called servicefailure1, servicefailure2, and servicefailure3....each have different codes within them as choices, how would I write this? ex. servicefailure1 when I add as a filter has codes, CCN, IF, CN, AF, etc.

the Loaded/Empty and Miles are not in the same table as the Order Number is Order Number is from Orders table Loaded/Empty and Miles are from Movement table they are joined by the order from movement_order innner join with order from orders

ideally only on the rows with loaded/empty = 'L'

image is attached....thanks

https://meadowlarkco.domo.com/page/1446302714/kpis/details/2099641706 Trying to sum 1032 + 40

ultimately we want to find the retention ( number of employees left / number hired) and then list the number of employees for each plus be able to change that each month for the hired and termination date

so I've buildt the card but nothing is showing up? Also for the summary date what do I put in for the date range field? https://meadowlarkco.domo.com/page/1446302714/analyzer?cardid=2028803795 I'm not sure if you can see from my link

by display the percentage as a summary number meaning the rentention percentage....Is there a way to allow the dates to roll so we manually don't have to change the dates each month?