-
Best way to have months show as individual columns in a table
What I am wanting to do is list the months this year Jan, Feb, March, etc.. in a table. I assumed that the date filter for a table would allow me to graph 'This year, by month' in the same way it would for a bar/line chart but that doesn't seem to be the case. Is there an easy way to do this with tools in the analyzer or…
-
Right way to utilize string operation on long date.
I have a long date that I have converted to a text. Now I want to use the string operations tile to cut off the tail so I can have a nice clean date. the way it looks now in a string format is: 2022-02-24T12:08:34 What I want is: 2022-02-24 What I have been trying is: But it leaving the date unchanged and that timestamp at…
-
Right way to utilize string operation on long date.
I have a long date that I have converted to a text. Now I want to use the string operations tile to cut off the tail so I can have a nice clean date. the way it looks now in a string format is: 2022-02-24T12:08:34 What I want is: 2022-02-24 What I have been trying is: But it leaving the date unchanged and that timestamp at…
-
Question about IP address whitelist
Just curious, but could Domo be using a different IP address than what is whitelisted for a database I am trying to connect to via the SQL server connector in Domo? Giving a test run today trying to connect I had my public IP address whitelisted for access with no success. It gave the same error, but now I'm scratching my…
-
Beast Mode to add two values from the same column
I have a column that is showing different periods. the column breaks them out in 0-10,11-30, 31-60. Then there is a column called 'values' with the correlating value for those periods. What I am wanting to do is just add together the 0-10 and 11-30 periods together using a beast mode.
-
Best option for YOY comparison showing where we are now to that same period last year?
I am trying to show a comparison for total revenue for where we are now compared to where we were end of February 2021. toying around with different graph options isn't allowing me to slice and dice the way I want. It either is a line graph YOY by month or a progress bar that is using all of Last year and comparing it to…
-
How to remove a decimal in an area dimension column?
I have a column that showing the dimensions of a unit. 5x5, 5x10, etc.. the column is in a text format and the data is coming in to Domo in a strange way, it looks like: What I want is just the more standard: 5x5, 5x10, 5x15, etc.. In the ETL how could i get rid of the .0?
-
Right string operation to remove the timestamp
I have a long date that I have converted to a text. Now I want to use the string operations tile to cut off the tail so I can have a nice clean date. the way it looks now in a string format is: 2022-02-24T12:08:34 What I want is: 2022-02-24 What I have been trying is: But it leaving the date unchanged and that timestamp at…
-
Adjusting a decimal to be used as a summary number
I have a column that calculates a %. in the dataset it reflects like 94.965, 97.245, etc. which works great in any card. Now that I am trying to use it as a summary number I am running in to this issue: I can't seem to be able to get it to reflect 94.39%. it just shows this big ugly number. This field is a calculated using…
-
Beast mode that would put people in a specific group based upon a date
I have a dataset that shows tenants that are late on their payments. Some our in Auction status, and it has an auction date. What I am trying to do is put these people that are in Auction status in to 3 groups. Those that are 30, 60 , and 90 days past that auction date. Then Ideally, would be to use this in a pivot table…
-
60 days since last pmt beastmode
I have a payment column called LastPmtDate, it exactly what it sounds like. What I am wanting to do is write a beastmode to be used as a filter to filter on only those that our 60 days or greater from that payment date.
-
Beastmode adding multiple different values from the same column
I have a marketing channel column. That has a dozen descriptions from all of our different marketing channels. I am only trying to take the count of a few of them together i.e. Yelp, Facebook, google ads, etc... How could I write a beastmode that I can pull out only the channels that I want to add together?
-
Deleting a batch
I have 2 batches in a dataset that need to be deleted. The batches are easy to identify and the 2 just need to be wiped out entirely. I am wondering if it is possible to just go in a delete a batch, and what would be the best way to do this?
-
Formula failing to convert value from a type string to a type date
I think I need some help with the order of operations on this. I have recursive dataflow for Yelp data. I am trying to create a 'metric date' column by 1st, Splitting the ' FILE_NAME' column date example 'security_public_storage_account_time_range_report_11_1_2021_to_11_30_2021.xls Then in the next Tile I am using the Add…
-
Help on recursive dataflow
I have a recursive dataflow that keeps getting hung up from an issue on the join between the recursiveprod and the main data that is being groupby. The error it is showing is DUPLICATE COLUMN NAMES. So I go and change the column name and i am able to get it to run. it then takes that new unique column name and adds back in…
-
How to reactivate a dataflow disabled from inactivity?
I have a fairly comprehensive dataflow. Most of the datasets that are a part of this dataflow update nightly, but there are some others that only get updated monthly due to limitations in how we get the data then how it gets in to Domo. We use the email connector and when we receive the statement once a month email it via…
-
Need help getting pointed in the right direction for what might be causing inflating counts
I have a table that has details of inventory at each site that illustrates KPI's like Occupancy, vacancy, days vacant, and occupied units. It is put together using 3 different data sources. Price list - This is a majority of it. it is all the units aggregated row by row with those occupied, vacant, and total unit details.…
-
The correct regex to remove the first character?
I have a column( that illustrates a dollar amount but is in string format. What I am trying to do is to remove the dollar sign ($) that is the very first character in each row, so i am only left with the numbers. I have tried the left/right substring but each dollar amount is different length so I have ran in to issues.
-
is there an easy way to not show zeroes??
I have a table that consists of inputs from 3 different sources. What I am running in to is more of an esthetics issue that I am hoping to clean up. I have areas where a zero appears, and other spots they don't appear. The data are all integers so i understand why there would be zeroes showing but confused why it shows up…
-
Recommendation for best way to create this visualization
I have 2 columns 'years old when moved in' and 'Length of stay in Days' What I am looking to do is create a card (histogram?) that will take the ages and put them in buckets then show an average length of stay in days for each of those buckets. I already used the histogram to show the distribution of ages as a count, and…
-
Reg. Expression to replace a list of names with a single character.
I have a column that is in a string format, and of course contains names. Majority of the rows are an empty string. What I am looking for is to take the rows that do contain a name and replace them with a 1. i have been trying to use replace text tile then trying to use a regular expression in the 2nd step, then replace…
-
Changing a value to an integer in the ETL
I have a column that uses an 'x' as a flag, any row that isn't flagged with an 'x' is left as an empty string. What I need is to replace the 'x' with a '1' to be used in a later count. this should be straightforward but I keep getting my wires crossed with the order of operations.
-
Weird/Random Question about the date filter.
I have a card that is a POP trendline and is comparing current year to the previous 2 years aggregating by month You can see that in the current month (September) there is a drop off from August because it is an incomplete month. Is there a way to show the card in this same view but just not display an incomplete current…
-
YOY & Net diff Beatmode calc
I have kind of a unique YOY period that I am trying to create a report around. I am taking counts of leads that come through different marketing 'Marketing Sources', and only looking at the past 15 day window for each. This is straight forward. Take the counts for each source in the `Marketing Source` columns and use the…
-
How to find the difference between 2 dates?
My dataset aggregate value totals on a monthly basis. Each row represents an individual site and value for numerous metrics. What I am trying to do would be how to find the change between 2 months like between Oct 1 , and Nov 1, as shown above for the values in the column to the right. But I am not sure how to write the…
-
Dataflow creation best practice and recommendation
A lot of the dataflow creation I do is taking 2 datasets that differ slightly and don't have an easy 1:1 comparison that makes joining the data very easy. usually I am using 1 report for almost the entire visualization, and puling a column or two form the 2nd report. Since the reports aren't in an identical format, and…
-
How to split values from one column in to 2 columns?
I have a column that contains values that are 4 digits. I want to divide them up in to 2 separate columns. The first 2 number are the % of the discount, and the last 2 are the length Ideally it would be the % and contain 30, 40, 35, 40 ,etc... Then Length would have the last for digits like 02, 02, 03, 02, 04, etc.. I am…
-
How to delete portion of text in a column in the ETL?
I have a date column that is in this format: The format of the date is fine, but what I am trying to do is get rid of everything including the 'T' and to the right, so that all that is left would be 2021-06-27. If a solution within the ETL is possible that would be great.
-
Beastmode suggestion for a filter
I have a report that provides details on individual units it has a column that lets you know if that unit is rental or unrentable. it uses binary to illustrate this: bRentable 0 = “Unrentable” or “Offline” 1 = Rentable How can I write something in the analyzer that I can use as a filter that will replace 0 with Unrentable…
-
Odd sorting issue when filtering
I have a card that displays the average leads per day of the week. To sort the days of the week in a chronological order I used dayofweek(`date_entered`) beast mode calculation to get the days of the week detail. Unfiltered everything looks good gives the average for each day of the week, Sunday - Monday. Once you filter,…
