user046467 Member

Thanks, never knew Domo had this one. That works for me :)

Hi Colemen, Attached you will find what I'm trying to accomplish. Product 1-3 is one column, I can accomplish the above screenshot when splitting up the products through a beastmode and selecting 'transpose' in general table settings but that is quite time consuming (as I have more products)

3 columns: (could even be two as I just use E-mail as a count column) Cancellation date - Emailadress - Reason of cancellation 1 may - email1 - Too expensive 10 may - email2 - Too expensive 15 may - email3 - Missing features 20 may - email4 - Lacking skills 1 june - email5 - Missing features 2 june - email6 - Too expensive…

@GrantSmith Is this possible in the case I described above? :)

Thanks for your reply @GrantSmith Sadly that doesn't seem to work. Probably because my explination of the case was lacking. I've a list of cancellation reasons ('opzegreden'). reason 1 : 15 people reason 2 : 10 people reason 3 : 7 people reason 4 : 3 people reason 5: 2 people But I want to group the reasons that have less…

Hi @GrantSmith Thanks for your advice. I managed to get it working in the end. Simply using a single day didn't work. I had to use a date after the start date mentioned in the error. So running a single date in 2022 made it possible to use a daterange again :)

@GrantSmith I just want the total number of these customers. If they buy it twice it can count as 2 but the changes of this happening are very low so you don't have to take that in account.

Thanks for your quick reply. I just want to have the number of occurrences where a customer bought both Product 1 and Product 2. Which is 1 in the above example for all customers/e-mails. I checked count distinct but that isn't probably what I am looking for.

Okay I created a dummy data set and it is giving me the same problems. If I add the following beastmode as a column: lag(sum(`Quantity`)) over( order by month (`Date`)) the problem persists. Attached you can see my data and my data preview. If I set "graph by" to "month" it doesn't make a difference. If I remove "LAG" it…

No I don't I added month(`Date`) and count(`ID`) as columns, that does group them by month. But when I add the lead beastmode lag(count(`ID`)) over( order by month (`Date`)) it gives me the same problem. I can't figure it out as everything seem in order according to your video. I might create a dummy dataset tomorrow to…

@MarkSnodgrass usually that works but now I already added "count" in my beastmode so I can't sum it. If I add it in beastmode it just crashes. @jaeW_at_Onyx thanks that makes sense. Too bad it still doesn't work. I think it has something to do with my date field. I removed all other columns and only added the "month"…

Excellent Mark, that worked like a charm :)

@ST_-Superman-_ thanks for your detailed response! How do I open the url you provided? When I try to login it says wrong credentials. Which make sense considering it isn't my domo url.

@ST_-Superman-_ thanks I got that working. Only sidenote I've here is that if someone buys multiple things the average is still off. For example: 4 sales | 61 days difference 1 sale | 1 day difference Gives an average of 37 days which should be 30 days. When they just have one order everything is fine. Did I miss a step in…

@jaeW_at_Onyx thanks for your reply. I thought this was the answer but as I tried it after getting the beta feature I don't seem to get it working. That might be due to an misunderstanding due to my opening post. I have one data file with a lot of data. I use quite a lot of columns to calculate the CLV within a beastmode.…

Thanks for the superfast response and solution! I most likely tried that scenario but made a mistake with the " else 0 end" How should I read these? I find it hard to know when to use the else 0 end statements. If there is any good documentation (or your explanation) please let me know.

Excellent, thanks a bunch, that worked! I am always getting a generic error like: Invalid Formula : This calculation contained a syntax error. Sorry to bother again but I tried to extend the formula a little. See screenshot. I've multiple scenario's that's why I inserted OR , which gives me the error above. If I change it…

Datestart is not the actual startdate of the campaign. I use startdate aswell and I get daily reports from my campaigns even if they started a while ago. See below which settings I use for the dateset itself. That might be the solution here aswell. Not sure if this is perfect but it works for me and might work for you too ?

Thank you for your solution, that should work!

Thanks for your replies. I've to go for a recursive flow then. As Google Sheets connector in Domo doesn't support append for whatever reason. Would've been much easier indeed.

Thanks you both for your response. I ended up restructuring my data and making the calculation much simpler. By using join and adding a constant to the conversions tab. That seems to work ?

Sorry for the bump but is there any news regarding this? There should be some kind of "visitor license" which gives the rights to view the dashboards but not alter them. As it seems quite costly to just buy a license for viewing purposes. Hopefully someone has an update ?

Thanks for your reply and oops I missed an important part in my opening post. It does actually show the percentage. It doesn't show the value name. Product 1 is too long but Prod 1 fits. But as I can understand from your post there isn't an (easy) way to force this anyway? I do have the legend on the left side so it does…

Thank you for your reply @MichelleH I think you might have misunderstood me (or I did). I attached an image of what I am trying to accomplish. So although I have 48 sales compared to 54 last month my target is 45. But with the normal gauge I cant compare to last month. And with the period over period gauge I cant set a…

Excellent @GrantSmith sometimes it can be so simple but for a newcomer like me it's a lot harder haha. I understand how it works now and got it working. The only thing I don't understand is the first line: CASE WHEN SUM(CASE WHEN `page` LIKE '%/page1/%' THEN `Unique Pageviews` ELSE 0 END) I left it out and it gave me the…

Thanks both for your replies. @jaeW_at_Onyx "unique visitors" is just a metric from Google Analytics. So you can also call it just "visitors". I tried both calculations but it's missing something as it counts the cases but I need to sum the values from "unique visitors". I've attached a filed of the data I am receiving…

Thanks for your reply @jaeW_at_Onyx That option is not showing for "Google Sheets" sadly.

Thanks @GrantSmith ! I am new to SQL so figuring everything out by trial and error. But this makes perfect sense so I will try this soon 

@jaeW_at_Onyx Thanks for your response. From what I can see all the data is coming in so that's working fine. But with the (simple) Facebook Ads connector I can just select "Date" and select a timeframe I want within the date selector card. Facebook Advanced Ads doesn't offer "date" I only have "batch_last_run",…

Thanks @jaeW_at_Onyx I got it working! Another question (or should I open a new topic?) which I am struggling with is getting the date selector to work with the FB Ads advanced connection. Every date dimension doesn't seem to be working. I get the calendar but I just don't get data for the specific period (it says there is…