I've built a YoY variance chart for sell-out sales but problem is I'm using CURDATE for the most recent week and it's showing -100% until I upload the most recent sales data. I've proposed the below but it's coming up with an error message. Any help is appreciated! (CASE when (`Sales Week` like '%2018%' then…
I can call /data/v1/alias and this wil give me the metadata for the dataset as well as all the rows. If the dataset is big, this can take some time and sometime never return. So how can I just return the number of rows in a dataset. The column name is not always the same, for the dataset can be changed out. Is there a…
When drilling down to the next level in a card, it appears the filters are being removed. For example, I have a card that shows comparative periods, YTD. When I click on 2018, I have a table card that shows information YTD for 2018 (no additional information exists). However, when I click on 2017, I get full year 2017. The…
Hello, I have a DataSet that returns a column with a month as a string in format "YYYYMM" for example, April 2018 would be "201804" How do i convert this column to a valid Date column in Magic ETL???
Hello, I have a dataset I replace every month. This one dataset is curently connected to many dataflows. So I have to update each workflow every month with the new dataset. Can I bulk change a dataset in many workflows at one time?
We are wanting to show the MtD line rate everyday of the month cumulatively growing like in the example that would be in excel.
Hello, I have a dataset that has had some values and fields change and I need a way to see a list of all the cards that are linked to that dataset so I can go in and make adjustments to those cards. I know I can go to the dataset and see a visual representation of the cards that are linked but I"m hoping there is a way to…
So I'm building a connector using the developer IDE, but I just can't seem to get the authentication script working with the 'httprequest' library (I believe it's domo built-in?) The connector will serve to pull data from my API and the API uses Oauth2.0. However, I'm having trouble getting a token through domo, but I can…
Hi I'm trying to recreate a simple graph that I have in Tableau in order understand the capabilities of Domo. It's a bar/line graph combo. The line graph is just a plot of the input data but then the bar graph plots the increase from the previous month. In Tableau this can be created in 5 seconds with a quick table…
They have some APIs but I cannot get them to work with Domo... I am hoping someone else has already invented the wheel. https://www.statcan.gc.ca/eng/developers
It looks like you're new here. Sign in or register to get started.