-
case when field is blank write something else display value
Have a field settlementID, I'm wanting to display when there isn't a value for that row to show pending else show the settlement id something like when settlementID is blank then 'Pending' else settlementID thank you
-
showing record with max date
Hello I have a dataset which pulls record numbers(gn_id) and its pulling some duplicates and it looks like if it that gn_id has a duplicate I want to pull the one with the most recent or max date but am unsure on how to accomplish this, I have attached a screenshot of what I'm looking at as on this example would want to…
-
filter rows
I am trying to run a filter rows operation on one of my datasets for when field gn_id = '2013159', but when I do this nothing comes up....I'm getting duplicate Id's and thought if I could narrow down to that order I could find my duplicate problem, but when I add my filter nothing comes up....all I have is gn_id = 'a…
-
date range question
I have a field called 'hire date formatted' as such: DATE_FORMAT(CONVERT_TZ(`hireDate`, 'America/Denver', 'UTC'),'%m/%d/%y') I have to do this as 'hiredate' has the wrong time zone for its records, but I cannot choose 'hire date formatted' as one of the selections even though its marked share calculation on dataset Any…
-
add leading zero
Is it possible to add a leading zero to a field if it has a specific number of digits....problem I'm having is I have a field "routing number" which for the records that have 9 digits it displays all the numbers but the ones which have 8 digits it removes the leading zero. thanks
-
count states in rows
Have a series of rows of orders for different states ex. order state 1 CA 2 CO 3 CA 4 MT i.e. the count for CA would be 2 and CO, and MT would be one, assuming would need to do sometime of grouping? But how do I display the count total on the card? thanks
-
displaying a zero value on a bar chart
If I have a bar chart where I'm graphing the volume of something monthly and one of the months doesn't have any data so the bar displays, Jan 2016, Feb 2016, Mar 2016, Apr 2016, then May is missing..... Can I zero value be shown in any way? thanks for any help provided
-
cumulative sum
Is it possible to have a cumulative sum for values in one column to show in another so that the final today would be in the last row? ex. in the attached screenshot If I wanted to have Total Revenue cumulatively sum and show each new value in a column next to it so the in the first row of 'Cumulative Sum' would be 19075…
-
sum column values
I have a column total revenue which is calculated for each customer on a separate row, but I'm wanting to total alll the total revnue values together for all customers then divide each indivudal revenue by the toal to get a % per customer, is this possible? thanks
-
question on calculation
for calculation trying to build "total bill" I need it to be column A + column B + column C, but there are times when column C is null, if I write it as column A + B + C only the rows with a value in C will fill in how would I do this calculation for both cases? thank you
-
subtracting a negative number
Could someone tell me how to write a beast mode if subtracting a negative number ex. have a freight charge of 199.68 and want to subract a negative 95.36, the calculation is coming out to be 295.04 instead of 104.32 thanks
-
Join twice on a different column
Hello I have 2 fields sh_state and cn_state which are displaying numbers for states where I'm wanting to display the state abbreviations. The field from the abbreviations table is 'id' so I'm needing to join sh_state with id and cn_state with id so it shows the abbrevition on the same row There are 2 tables, loads and…
-
running total line graph
With a running total line grap is it possible if I have a chart I have the number of employees hired as my y axis and the date hired(by month) as my x axis and for certain months there aren't any hires that there isn't a gap in the line and it can form a complete line ....see attached thanks
-
way to split column name into first and last
Hello, Is there a way to split a field if I have into 2? I have a field name, for example Bob Smith, can I split this into 2 so having 'Bob' and 'Smith' for first name and last name
-
append rows
Hello all, I have a question on an append rows which isn't working, I have a field, equipment_item which is used for three different things, a Driver, a Tractor, and a Trailer, I can filter out which of those I'm needing based on the equipment_type_id being either, D, T, L respectively, but after I do my append and then…
-
case when something then blank
How would I write a case if I have a field 'link agency id' to the following, if the the link agency ID = BKR display blank or empty cell else display whateve the link agency id is CASE when `Link Agency ID` = 'BKR' then '' else `Link Agency ID` END
-
combining multiple rows into one
I have a table called continuity with for a specific order can have a driver, tractor, and trailer tied to that order, I'm trying to bring the data in by filtering my rows whether the type is tractor, trailer, ord driver then appending the rows together again, but nothing is coming up...could someone please provide some…
-
help with margin formula
Im running the following formula to produce my margin %, and want when 'override_payee_id' = 'MEADBIMT' to have the % always be 15% but currently the way its written its taking .15/SUM(IFNULL(`total_charge`,0))*100 which isn't producing the correct amount, how can I write the following to have when the payee id is MEADBIMT…
-
mass change data set on series of cards
Is there an easy way to mass change the data set on a series of cards?
-
way to automatically share cards?
Is there a way to automatically share cards with an individual user when the card is made, rather than have to manually share the card with them? thanks
-
case when not blank
I'm trying to create a formula where 3 fields sfuser1, sfuser2, and sfuser3 are not equal to blank to include the users from those fields So we want to include the data if either sfuser1, sfuser2, or sfuser 3 contains a user name thanks
-
adding drill path view
When you're adding a drill path view, if I have 6 or 7 cards which am wanting to add the same drill path view for, is there a way to do this without having to recreate it for each card?
-
compare field with current date
I'm trying to compare a field birth_date which I have converted to just show the month and day as DATE_FORMAT(`birth_date`,'%m/%d') with the current date to only return the records where their birthdate = the current day I tried the following but didn't work if DATE_FORMAT(`birth_date`,'%m/%d') =…
-
filters question
When adding filters on a card is there a way to have it so that if it meets the criteria of any of the filters added not all? We have 3 fields which are needing to be added to a filter but it can have any of the data from each filter and not all? If that make sense? thanks
-
sum 2 fields in separate rows
Hello, I have a field 'miles' where for a loaded movement the miles is one value and for an unloaded movement the miles is another value. I need to sum these two together to get the total miles, but both rows of data need to show?
-
possible to have 2 date ranges?
I have a card I'm trying to build where there is a hire_date for an employee and a termination_date for an employee, where we are trying to determine the retention which would be the number of employees who left divided by the number hired. Problem I'm coming across is how to have two different dates on the card to 1)…
-
card title domo buzz
Is it possible to have the card name in the title of a public conversation in domo buzz?
-
bar card with threshhold line
I'm trying to create a bar chart displaying a line for the threshold for each category on the x axis, so I have 7 categories(x axis) each with a value(y axis) but want a line across the chart for the threshold each category is supposed to meet, which is a separate field in itself but cannot figure how to add this in by bar…
-
sum value from field from multiple rows
If I have a field 'amount' and am wanting to create sum the values from that field if there are multiple rows of the same order how cold I go about doing this. So for example I have an order number of 0703915 and there are multiple rows with that order number but one row has an amount of -2000 and the other row has an…
-
building pie chart with colors from formula
I'm trying to build a pie chart where I have a list of rows with different dates('transfer date') and am trying to for that date and the number of rows display a color of green, yellow, or red on the sections of the pie chart green being when 0-3 months after the transfer date yellow being 4-9 months after the transfer…