user046467 Member

https://community-forums.domo.com/main/discussion/comment/98143#Comment_98143 I'm using the Google Sheets Service connector, sadly that one doesn't seem to show a field with 'force to string'. Can't used the other one as it's bugged, Domo is aware of this.

Yes it surely is as I get the datepicker when I click on it in Sheets. Domo also sees it as a datefield too

@Speakman0418 I've had contacted support a month ago and their reply was the following: Currently there is an issue going on with the DOMO connection with Google sheets connector, therefore this error message is popping up. You can use the Google Sheets Service Connector for your work. Here is the help article for that…

Ahh I see, thanks that works!

@EvilGenius Domo isn't in the list so I can't assign access to it. How can I add Domo to the accessed apps list?

@david_cunningham Workspace company account. I haven't run into it either as I connected 2 accounts succesfully before. We also haven't changed anything related to privacy or security settings. It might be a new issue as I saw another user here with a similar issue :…

I was referring to this, I used the same beastmode as you said. I tried it again after your post but sadly same result where everything just becomes a new row.

https://community-forums.domo.com/main/discussion/comment/95043#Comment_95043 Thanks for your anwser. Yes I tried that as stated in my opening post. But then I receive multiple rows as you can see in the second screenshot

https://community-forums.domo.com/main/discussion/comment/89674#Comment_89674 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)

https://community-forums.domo.com/main/discussion/comment/67191#Comment_67191 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 -…

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

https://community-forums.domo.com/main/discussion/comment/64846#Comment_64846 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…

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 ?