guitarhero23 Contributor

Are you part of a beta or something for the pivot tables? I've been waiting to use it since it was announced and have been bugging my account manager asking when it's coming.

If you aren't able to edit the card and have unfiltered it and still see it maybe a change was made by the card owner and it's not anything you did? Might have to have them look into it. A screenshot could help us understand what you're experiencing if you're able to.

Are you able to edit the CSV and just do a find and replace prior to uploading to Domo?

Is this what you're looking for? (CASE WHEN `Social` = 'Twitter' THEN `Value` * 0.5 WHEN `Social` = 'Facebook' THEN `Value` * 0.5 WHEN `Social` = 'LinkedIn' THEN `Value` * 3.0 END) In this case "Social" = your "Column D" and "Value" = your "Column N"

Can we see a screenshot of the Salesforce report and a screenshot of what Domo shows when you import? (blank out any sensitive info) but it would help because I wouldn't expect Domo to pull in a currency symbol, just the number.

Yes a beast mode should work out for that, I would also recommend adding that new calculated field to the filter and checking the "Quick Filters" box so that you can filter or unfilter it while on the card. An option would be to use a case statement, something like (CASE WHEN `tag` = 'Internal tag #1' THEN 'Internal' WHEN…

I don't really have a solution for you just that you're right, that would be the expected default behavior with how drilldowns work. You define a drill down card and depending on what value you click on in the parent card it will always send that value to the next card as the drilldown value which is why it's hard to…

You can close it by marking whichever answer was the solution as the solution.

hola!

While I don't use the Asana connector myself that does seem quite long. Do you know how many tasks exist in your system? I bet once you get it down to the task level you'll get a lot more information that you can work with. If it normally takes over an hour definitely do it on a daily basis and scheduled it early before…

When you say you can't figure how to replicate, what have you done so far and have setup? Have you connected Domo to Asana? Have you pulled in the relevant data that can be used to build the visuals you imagine? 

That would make sense. Only those of role "Admin" has access to the security tab and is the only one that can generate access tokens. I'd recommend talking to whoever has the admin role and requesting a token from them

I believe you're just looking at all the available roles in Domo and what permissions they have, not necessarily what role you have assigned to you. Can you go to the People tab and click on your name and see what it says for your role?

What role does your user account have within the organzation? I believe all or certain non admin roles can see the admin page but certain options won't show up. Admins should by default though see the Security tab.

Hmm I don't believe that's something that's an option. Just throwing an idea out that's sort of what you want. You could have a Python script that gets the metadata about the output dataset of the dataflow. You'll get a response that includes "dataCurrentAt" for each dataset. You could then make fairly simple logic where…

Hi, I'd recommend deleting the pictures and the Authorization: Basic thing you have in there MzY1MjgyOWQtNTF..... and perhaps obscuring at least part of the credentials. It would allow anyone to make API requests under that cliendID+secret. Perhaps someone that uses the R plugin can give additional ways to authenticate but…

What's the schema of your data like? Is it 1 row per month? Might help people understand further if they knew if data was already grouped by month or if you would have to do some grouping first.

for DomoR::init() it's expecting ('Domo_base_url', 'Developer Token') When using the DomoR package, the first thing you'll need to do is to initialize the development environment with your Domo customer instance (i.e. CUSTOMER.domo.com for https://CUSTOMER.domo.com) and your API access token. To generate an API access…

How about something like (CASE WHEN `settlementID` IS NULL THEN IFNULL(`settlementID`,'pending') ELSE `settlementID` END )

I saw a discussion here recently about tags and how it wasn't available currently via the API (for datasets) so I'd assume for specific columns it's not available yet and in terms of column description I'd venture a guess that it's also not available. I'm not sure if the user ended up submitting an idea in the idea…

Here is one I use for Salesforce where Id is a domo column CONCAT('<a href= https://example.my.salesforce.com/',`Id`,' target = new> View in Salesforce </a>') Try this and if that works then attempt to add the datasetfield to the visible text for the URL CONCAT('<a href= https://example.com/',`DatasetField`,' target = new>…

user03999's response from support is correct to my understanding. If you just want to trigger the run of an existing dataset you can't do this via the API. However you could re-engineer the whole thing to go through the API to send the data to Domo that way but that's probably way more work than you would want to or…

I'll experiment with doing it as a dataflow and swapping datasets. Was wondering if I could work any beastmode magic to avoid it but yea it seems MySQL dataflow will be what I do. I'll update once I have something if I have an additional question

Try adding multiple CASE statements together Something like (CASE WHEN `Field1` = 1 THEN 20 WHEN `Field 1` = X THEN Y ...etc ELSE 0 END) + (CASE WHEN `Field2` = 'Yes' THEN 30 ELSE 0 END)

The Velocity is calculated via a beastmode. It's basically a SUM of all the tickets that meet a certain criteria. I can include it if you'd find it useful but it's a little more detailed than the example I gave because I was trying to make it as simple to understand. I'd be seeing averages by quarter so a Q1 number, Q2,…

Thanks guys, I figured I was hoping too much from a beast mode in this case but I've seen some crazy ones so wanted to check before going to a dataflow. I'll attempt to do this and make progress in a dataflow before asking for you to do work to help me.

Thanks for the response, something like that is what I was originally going for but realized it's not going to work. I would want to look back on say 5/1 and see what the sum of online users was for the previous 7 days to that, and so forth for any day of any month. using current_date only allows me to have a number that…

How is it coming into Domo? Native connector? Workbench? File Upload? Depending on the above you might be able to set it in the original dataset. However regardless you can use the ETL dataflow to change the column type. 1: Click + in upper right and choose Data>ETL 2: Add the dataset as the input dataset. 3: Add the "Set…

I'm not sure the API has kept up with that added feature yet but it is definitely something they should add. Maybe add it to the idea suggestion area for a future improvement.

Zoho has more than one offering, which are you referring to? Domo has a Zoho CRM connector already available but I believe it's the only one. If you're trying to connect to something else, like 24x7 you might have to do that custom.