jaeW_at_Onyx Coach

@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?

@user02790, Super important. Can you please update your username handle so it's easier to AT_Mention you? it helps guarantee you get timely notifications... and also helps respondents get an idea of who we're talking to! This will start by sounding snide but lead to a solution that i've implemented at companies with multi…

@user048760 could you update your profile handle so it's easier to AT mention you? can you give us a sample of your data. it sounds like it should be pretty straight forward. split numerator and denominator into separate beast modes and pop it into a table card. if your denominator is zero then you know hwat the problem is…

@User_32489 , hey, Just FYI with Dojo's new system it's much more difficult to AT_mention people so they get notified. If you change your profile name it makes sure you get repsonses quickly. Anyway, this looks like a bug (which you should raise to support@domo.com) But, have you confirmed that if you apply filters there's…

+1 @GrantSmith except it sounds like you need to add a partition. @Bwaalsh, sum(Sales) / sum(sum(sales)) over (partition by colors) I actually just posted a video involving window functions (https://www.youtube.com/watch?v=Esnu1PSxRjM&t=35s)

@Mark 100% agree. Also, @Anna Yardley , I made this video with a list of bullets I always try to check. One of the Resources referenced in the video: https://www.darkhorseanalytics.com/blog/salvaging-the-pie // legtit one of my favorite resources for visualization design.

oof @Brandon i don't know the answer. that would be a great question for support, and if you were thinking of going the custom role route, ask them, they probably get this question all the time (b/c custom roles is a popular topic with customers).

@Brandon , I think i'd frame it a different way. What behavior are you trying to control? If i had to guess, you're trying to prevent people from accessing data outside of Domo. that's a bit tricky because because theoretically if i can read data in domo there's no reason i shouldn't be able to read data outside of domo.…

@Sandis , can you relink the image?

@user047019 , it's a common design pattern in Domo for features like this. CROSS apply is relatively easy in Magic to do a CROSS APPLY just add a fixed constant of 1 on the left and right side of the dataset and JOIN on 1 = 1 https://youtu.be/Xb4QgKYgaqg?t=295