AJ2020 Member

Where did the "accept as solution" button go? I don't see it.

Thanks @jaeW_at_Onyx ! Agreed, big datasets get unwieldy. It was just a general knowledge question. Our SQL table limit is 1,000 and I was curious what Domo's was. Thanks! 😀

Hi @MarkSnodgrass , Thank you very much for your reply. It is not responding the way I had hoped. The numbers look further off than before. Sorry, but I grabbed a misleading portion of the dataset. The Start date, the Opened date, and the Closed date can be any combination of months. Same month, different months, or even…

@jaeW_at_Onyx Thank you! Do you have a video showing this? I am not quite understanding the steps. Thanks, Angela

Thanks Grant!

Thanks @MarkSnodgrass. That is definitely a cleaner statement :) but my issue went deeper to the actual dataset setup.

Thanks @jaeW_at_Onyx ! The Append did the trick. At first I couldn't see the budgets bu then realized I needed to add a new date field that would pull in both budget lines and expense lines. I finally just cleaned up the last card and they look great! Thanks again! Angela

Hi @GrantSmith, I love that! I will work it in for sure! Thanks! Angela

Hi @GrantSmith , Thank you for the excellent explanation! I wasn't understanding why to include the FLOOR when it was just a 0, but if the turn time goes over 4 days we will definitely need that portion. It is amazing the brain yoga you did to create this! Thanks SO MUCH! Angela

Hi @GrantSmith , Thanks for the eagle eyes! 😊 The formula is not quite jumping over the weekends. See chart below of some renewals where before 3 PM it should be 3 days & after 3 PM should be 4 days. I tried to play with the formula, but to be honest, I don't fully understand the FLOOR & MOD segments as they would be zero…

Hi @jaeW_at_Onyx , Thank you for your reply and additional documentation. I am still having challenges getting it to work. I tried the new function, but it switched all of the units to "1". I tried switching the order of the partition by fields but no luck. The SQL link discussed frame-clauses. Is that needed? Below are…

Hi @jaeW_at_Onyx , Thanks! You answered a question of mine on another post. I am still trying to work through that one. Thanks, Angela

Hi @GrantSmith , Thank you very much for the explanation! I had to read it a few times to digest it :) When I use the formula you gave at the end, it passes the beast mode validation test, but when I refresh the page I get the error "An issue has occurred during processing. We are unable to complete the request at this…

Hi @jaeW_at_Onyx , Thanks. I had windowed functions enabled after watching your great video on Open Rate https://youtu.be/ZPf41Fjn1H8 😀, but I was having challenges with getting the formula to work with my case. I applied the formula above, but the monthly product rows do not add up to 100%. The grand total row at the…

Hi @jaeW_at_Onyx and @GrantSmith , I did some poking around with the flex table and think the "Horizontal Single Bar" graph in the flex table would be a good solution, but I cannot figure out the correct fields for the single bar. Ideally, the table would look like the below with the chart showing the % of the budget for…

Thanks Jae! The Webform is working out great! For the visualization, my manager prefers the donut or the gauge since the flex table with the bar or line charts show the trend instead of the current status, which is what he is focused on. I do really like the amount of detail it holds in a concise space. Can the flex tables…

@GrantSmith it worked! Thanks so much!

Thank you @GrantSmith ? Yes, that is what I was looking for! ? However, when I try to use that new beast mode in the table, it does not show a SUM option as it recognizes it as a text field. How do I get it to calculate as a numeric field and then just display with the "M"? Thanks, Angela

Thank you @jaeW_at_Onyx ? I have confirmed with management and they want to do traditional rounding (the blue version). I have seen beast modes that add commas to large numbers, but not for reducing a large number to the shorter notation with the "M" or "B" at the end. I tried the ROUND function with a negative number but…

Hi @jaeW_at_Onyx , I adjusted the beast mode to : SUM(COUNT(`Item Code`)) OVER (PARTITION BY `Company Name`) and it worked! I was making it too complicated ? I need to read up on "Partition By" some more. Thanks so much for your help!

Hi @MarkSnodgrass, I was hoping the same thing but no luck :( This was a drill-down view so maybe that made it more futzy. The partition beast mode worked though. Thanks for your help ?

Hi @GrantSmith , Yes, it is the series. Thanks, Angela

Thanks, @jaeW_at_Onyx ! What field name should I use for "amount"? I tried the below, but I may be making it more complicated than needed: SUM(SUM(COUNT(`Item Code`))) OVER (PARTITION BY `Company Name`) It validated, but when I updated my screen, I got the error: "An issue has occurred during processing. We are unable to…

Thanks so much @MichelleH !. Sorry for the late reply. I had an error (my fault) and got too busy to dig in and see where it was going wrong. This worked great! Thanks for sharing your knowledge & time! ?

Also, @jaeW_at_Onyx I LOVE your Youtube videos! You rock! 

Thanks @jaeW_at_Onyx Not the answer I wanted to hear, but I appreciate the clarity

@jaeW_at_Onyx , thanks for your help. I tried, but that wasn't the fix. Domo support figured out that the Workbench that was bringing over the data did not have a time zone set. Setting the time zone in the Workbench lets Domo know what time non-UTC data is coming over in (in this instance, all our data was in Pacific…

Hi Jae, Thanks for your response. The data leaves our warehouse in Pacific time and goes into Domo unchanged by us. Are you saying to use an ETL to switch the times to UTC? Do you have an example of what that ETL would look like?