Hello, I'm trying to provide YTD % change vs. prev. year but I can't seem to pull a value from this. Any help is appreciated! (CASE WHEN TRIM(YEAR(`Date`))=YEAR(CURDATE()) then sum(`Online`) else 0 End) / (CASE WHEN TRIM(YEAR(`Date`))=Year(ADDDATE(CURDATE(), interval -1 year)) then sum(`Online`) else 0 End)
I would like some advice since I am struggling to build the following in a card. I have a dataset structured like this: I'd like to produce a chart like the following: * Bars: each value where Record_Type = "A" * Flat Median line of only Record_Type = "B" records I would restructure and precalculate median in a dataflow…
I'm looking for a couple of ways to create a card to provide up to date Stock price one way, i thought was to create a card and use HTML to pull the correct data? Any idea how this could be done?
I'm creating an ETL flow that aggregates data by month. Is there a way to roll up my date field to just the first day of that month? I can extract the Month and the Year separately, but I need a result field that combines them back into a single 'First Day of the Month' field. I.e. RegistrationDate = July 3 2018, First Day…
Someone made a change to the data I believe. Is there any way to get more detail from this error - like which column it is. I am having a hard time finding the column it is referring to Thanks
When trying to refresh a dataset that has not loaded in 24 days, I am getting an error stating: "Workbench DataSet Job (insertcompanynamehere.domo.com:6 (sqlSalesBI_uvwReportTwoYear) is not allowed to dynamically change schemas." How do I resolve this?
Hello! I'm new to Domo and spent some time digging around the Dojo to try to find the answer to this question but didn't have any luck... I hope what I'm asking for makes sense; I'm happy to provide details if it doesn't. Thank you in advance for your help! High-level I created a line and stacked bar chart where the series…
I was wondering if there was a way to automatically have beast modes update when another beast mode is changed. For example I have a summary number beast mode that uses several other beast modes inside of it and when I go to change any of those beast modes I have to re create the summary number one. I could delete the…
When drilling down to the details of a card, should the beast mode calculation show? For example, I have card that calculates the difference between 2 dates. I want to drill down and sort by the number of days, but when I drill down, the beast mode calculation that calculates the dates is not showing, therefore I can't…
I need to monitor the number of users we currently have within our DOMO instance by their "Role Type" Thank you in advance
It looks like you're new here. Sign in or register to get started.