Domo is a hosted business intelligence platform which creates reports using data from disparate data sources.
Questions tagged [domo]
76 questions
0
votes
1 answer
Beast Mode to Convert text to date
I am trying to convert a string to date...
STR_TO_DATE(`MFGDTE`,'%Y-%m-%d')
But I am getting the value as 2019-12-18t00:00-06:00. Can you please let me know how to get just the date 2019-12-18.
user3369545
- 310
- 2
- 14
0
votes
1 answer
Getting dates in one row
I am working on the data visualizer and have the data as below
order
Model
ord date
rec date
cur prm
prm date -7D
prm date -14 D
prm date -28…
user3369545
- 310
- 2
- 14
0
votes
1 answer
Beast mode to extract the date based on a pattern
I am trying to extract the date from a field based on a pattern - If the first four characters of the field description are *SLD then I need to extract the date from the field description as output date else I need to take the date from the field…
user3369545
- 310
- 2
- 14
0
votes
1 answer
Export existing dashboard from DOMO into Power BI
Disclaimer: not a developer, but an analyst looking for solutions
I currently have a DOMO dashboard ready, am looking to port/replicate it on Power BI for another set of users who have the rest of their dashboards on Power BI. Is there a way I can…
zyc
- 1
- 2
0
votes
1 answer
MySQL equation(WHERE clause)
I am trying to use create a graph using last months sales (plus 10% of last months production so multiplying the last months sales by 1.1). It seems it should be simple but I can't seem to figure it out, I have tried using a CASE statement
CASE
…
Nathan
- 11
- 4
0
votes
1 answer
Tracking time in each status per ticket? (Jira/MySQL)
So I currently am using Jira with Domo to create Dashboards for our team.
Currently I am wanting to display the time each ticket spends in each status per ticket.
For example I have a table like this.
|date |From | To …
Western56
- 41
- 4
0
votes
2 answers
Speed Up UPDATE Performance MySQL
I'm fairly new to SQL, so struggling with the guidance given elsewhere on this.
I have a table with 1.7M rows and 85 columns
The column 'Sample ID' gives an identifier for each entry
The data updates periodically and duplicate Sample IDs are…
JackMc12345
- 13
- 3
0
votes
3 answers
Period over period SQL script?
I have a dataset of 2 columns: 'Date' and 'Total Sales'. My dates are 01-01-2021, 02-01-2021... so on and so forth up until 12-01-2022. I basically want to add another row where I have a "previous month" column that gives me the total sales for the…
MrBiscuit
- 51
- 1
- 2
- 8
0
votes
1 answer
Can you nest a number of conditions in a partition by statement successfully?
I built this sample table in Fiddle: https://www.db-fiddle.com/f/pu1PkjzKCM9VRciznkJc4L/7
I am working on relabeling territories for account numbers and serial numbers. You can see the table schema and the query I have tried to change the data and…
Matthew McNey
- 23
- 6
0
votes
2 answers
Insert Multiple Rows from Table A to Table B on Multiple Different Dates MYSQL
I have Table A with a list of dates
DATE
Aug 20, 2021
Aug 21, 2021
Aug 22, 2021
And Table B with Variables
LOCATION
VARIABLE
A
100
B
200
How would I insert both the locations and variables for each date like…
chuckception
- 13
- 1
0
votes
0 answers
I need a case statement to get at prior month and prior year of prior month. Is it possible to use subdate(current_date())
CASE
WHEN SUBDATE(`invoice date`,DAYOFMONTH(`invoice date`)) = SUBDATE(CURRENT_DATE()),DAYOFMONTH(CURRENT_DATE())
THEN 'Prior Month'
WHEN SUBDATE(`invoice date`,DAYOFYEAR(`invoice date`)) =…
0
votes
1 answer
Select last full column in SQL
I'm new to SQL, so forgive me if this is silly.
I have a bunch of different rows, each a new match in a game. The columns are defined by minutes. So min_1, is the start of the first minute, min_2 is the start of the second and so on. Each row shows…
Minimuscle
- 117
- 1
- 1
- 8
0
votes
1 answer
Get the time difference in minutes between two timestamps (Mysql)
Hi I tried the following:
timediff(`date2`, `date1`) which gives me the time difference but if the days are different it does not account for the day difference. so if date2 is yesterday and date1 is today it will provide something like this:…
Aww
- 53
- 5
0
votes
2 answers
calculating variance with mysql week over week
I need to display week over week difference with mysql in Week Over Week Users column. My data looks like the following:
Date Users Week Over Week Users
06-01-2019 10 10
06-08-2019 15 15
06-15-2019 …
Chique_Code
- 1,422
- 3
- 23
- 49
0
votes
3 answers
CASE WHEN "__" LIKE "__" ELSE "__" MySQL Error
I am trying to standardize campaign naming conventions in a dataset via MySQL. Please see the code below;
SELECT
`Campaign`
FROM
`cost_per_platform`
case when `Campaign` like '%brand%' then 'Brand'
else 'Other' end
This is run via DOMO.com MySQL…
Nick
- 3
- 2