jaeW_at_Onyx Coach

@user048760 , you've stumbled onto the age old problem. :P 1) i assume that the price list report changes / updates regularly (let's assume weekly). at some point you'll probably want to ask "what did these metrics look like 5 weeks ago." to do that you'll need to have accumulated the history of this snapshot report. add a…

@user077529 this looks like a duplicate. can we close it?

@user052846 three things ... there are a couple products in domo that can use python, in the future it might be useful to include screen shots of your setup to establish context. given the error message you provided, is the preceding tile in your dataflow called 'original' ? # read data from inputs into a data frame…

in addition to @GrantSmith 's answers you can take a look at the ODBC connector, https://knowledge.domo.com/Connect/Connecting_to_Data_Using_Other_Methods/Domo_ODBC_Data_Driver, there are commercial implications to aquiring access to the driver,but it does create a more SQL friendly workflow. PyDomo would probably be the…

@user07759 and @GrantSmith while lag() is a brilliant solution for getting this done, keep in mind that lag will get the previous row. IF THERE IS A GAP IN WEEKS you'll end up comparing week 7 with week 5. which ... depending on the business question may or may not be correct. If you want to calculate current week versus…

Awesome! Sounds like success?

screenshot.

Sort your rank DESCENDING and then filter WHERE rank = 1.

@Kumar619 , another alternative is to construct a CASE statement case when date >=currentdate() - 365 then 'this year' when date >= currentdate()- 720 then 'two years ago' ... end

@user009257 instead of worrying about the chart type, maybe draw out on paper what this viz should ook like, and also what you're trying to communicate. Are you trying to measure utilization rates? if so, a table card of equipment with daily utilization expressed as a percentage might be more effective than a bunch of…

@Kumar619 , you are correct, you cannot rename values in the Legend. However, you can create beast modes where you change the series name.

@user084060 SELECT DISTINCT "id" FROM "table" is supported in redshift, but you've got some interesting syntax going on there, so I'm not sure I understand what you're trying to get done. Side note, if all you need is a SELECT DISTINCT, Magic 2.0 will probably outperform a Redshift transform. I strongly recommend you take…

@ktranstudent , Mapbox and the Custom SVGs are completely different approaches to solving problems (but neither is necessarily better or worse). Does it HAVE to be mapbox? What's the problem you're trying to solve? What's your level of skill with writing JavaScript Apps? Because custom apps are functionally iFrames in…

@jeremymcd absolutely +1 to @GrantSmith 's answer. Side note Grant is the community expert on dealing with Time in Dojo, and I find his recommendation to convert to Unix_Timestamp with timediff related issues to be the easiest way to skip some of the shortcomings of Domo's other time comparison implementations. Regarding…

@Kumar not as far as i know. Using an offset date calendar like in this video, will give you a scalable way to do this outside of Period-Over-Period cards AND give you control over your legend. https://www.youtube.com/watch?v=CDKNOmKClms&t=406s

Hideo, Domo Actions are a feature you have to get enabled in your instance (contact your CSM or account representative) and Write Back is a premium / add-on feature that has commercial implications. Again talk to your CSM and account representative. On a personal note, I would love to know and understand more about what…

"if you change the aggregation method on the second beast mode to AVG, MIN or MAX, you should see a different value."

@the_tree does it yield the desired results? i stated that your code is syntactically correct, look closer at the docs though, in most of them, the CASE statement will be nested INSIDE the aggregation. The only way you get the accurate results with the CASE statement on the outside is IF stage name is on an axis.

@the_tree you can't write that. CASE WHEN `Stage Name` = 'MQL (5%)' THEN sum(`Opp Value`)*.05 END try SUM( CASE WHEN `Stage Name` = 'MQL (5%)' THEN `Opp Value` *.05 END ) your code is syntactically correct, but your SUM(Opp value) is evaluating BEFORE the CASE statement is being tested.

@Shumilex , IF beast modes only allow you to COUNT it implies that the value being output is TEXT. You can't take the average of text. Try just AVG(UNIX_TIMESTAMP(`closedDate`)) and a separate beast mode AVG(UNIX_TIMESTAMP(`createdDate`)) Given what you've described, i'll bet there are some cases where the row is returning…

Yes. this is normal behavior. I assume by two choices you mean either sum(1) OR 1 In Analyzer the default aggregation is sum. if you change the aggregation method on the second beast mode to AVG, MIN or MAX, you should see a different value. if you have a beast mode with a built in aggregate, you cannot change the…

FYI, if you're on Magic 2.0 and you find the Formula tile more intuitive, you can build more sophisticated transforms using: cc @GrantSmith

 @user048760 , @GrantSmith is spot on in the math. It will get the job done. But this design / approach is ... difficult to scale because it requires you to never change the filters on your cards (notice how you currently have it set for 13 months. If a user wants to drill into a specific month or applied a date filter to…

the behavior in power point mimics the behavior of HTML cards in Domo. Not scrollable. See comment about using Excel to export longer tables.

For 'best practices' if you have a derived column like timediff (closeddate, created date), because the values are on the same row, you should create that column in ETL . That said, to address your question, simplify. there's no reason for the two nested sec_to_time functions SEC_TO_TIME(AVG(…

@anasahmed , you're creating power points right ... why are you exporting scrollable tables? this may be an example of using the wrong tool for the job. if you want to give your users access to ALL the data, why not use an Excel Connector and just export the dataset or table?

@Kumar619 , just to help out support. what do you mean by "the dimension name is not right." when you submit your ticket to support, maybe include a screenshot of what you're expecting to see from Adobe.

@Kumar619 use the Domo_Governance "Dataset Details" and "Dataset" reports https://knowledge.domo.com/Connect/Connecting_to_Data_with_Connectors/Configuring_Each_Connector/Connectors_for_Analytics/Domo_Governance_Datasets_Connector

@user025461 , contact your Domo CSM or sales representative and ask them to enable the feautre: "window functions in beast mode"

have a look at the microsoft addons https://knowledge.domo.com/Engage/Sharing_Content_in_Domo/Using_the_Domo_PowerPoint_Plugin