jaeW_at_Onyx Coach

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

Use PyDomo https://github.com/domoinc/domo-python-sdk https://www.youtube.com/watch?v=oT5NipvWK1o

Angela, Store your budget in a Webform or Google Sheets (two columns, amount and region name) then append (UNION) that data to your transactions. This way when the Budget amount needs to change you can just alter a webform. Very easy. 2) I want to see the total $ amount spent and % of usage MTD for each region inside the…

if you have different marketing sources blended into the same column then you need sum( case when marekting_source = 'value' then `amount` end ) i would recommend that you not calculate YOY or MOM as separate columns in your dataset. it makes it difficult to apply filters. instead just use either window functions in…

my favorite feature include code blocks. type three tildas, `, and then you get a nice code block. CASE WHEN ... Code goes here also you can just paste in images like screenshots using Copy / Paste or embed videos via URL links https://www.youtube.com/watch?v=eKOLhsfl10Q&t=3s

@user048760 glad you got there in the end! can you pls mark this ticket as closed / answered closed?