コメント
-
Sure, I'll DM you
-
In your initial post, you said the data was snapshotted every week. But in a recent reply, you said the data was snapshotted every day. Which is it? I've been under the assumption that it was once a week, so if that isn't true, the Beast Mode would need to be updated to reflect that. There is likely a way to achieve it in…
-
You would have to add Billing Entity to the partition if you want to have that in the table too. But, if that doesn't work, then maybe another solution is best. You could make a column in the DataFlow to use. And maybe you already have that and I missed it. What is the Snapshot Week Rank column?
-
I've never run into this issue. I just verified on several of my DataSets and they all have all Beast Modes as options. You could create a case with Domo Support. But can probably get some information via the network tab in the developer tools that could help you fix it yourself or at least inform that conversation with…
-
Oh, you're using a pivot table? That might be the issue. They aggregate things a lot differently and I haven't verified this specific Beast Mode on one. Can you try using a mega table?
-
Where are you storing the Excel spreadsheet? The answer is likely Workflows or the Product APIs, but it depends on where you are storing it and what your use case is. There are also tools like Webforms that allow you to update a spreadsheet inside of Domo that could be useful depending on who's updating it.
-
What is your date range filtered to? Or do you have any other filters on the card that could be filtering the values you need out?
-
Kind of, but not really. Directly as you stated, it isn't possible unless you do what you said, make a color rule for every user then every page. However, if the business unit column shows up in that drill path, it will be colored. So, you could keep the user/page as your x- or y-axis value but add the business unit as the…
-
There should be yes's to select. Sometimes with window functions you have to save the card so that the Beast Mode saves, then refresh and see if you can select them then. If they still aren't there, something else needs to be adjusted.
-
@tpfeiffer54 not at the moment. You can make an HTML link using an a tag and add the target="_blank" property to it, which is what I've been doing forever. But using this new feature that doesn't require a Beast Mode and writing HTML, there isn't a way for it to open in a new tab.
-
Oh lol, I put Status/Stage then Stage/Status. Just adjust the second reference to be Status/Stage.
-
Is the key for the column also called "Region"? Or did you set the key as "region"? If you don't remember, you can view it here: https://<instance>.domo.com/admin/governance/attribute-management
-
What is the date column for when your snapshot occurred called? I just put Snapshot Date as an assumption, but yours isn't called that probably.
-
(CASE WHEN LAG(`Status/Stage`) OVER (PARTITION BY `<unique_identifier>` ORDER BY `Snapshot Date` ASC) != 'Parked Revenue' AND `Stage/Status` = 'Parked Revenue' THEN 'Yes' ELSE 'No' END) Add this Beast Mode as a filter, and select Yes. Make sure to replace the unique_identifier field with whatever your unique identifier is…
-
I'm not sure I understand your goal. What do you want the final table to look like and be grouped by?
-
In your Beast Mode, your condition has Snapshot Week Rank = 1 AND Snapshot Week Rank = 0, which cannot both be true at the same. The same is happening to the Status/Stage condition. For week over week, you can use a Period Over Period chart type, change the graph by period to week, and compare week over week.…
-
Are you on consumption? If you are, it is included at no extra cost. If you have consumption but it says request a quote, that just means they didn't put it in your contract. So, you'll have to contact your CSM or AE and ask for access, and they might have you sign a $0 amendment to add it. If you are on the user model, I…
-
If you use a Pro-Code App, you can use React and find a component library that makes things a lot quicker and easier to build. I'd recommend React Hook Forms, AWS Amplify, Chakra UI, React Bootstrap, or Material UI for starters. AWS Amplify also has a way to build forms without code, then import it into React and modify as…
-
This isn't supported at the moment, so it would be best to submit an idea to the Ideas Exchange if one doesn't already exist. For workarounds, you could use a Brick or Pro-Code App to achieve this. Documentation for those can be found here: Domo Developer - Apps Overview.
-
Yeah, the only way you are going to get this is by using a DDX Brick or a Pro-Code App. As far as templates, React typically has the most templates that are the easiest to implement into Domo, so I would go for a Pro-Code App built in React. You can find millions of templates online. Here is a great library from Atlassian…
-
Have you looked into the Domo Finance App yet? Domo Finance | Implementation Guide. It includes a great P&L report that is probably what you're looking for. You will probably have to prep it a bit in a DataFlow or Views Explorer, especially for your margin columns.
-
You're looking for the value domo.policy.managed_email_address as referenced here: PDP Automation
-
If you give them the manage all DataSets grant via a role, that will show all DataSets to them and allow them to edit all of them.
-
You can choose to have a filter card only affect certain cards (or one card) just like you can on a regular dashboard. As for filters, they work the same as a regular dashboard. Users can customize and save a view for just themselves.
-
You can achieve this with the Maximum Items option under Chart Properties > General. Everything outside the limit will be turned into an Other bar, which you can leave or then choose to hide two options down.
-
Jae is correct, this can be achieved via the Product APIs. Authentication to Product APIs documentation: PUT https://<instance>.domo.com/api/content/v1/landings/target/<type>/entity/PAGE/id/<page_id>/<user_id> Where <type> is either DESKTOP or MOBILE.
-
I love this idea. You can actually view the error returned if you inspect the network request in the developer tools of your browser. Most of the time, they actually do have a lot more information about the error, not even just the response from the API. So, it should be easy to just display this to the user.
-
Somehow I missed this post when looking before I created my own. Linking it here, since I don't have the ability to close it. History Keyboard Shortcuts for Undo and Redo — Domo Community Forum
-
You can achieve this via Beast Mode. So, they probably won't spend time adding it. CONVERT_TZ(NOW(), 'UTC', 'America/New_York')
-
This is possible via the Product APIs if you are looking for a workaround. Authentication to the Product APIs documentation: POST https://<instance>.domo.com/api/content/v1/avatar/bulk Body: { "isOpen": false, "transactionId": "<random_guid>", "entityIds": [ "<user_id>" ], "entityType": "USER", "base64Image":…