GrantSmith Coach

I misread you answer. Thanks for the clarification @ST_-Superman-_

Hi @taylordomo Do you have any extra code / context for how you're calling ds_query? Are you passing your dictionary as the query or just the query string? Looking at the code for the query function it looks like it does the packaging automatically for you so you shouldn't need to pass in {"sql": "select * from table"} but…

Hi @user06209 The Data Governance datasets would get you the data you're looking for and allow you to easily visualize / analyze the data. In addition it'll allow you to automatically keep it up to date (and is platform independent). As @ST_-Superman-_ mentioned you can utilize the Excel plugin but that's only supported in…

@Kumar619 That's because you only have a single year being displayed. Are you wanting only the prior year to be displayed or multiple years?

Hi @Kumar619 Simple way is to utilize a Period over Period type chart to plot to Year over Year change percentage along with your values. In the date selector you can compare to a previous time by telling it how far back you want to compare to and in what unit.

Hi @msharma The filter is applied before any beast mode is calculated so if the card is filtered for Jan&Feb 2021 you won't have access to the 2020 data points. If you need that data point then you'd likely need to calculate it in a dataflow before hand. As for your G_L_ACCOUNT No_ field - you have different values for the…

You wouldn't be able to do that on the card because the filter happens before any beast mode is applied. You'd need to aggregate your data in an ETL before hand.

Hi @richardjmarshall You've got two options. 1) You could use a beast mode to determine if a date is from 2 months ago CASE WHEN LAST_DAY(CURDATE() - INTERVAL '2' MONTH) = LAST_DAY(`Date Field`) THEN 1 ELSE 0 END and then just filter on that value being 1. This method you're always stuck looking at 2 months ago according…

Hi @user03634 Sadly the label position is fairly limited currently with domo. You can only place all of the labels in the same relative position so you'll always have your overlap. The only option you have is to leave the overlap as is or uncheck the "Allow Overlap" option on your settings and not have some data labels…

Hi @user030156 / Michael I'd recommend using a dataset view (talk to your CSM to join the beta if you don't already have it) to calculate the date and hour of your timestamp. Date: DATE(`Timestamp`) Hour: HOUR(`Timestamp`) Then group based on these two fields (date and hour) and count the number of tickets you have using…

Hi @kacy There isn't a simple way to do this. You can conditionally set the color or a cell / row in a table using the color rules settings however it's only for that columns itself. You can't conditionally configure the color of one cell based on another column. You might be able to utilize an HTML table and do some…

Hi @msharma since you’re wanting to do a conditional sum you need to use a case statement inside your sum to only select the values you want sum(sum(case when `Transaction` = 1 then `Amount` else 0 end)) over (partition by year(`Posting Date`)) Repeat for transaction 0

Hi @akshayaviswanathan Simple answer - @Sam1 is correct... no. There is no bulk update technical And complex answer: Utilize the Java CLI to export your card definitions as JSON (backup-card command). Write a script to clean these files to remove the filter from the JSON definition Restore the cards from the updated JSON…

Hi @Kumar619 on your data table in analyzer there is a text box you can enter a number which will restrict the number or records displayed. You can sort by your metric and it will then display the top X number of records

Hi @Slapo Have you tried viewing your data as a table in analyzer and applying filters to see if your rows still show up? What happens when you lift some of your filters?

Hi @Sam1 The API token you authenticate and communicate with us for the user that created the token. So you could have a user which has their permissions limited to read only ( a custom role)

Hi @Jbrorby Apologies for any typos and the lack of screenshots as I’m on mobile If you have Magic ETL 2.0 beta (talk with your CSM to get it enabled) you could try and use the Dynamic Unpivot tile and then after you split your field (importantly here is a select columns tile to drop your original antigen csv list so it…

Hi @MattGo Period over Period charts don’t support percent change. You’d need to calculate it yourself using a beast mode however it’s best to reformat your data using a date dimension table to calculate your metrics on a certain date based on a certain offset (Last Year, last month last week etc. ). @jaeW_at_Onyx has a…

Hi @swagner Looks like you might be able to use their GetFile end point to download a file from the URL however I haven’t use this product so that’s going solely off the documentation you provided. You can start there but you may need to bring in a consultant or someone more technical to complete this connection.

Hi @AlexF Are you talking about ad impressions? You can use the ad Performance API report. Just select API from the drop down then Ad Performance https://knowledge.domo.com/Connect/Connecting_to_Data_with_Connectors/Configuring_Each_Connector/Connectors_for_Media_Applications/YouTube_Enterprise_Advanced_Connector

Hi @shannonmoranWF you can use variables within a MySQL data flow following standard MySQL 5.6 syntax

you may also want to look into data assembler if you have a large dataset and could possibly set it up using some partitions but it’s premium feature. There are a few guidelines for using it which are documented in the knowledge base https://knowledge.domo.com/The_Appstore/Available_Apps/Data_Assembler_Usage_Guidelines

Hi @banderson it sounds like you’re talking about an upsert type of connection. There are some connectors which support upsert however it appears that the MongoDB connector isn’t one of them. You could try and do something like a recursive dataflow to handle the upsert logic yourself however note that it doesn’t scale as…

Hi @gbennett Did you mean to say aggregating it doesn’t work? How does it currently work and how are you expecting it to work?

Hi @Kumar619 You can add annotations to some graphs in analyzer if you need to note a specific instance.

Hi @HowDoIDomo I recommend Line + Grouped Bar Chart types of graphs. In the general section you can define the number of metrics or series which make up the line portion of the graph. By default it is just the first value going left to right. You’d need to calculate your differences from last year manually and I’d…

Hi @Grecs5 alternatively you can use a data set view to join your two datasets together. another option to think about might be instead of joining your data together you UNION / stack your data together such that you have TYPE | WEEK | COUNT Demo | 1 | 3 Create | 1 | 10

Hey @swagner I’m on mobile so this is briefer than normal but because you’re attempting to aggregate on two separate levels which Domo doesn’t necessarily like. You might be able to calculate the sub totals or totals using a window function however I’d recommend using a data view on this data set to calculate the data on a…

Hi @jimmy If you talk with your CSM they may be able to spin up an environment with your required packages.

Hi @user082291 has something changed with your date fields? Are there now nulls in your date field? Can you try an alternate method for calculating date difference by using UNIX_TIMESTAMP? ’’’ ROUND(AVG((UNIX_TIMESTAMP(`Investigation End Date`-UNIX_TIMESTAMP(`Investigation Start Date`))/60/60/24),0) ’’’ simply it’s…