-
How to grant permission for a user to access an ETL dataflow?
I have a privledged user that has access to the dataset however he can't seem to access the actual ETL dataflow. How would I go around doing that? Thanks
-
How can I group multiple columns by year-month in the dataflow?
So I have a dataset that looks kind of like this: Date. A B March 2, 2020 2 10 March 14, 2020 4 20 Feb 12, 2020 3 8 Feb 21, 2020 1 4 Jan 3, 2020 6 10 Jan 17, 2020 3 5 I'd like group the rows by year-month essentially stripping the day from the date column while simaltaneously summing the combined rows within that month.…
-
Can't pull in JSON from S3 connector
I'm trying to pull in a few json files from the S3 connector and one of the files throws up this error: Failed parsing JSON source: JsonReader at line 1 column 24976613 to Json The other two json files ran successfully and are very similar to the one that isn't pulling. I'm unsure on how to troubleshoot this.
-
Post Domo Alerts onto Slack channel through webhook
So I'm trying to post an alert from domo onto a channel in slack. I made the slack app and pasted the webhook url provided into domo's webhook portion within the alert settings. I run a test and it says it sends the payload successfully however in my slack channel, nothing got posted.
-
Is it possible to import Python packages outside of what's given in the ETL?
I'm trying to import the lifetimes package but I guess it's not included in the default python packages. Is there a way to import that or am I out of luck on this one?
-
Python Node giving throwing up an error I don't understand
When I try to run my python script, it throws this error: Traceback (most recent call last): File "<stdin>", line 7, in <module> File "/home/domo/domomagic/io.py", line 17, in read_dataframe return pd.DataFrame(read_array_dict(input_name)) File "/home/domo/domomagic/io.py", line 26, in read_array_dict…
-
Date not going past current date
I'm trying to make a card that shows what 25% growth looks like within the next year. It should increment by month. For some reason, when I input the points into the analyzer, it stops at the current month. It should work because the Date column goes up to the year 2030 and the other columns that I need to fulfill the…
-
How do I create a column containing the max number from a ranked column?
I'm creating an ETL and need to create a column that lists the highest value from another column that lists ranking. If it helps, the ranking is based on date created on. Something that looks like this:
-
Trying to use the forecast value in chart properties but getting the error
I'm trying to get a forecast of quantity of sales for the current month using the last value projection in the chart properties. When I select the Forecast Value option, I get this error: An issue has occurred during processing. We are unable to complete the request at this time. Why am I getting this and how do I get…
-
Not sure what this AWS Lambda error I'm getting from trying to extract domo datasets
What does this error from AWS Lambda mean? [ "{\"status\":404,\"statusReason\":\"Not Found\",\"toe\":\"FJACDOT2HE-250JI-8N0AH\"}" ]
-
How to properly create future date timeline
Hey Everyone, So I'm trying to create a visualization of future values based on a selected month. The start month is Feb 2019 and the timeline will go to Feb 2020. My date column from the dataset doesn't go past the current date so I created a calculated field to get the next 365 days: DATE_ADD(`Date`, 365) Then, just to…
-
Is it possible to set this kind of alert?
I want to create an alert that goes off when a campaign goes above a certain value from last 90 days. Will I have to create a beast mode calculation? edit: Nevermind, I found the answer.
-
How to refine future projections?
So I have this card that is supposed to provide projections of wins from opportunities for the next couple of months. This was essentially calculated by creating a beast mode calculation called 'Win Probabiliy' that took the count total of all wins divided by the count total of all opportunities. This gave me some decimal…
-
How can I create a custom moving date range
I need to create a custom date range that moves with the current day. It needs to show the date range of the previous 10 days and the next 5 days based on current day. I can't seem to wrap my head around how to get started on it and if it can even be done in beast mode.