DavidChurchman Coach

コメント

  • Agree with @GrantSmith. Also worth noting that it's possible to see the Embed IDs already created for a dashboard in the admin console.
  • @verytiredgirl had a very similar question recently, and I posted essentially the same solution as @MichelleH on this thread. @chetan_cricut there are some screenshots on that response that might help you understand what to do with the BeastMode (save on card and use as card filter) vs. the Variable (reference in the…
  • It sounds like you are trying to get 3 lines on top bars that are broken up into stacks of three? Besides being visually very busy, I'm afraid the lines would be difficult to interpret. A stacked bar is common practice, but with the lines, you'd either have to treat them as stacked, which would go against how lines are…
    YOY with Series DavidChurchmanによるコメント 09/02
  • A BeastMode approach would be to change your FinData to be negative for expenses and positive for revenue. Then you could use the table's built in Total row, which has the advantage of being dynamic with filtering. CASE WHEN Account Type = 'Revenue' THEN FinData ELSE -1 * FinData END
  • The easiest thing would be to use a Slicer filter instead of a Radio filter, which gives options to select multiple or select all. But, a more literal answer to your original request is using a variable: Create a variable (let's call it channel_variable, with the possible values of 'Facebook', 'Instagram', 'TikTok',…
  • Assuming data like this: Note, I added a Group to make it easier to apply your color rules, and I joined "Revenue last week" to each row to make it easier to calculate the delta from last week. You could create something like this in a pivot table, plus color rules and formatting: Note that the category names don't repeat…
  • I like your solution. I think what I would have done (not necessarily better), is filter two datasets, one for Products one for Sales, find row number for both, and join on row number. P
    Pivot Data DavidChurchmanによるコメント 08/26
  • It's a little unclear what you're asking for. I tested your code after changing the directory to '/home/domo' and was able to search for strings within all my Jupyter notebooks in a workspace. Are you wanting to search across workspaces? Or what problem are you running into with your code?
  • Spark Line chart does most of that. It has icons, current value, and percentage change:
    Next Level KPI DavidChurchmanによるコメント 08/12
  • Oh, got it. I didn't realize it was only in App Studio. I see it there, but not on standard pages.
  • The only column these two tables have in common is "Product", so I'm assuming you can tell what the "Branch" is based on the product. If that's true, I would take the "Product' and "Branch" columns from the first table and join them onto the second table using Product as the join key. Then, you could filter your new table…
  • I'm not seeing the "contains" option on page filters. Anyone else seeing it?
  • Do you have a Date Format applied to the column? I was able to reproduce this by applying a bad date format:
  • Create a branch, filter for Date = Today() Rename HC to "Current HC"; drop Date column and any other redundant columns you don't need to rejoin the data Join the "Current HC" back to the rest of the data. I just joined on country with my simplified data, but depending on your granularity, you'll need to join back based on…
  • Okay, add a Formula tile in the Magic ETL to calculate Diff before the dynamic Unpivot. Granularity of the data won't change the process. You'll determine the granularity based on the combination of your rows/columns.
  • You can definitely do this without a brick. I'm assuming your data is roughly structured like this: Use an ETL to unpivot your data a little longer and create a column that indicates whether the measure is Headcount or Headcount difference. The resulting data should look something like this: Then, in your pivot table you…
  • Try sorting your series first and then your X-Axis by dragging your variables into the Sorting menu.
  • I think the easiest/cleanest option is you can use a stacked bar chart and then use trellis categories to group your stacks. I might also suggest with the set-up you're describing to instead just do a stack of 4 categories: New*US; New*Non-US; Existing*US; Existing*Non-US. Then you could use color coding/sorting, to…
    Group Stacked bar chart DavidChurchmanによるコメント 07/29
  • I'm assuming your source data looks like this. (Per @ArborRose's suggestion, it's always helpful to provide an example of the structure of your raw data, not just the desired report). Assuming that I'm correct about the raw data, this would be easy to replicate in a Pivot Table, using this BeastMode for % of Revenue:…
    % of Revenue Beastmode DavidChurchmanによるコメント 07/29
  • Yes, you can use HTML tags on custom summary numbers to change the style. Something like this: CONCAT( '<div style=color:#3a8dde; font-size:10px; font-weight:100>', Your current Summary Number BeastMode, '</div>' ) More examples here: And a list of the available style tags are at the bottom of this article:
    Reduce Font on the Cards DavidChurchmanによるコメント 07/29
  • Yes, that would be helpful. Even better would be to be able to draw values from a column or table so variables could be more dynamic.
  • Does your expected variance really change going out it into the future? If instead of having changing variance, you picked a static expected variance, you could use the compound interest formula to project it out without doing it recursively. Let's say your expected variance was 4%:…
  • You could also use a fixed function to do this. Something like this: SUM(AVG(`cost`) FIXED(BY code))
  • Instead of a DISTINCT, use a FIXED function. Something like this should work: SUM(SUM(`TOTAL Customer PTS`) FIXED(BY Customer)) I bookmarked this KB article my first year of using Domo because I used it so often: https://domo-support.domo.com/s/article/4408174643607?language=en_US
  • Sadly, no, not out of the box. You cannot color anything in Domo based on a different field. There is an idea similar to this posted in the idea exchange basically every month. Here's one, so feel free to upvote it (and the many others) or add your own idea to the void: Some options in the meantime: You can add a second…
  • In a stacked bar chart, You can use "percent to target" as your value so they're all on the same scale, and then a tool-tip as your label where you have the actual values. For color coding, use a series. I manually created the labels in the data, but you could do that more dynamically with some concat() and case statements.
  • Also, in MagicETL, you could use a scripting tile to use R or Python to do this with a for-loop, but if you go that route, it would probably be easier to use a built in function like cut() from R or pandas.cut().
  • OP asked if you could use a variable, so to add to @GrantSmith's answer, you could replace every 5 in his answer with a variable (let's say it has a default value of 5) and then dynamically adjust the bucket size on your dashboard with a variable control.
  • Yes, agree it would be better if there were some styling options built into the interface, and underlining is not one of the supported HTML tags. That said, the conditional formatting enabled by HTML can be more useful than underlining, etc. If I had to choose, I'd choose the ability to use HTML tags with conditional logic…
  • Nothing wrong with Colemen's formula, but since you already created a table that you joined on your start dates, you should be able to use that same table and join it a second time to your end dates. Also, for a BeastMode friendly formula approach, you could leverage the WEEKDAY function, which returns 1 for Sunday, 2 for…