GrantSmith Coach

That's because you can only build it going forward, you can't historically go back and get the data because of the API limitation allowing only the last 30 days. You'd start building your history today so that in the future you have it for your analysis.

@DanielA If you could accept my answer as a solution so that others can more easily find this question and solution if they're having similar issues I'd appreciate it.

If you're wanting to just view it as a table you can utilize a Pivot Table card. https://domohelp.domo.com/hc/en-us/articles/360043429473-Pivot-Table You can set the name as the rows and the question as the columns with your value as the value.

Hi @AnnieL https://domohelp.domo.com/hc/en-us/articles/360042931954-DataSet-via-Email-Connector Does the download link go to a website to click a button or link to download the excel file or does the link directly download the excel file? I think there may be an issue with Domo no being able to process a file from a link…

Hi @Daneia I believe this is a limitation with the Instagram API and not Domo itself. Typically what I will do in cases like this is to take weekly or monthly snapshots of my account metrics to see then data change over time but it lacks historical data because of the API limitations. I’ll use either a recursive data flow…

Hi @MB_Dem You'll need to work with your Domo Admins to get your role changed as only the Admins typically can do this. If they're generic D2L emails - who owns those emails? Can you work with your IT team to get access to those accounts to give yourself access? Have you talked with your Major Domo?

Hi @calebtyrone You’ll want to log a ticket with support as it sounds like an issue on the back end they could help investigate.

Hi @Shumilex Looks like an operator is missing between `WrapUpMin`) and (`LunchMin` What should that operator be? You'll need to utilize your CASE Statement to check for your denominator value being 0 prior to running the calculation with your denominator. CASE WHEN `ServiceName` like '%Manual_Only%' THEN CASE WHEN…

@mdixonii You'll need to reach out to Chuck Irwin (@chucki) to get access to the beta features and the Dojo Beta Forum.

You might be able to get all of the data via a segment however you can't do an inverse filter like you're wanting to do. https://domohelp.domo.com/hc/en-us/articles/4403089503383-Creating-Segments-in-Analyzer

There isn't a way built in to Domo which will allow you to get all the values except the one you're filtering. Domo works by running the filter first and then applying any beast modes. So with your beast mode attempting to get records which don't equal your filter there never will be any because they were filtered out…

@MarkSnodgrass Interesting as there isn't a Microsoft SQL Writeback Connector listed in the Data Connectors in my instance. I'll have to dig into why and if it's still supported. Thanks for the KB article.

Try this: DATE_ADD(`timePlaced`, INTERVAL `timeEstimate` MINUTES)

Hi @dprince You can't use workbench to write back to MS SQL. It's only to pull data from the defined sources. There doesn't appear to be a writeback tile to use for MS SQL either but only Postgres, Maria and MySQL databases.

@Kenn Do you have the check box for "Publicly embed content Allow public embedding of Cards and Dashboards" checked under Admin -> Company Settings -> Company Overview checked?

Hi @Ashleigh I don't believe there is, you can get the US or AU holidays from the Domo Dimensions connector referencing the calendar.csv or AUcalendar.csv files respectively. There are other API services which will get you international holidays like https://www.timeanddate.com/services/api/holiday-api.html but you…

Hi @Saketh Here's a more compact version utilizing modulo operations and date format CONCAT( -- START -- +5 not 6 since it's inclusive DATE_FORMAT(DATE_SUB(CURRENT_DATE(), (MOD(MONTH(CURRENT_DATE()), 3) + 5) MONTH), '%Y-%b'), ' - ', -- END DATE_FORMAT(DATE_SUB(CURRENT_DATE(), (MOD(MONTH(CURRENT_DATE()), 3)) MONTH),…

This is within the data level in Domo

You can setup a dataset view and allow them access tot the dataset to download the entire dataset. I’d also recommend looking into PDP as it will automatically filter your dataset based on defined permissions so you’d only need a single data set to point your users to

Hi @user048760 Another option would be to define a custom date offset dimension for the current date, last month and 2 months ago. You can then conditionally calculate the rolling average over the past 3 months or look at the difference between months based on the offsets your define. I’ve done a write up about offset…

Hi @Adrien the total row is calculated on the card after the beast mode is calculated so it’s adding your percentages instead of calculating your total percentage. if you want a total row you need to use an ETL to group your data together and sum all your columns using a group by tile then using an add constant tile put…

Hi @user041053 Id recommend looking over the knowledge base article on workbench and how to configure a job to start https://domohelp.domo.com/hc/en-us/articles/360056669354-Workbench-5-1

Filters will apply to all rows in your dataset so what you’re wanting to do isn’t possible. You might be able to get around it using a segment and tell it to not apply those filters you wish to ignore.

You may also want to look into Domo Publish https://domohelp.domo.com/hc/en-us/articles/360045120554-Domo-Publish

to get around this limitation I will utilize the line+bar chart and define my own offset dataset which gives much more flexibility. I’ve done a previous write up on this here: https://dojo.domo.com/discussion/comment/50540#Comment_50540 @jaeW_at_Onyx has done a video on this as well.…

I don’t recall the exact CSS styling but you’d need to update the hyperlink CSS styling link color for your hyperlink and that might work for you

The total row adds everything after beast modes have been applied. You’ll need to stack your data in an ETL using an append with your data set grouped and summed and call the rows TOTAL. Then you can use the beast mode to calculate your data for each lane and the total

Typically it’s just (‘New’-‘old’)/(‘new’) but it depends on how you have your percent change metric defined in the card settings. Which method are you using?

You’d need to have the field be the same name if you’re using a filter card for filtering on your page. If you’re using the page filter at the top it’ll filter based on the date field defined on each cards date selection. Im not sure how your dynamic text is being generated but it should get updated automatically if you’re…

Hi @Shumilex Can you use a group by name account and date and just use the MAX aggregate to get the highest balance?