Chips Contributor

What value does the following beastmode return? A number? month(`Invoice date`)

And the invoice date is a text field with the month abbreviation (i.e. "Jan", "Feb" etc.)? Or is it a date or numerical value?

What does your dataset look like? MONTH CUSTOMER VALUE Jan A 100 Feb A 150 Or does it look more like your table below? And is the date value just a month or is it the full date?

Could you just insert a straight diff calc beastmode as your sort? DATEDIFF(`created_at`,`customer_created_at`)

Even better! Sounds like then you could do the Loaded/Empty Mile aggregation (Create a "Total Miles" column via Group By) in the Movement table and then just bring "Total Miles" through into your existing dataset. Give it a shot, let me know how it goes!

You are going to have to do that in Magic ETL. Input Data Set (Current Data Set you are using) Select Columns 1. Order Number (Rename to "Order Number LE") 2. Loaded/Empty 3. Miles Remove Duplicates Using All Three Columns 1.Order Number LE 2. Loaded/Empty 3. Miles Group By 1.Order Number LE Column AND 2.…

So the Max is aggregating at the lowest common denominator shown which in your case is Order Number AND Rep. If you remove Order Number from the table (and any other Order identification), it should work. If you have a Table Card that is simply the following two columns, it should work. Column 1 Rep Name Column…

Could you use a "Max" aggregation on the date of sale? DateDiff(Max(Date of Sale),Current Date)?

@meadow_ryan you want all 4 rows to show, and all have "1,072" as the miles? 

@user09338 Can a ticket be resolved on the same day it was created? @AS Might need to slightly amend solution if so, maybe ">=0"?

That is a link to your instance that only users from your instance will be able to access. Can you upload a screenshot?

It is fairly easy to link a card to another (Search the "Link Related Card" field at the bottom of any card and select your Data Dictionary card). As for Linking a card to a dataset I can't immediately think of a durable solution. Would just suggest that you link each card you create to the Data Dictionary card as…

@rhollander Didn't we run into this on the Rep Scorecard? Had something to do with the "hide date on card" selection, maybe? 

You could create a "Data Dictionary" card to share with everyone and then have it linked to your cards? I've even seen someone go so far as including hyperlinks on their Data Dictionary card to examples of those terms being used. "Term" - Achievement "Business Definition" - Order that has been fully approved and has…

I agree with @ST_-Superman-_, if the "Lines" column from your drill through is actually itself a beastmode, then you will need to create a "Number of Lines" via Magic ETL (or SQL if that is your fancy). I misunderstood, thinking from your video that 'Lines' was a column in your dataset. I would do a Magic ELT something…

How is the 'Lines' column on your drill through page populated? 

Morning @swagner, great video, very helpful in understanding the issue. That being said, I am sure you have already thought of the following solution, but it is the first thing that came to mind for me. Could you create a beastmode something like... IFNULL(COUNT(DISTINCT CASE WHEN 'Lines' = 1 THEN 'Order Number' END ),0)

In a Line + Grouped Bar visual the Line will be the data you present as the "Y-Axis" value. If I am understanding your example correctly, you should be able to choose the "Line + Grouped Bar" visual, then put the Rate measure as your "Y-Axis", then Withdrawal measure as your first Series, Deposit measure as your second.…

Only other option I see (if the above are too burdensome) is to write the name of the Data Set as a column in your data set via Magic ETL and then just render that as your summary number value. That way, if you wanted to do this across multiple cards it would be a durable reference as opposed to a static, manual input into…

You can customize the verbiage related to the Summary Number on a card as well as the value of it, and it will be visible from even the smallest version of a card. If I am understanding your example, you could create a beastmode for the Summary Number, and the value of the beastmode could be 'NAME OF DATASET'. One step…

Hi Brian, We have a page full of cards that do this, not just calcing period-over-period but doing so with conditionally formatted summary numbers. If you want to post your beastmode, I am happy to take a look. Also, @MattGo is a real expert on this topic, he is the one that taught me!

Agree with Ricardo, unaware of a solution for Collection-Specific Scheduled Reports. If I were to workaround on this one, I would copy/move (not Save As) the cards within the collection to a different page and set the schedule report to send from there. I would literally just use it as a resting place for those cards.

I am unaware of a Role-Based permissioning, but we have had great success with PDPs across our instance (which is user/group-based). If you haven't yet explored PDPs, I would recommend doing so. You can group users and permission them to their own view of the world.

Also, looks like someone was recently asking this same question on a different thread. https://dojo.domo.com/t5/Domo-Best-Practices/how-to-trigger-a-data-source-update-externally/m-p/25621#M187

David, Are you using a connector that doesn't allow for more frequent updates? We have found the Advanced Scheduling to be very helpful but I am guessing you aren't able to do that here for some reason (bc that would be the quickest/easiest way to solve it!). cg

We at one point had 27 different pages going for our sales regions, so I completely understand! We have had really great success with the pdp concept so if you are able to add users, would definitely +1 that idea. You've probably already expored this, but my only other idea would be to (where able) use the same card across…

Does accessibility to DOMO cards within SFDC require Participant-level licenses or can social licenses be leveraged? Guessing Participant-level but just wanted to confirm. 

Was there ever a response here? I, too, am interested.

Though I haven't done this myself, I believe it is plausible that you could create 6 identical datasets set to run every hour but initiated 10 minutes apart from you one another (so one runs at 5:00, then 5:10 etc.). From there you would append all 6 together via Magic ETL and remove duplicates based on a unique identifier…

I don't believe there is a way to do exactly what you are asking, but you could definitely do it with a Grouped Bar (or Stacked Bar) + Line where the bar could continue to be your revenue and the line the count, then use the %_VALUE macro for your data labels. This post being almost 90 days old I am sure you have already…