-
Want to track progression and targets based per Quarter
Hi all, I've one datafile with sales with different products. Quantity is a column where I used 'sum' Target is made through a beastmode 'case when QUARTER(date) like 1 then 1250 else 0 end' Progress v2 is also made through beastmode and doesn't deliver the right results 'QUARTER(date) like 1 then (1250- (quantity)) else 0…
-
Sort line chart based on datefdiff
I've a line card and a beastmode with a datediff. I want to run the line from 1 till 20 in this case. But I can't get it to work. It still displays in a random order whatever sorting option I pick. What am I doing wrong?
-
Show only the Data Table as card
I'm using a line bar chart and have the data table enabled. But is it possible to only use the data table in a card? When using the table chart type it displays it differently. Is there a way to make the chart look the same as the data table?
-
Is there an AI that analyses the data?
I've some data from Google ads like costs and CPA segmented by month. Is there a way that DOMO/AI tells me any trends or breaks in trends or any other things that are worth highlighting? Now I have to analyse the data myself but I'm sure AI could assist with this.
-
Group by when using case statements?
I'm trying to group the column 'opzegreden' into one line if the sum is below 5. I'm using the following beastmode which gives me not the desired result (see screenshot) case when sum(Aantal) <= 5 then 'Why' else Opzegreden end If I use the following beastmode then it does it work and does group.. case when Opzegreden like…
-
Enable 2FA for DOMO
Is it possible to add a second layer of security to my DOMO account? I tried to find an option to enable 2FA but couldn't find it. Thanks in advance
-
Datediff per month
Hi, How can I show the datediff per month instead of per day. I tried the following beastmode: DATEDIFF(`date1`,`date2`,MONTH()) Can someone point me out what I am missing? Thanks in advance
-
Beastmode | Exclude data based on dates
Hi all, I'm probably missing something small here but I'm using the following beastmode: (case when `Date` >2021-07-01 then (case when `company` like '%company1%' and `ConversionTypeName` like '%product1%' then 'exclude' else 'include' end) end) But when I use it as a filter it excludes everything and not only the sales…
-
Google Analytics | Domo received an error requesting the data
I keep receiving the same error. I changed the date selection multiple times. I put a relative range of 90 days back, -90 days back, a specific date and just the normal 90 days range but I keep receiving the same error. Does anyone know what is going on here?
-
Sum specific product sales from one e-mailadress
I've a data file which contains customer purchases. Something like: Product 1 - Email1 Product 2 - Email2 Product 3 - Email3 Product 1 - Email4 Product 2 - Email1 Product 3 - Email1 If the specific e-mailadress purchased both product 1 and product 2 (the bold lines above) the answer should be 1. It doesn't matter if he…
-
Difference between preview and data table
As you can see my data table groups by month which is want to achieve and my preview doesn't. I've no filters or any sorting. I am probably overlooking something simple but I tried following Onyx' his tutorial (https://www.youtube.com/watch?v=cnc6gMKZ9R8) about window functions but I can't seem to group by month. Should I…
-
Make dashboard bigger
Is there a way to make my dashboard bigger so there is more room for my cards? I am working on a 1440p 27" screen and have a lot of white space. Around 50% of my screen is unused by my cards. Hopefully someone can help me with this as a lot of companies are working on +1440p resolutions. Thanks in advance!
-
Only include the first instance and ignore others in beastmode
Hi all, I'm trying to calculate between signup and the first sale: DATEDIFF(`sale_date`,`signup_date`) Which works fine. Only problem is, is when a person makes multiple sales it does counts towards the average. Is there a way to ignore any other instance and pick only the earliest date? Thanks in advance
-
Compare month to month | Table
Hi all, I am trying to get a table to show the difference between this month and the month prior: January | 100 | February | 50 | -50% April | 200 | +400% But how? This should be possible via beastmode but I can't figure it out. I tried the month over month charts but they also don't show what I want so I want to try it…
-
Reference data
I have multiple datasets and cards. In one dataset I have a beastmode where I calculate the Customer Lifetime Value. In another dataset I use the CLV but not as a reference as I don't have the data in this new dataset. I write the CLV hardcoded. Problem is that if the CLV changes I have to update the CLV manually in other…
-
Week of the year seems odd
Hi all, I am showing my graph interval by week. But the weeknumbers seem odd. week 53 - 2020 = 30 december 2020 week 2 - 2021 = 3 january 2021 Is week 1 only 2(to 4) days? Can someone explain this? This seems like a mistake in Domo rather than in my data, right?
-
Datefield recognized as text
Is there a way to view the faulty date which is actually seen as text? Because I can't just check them all by hand. Thanks in advance
-
Receiving an error in my Beastmode | Multiple case statements
I am pretty sure it has something to do with having multiple case statements. I've the following code which gives me an syntax error: sum(CASE when `Date` >= (DATE_ADD(CURRENT_DATE(),interval -15 day)) and `Date` <= (DATE_ADD(CURRENT_DATE(),interval -1 day)) then (case when `ConversionTypeName` like '%Sale%' then…
-
Combine 2 datasets with join or append while preventing duplicates
I have 2 datasets: * 1 containing conversions per day per product * 1 containing the costs per day (in total) I am trying to get to this: CostsSalesRevenueROITotal 1993600501Product A2200 Product B 1400 Total 2203600580Product A2200 Product B 1400 But I end up getting this CostsSalesRevenueROITotal 11983600402Product…
-
Insert card while maintaining ratios
Maybe I am doing something wrong but when I already have a couple of cards and I insert an extra between them it takes up the existing space. Resulting in cards getting smaller. Only solution is to enlarge the cards from the bottom up so I can space it out. Which takes a lot of work and doesn't seem to be the right…
-
Add current date to new row
My input file is from Google sheets containing sales. But they don't have a datestamp. I tried adding it with a constant in an ETL but the next day it overwrites all dates again with the current date. Is there a way to prevent this? There should be an easy solution but I can't see it. Anyone who can help me?
-
Beastmode across seperate rows, is it possible?
Not sure if this is going to work at all or that I made a mistake. I've added 2 screenshots. One with the actual beastmode script and a screenshot from the table. Is it possible to exectue this script? I get a valid response but it doesn't return any values. Most likely because it's a script across multiple rows. Hopefully…
-
[Beastmode] Like binary - to find uppercase text
When I use the following (example) query it's working fine: (case when `Product` like '%PROduct1%' then 'Productone' else 'Ignore' end) Except that product1 also turns up in my results and I only want PROduct1 which uses uppercase letters. In mysql you can use "like binary" but when I change it to: (case when `Product`…
-
Show labels on pie chart even if it's too small
I am using a pie chart. I have 2 slices. One is 90% and the other one 10%. But the 10% one is too small to show the label. Is there a way to force this? As I don't mind it overlapping the 90% chart as there is enough room to show the label there.
-
Use Gauge : Target + comparison
Hi all, I am using the Gauge to show my sales results. But I want to show both a target point and compare it to last month. Normally the line from previous month is the targetpoint but I want to adjust this. Is this in any way possible? I also looked at the Comparative Fill Gauge but doesn't seem like the way to go. Thanks…
-
Beastmode: Filter pages and divide them
Hi all, I am trying to calculate the conversion rate of my pages in beastmode. All data is from Google Analytics. Simply said: 100 visits contain /page1/ 20 visits contain /page2/ = 20% conversion rate if page url contains /page1/ then grab the unique visitor count and divide it by the unique visitor count from /page2/ I…
-
Google Ads + Google Sheets overwrites the old data
I have connected my Google Ads + Google Sheets (https://knowledge.domo.com/Connect/Connecting_to_Data_Using_Other_Methods/Connecting_to_Google_AdWords_Data_Using_Google_Sheets). It daily adds the new data from my campaigns which works fine. The problem is that it overwrites all older data instead of adding new rows. Did I…
-
ETL Addition empty fields
I am using addition to calculate 2 columns into a calculated column "Total 3". Example: Total 1 | Total 2 | Total 3 1 | 2 | 3 2 | 2 | 4 1 | | 4 | 1 | 5 Problem is I don't have data in every row. So as you can see the third one here results nothing instead of 1. 1 + "blank" is still 1. But it returns an empty field. Any…
-
Automatically add new Facebook ads campaigns to dataset and filters within cards
Hi, Is there a way to automatically add new Facebook campaigns to my datasets? I saw a topic from 2019 stating it isn't possible but maybe there is a workaround by now. Situation: I run ads for multiple products, which have multiple campaigns. I want to see the total amount of clicks/spend/etc. For example: I have campaign…