Comments
-
Thank you for this, I'm a neophyte when it comes to HTML. I'm trying to pass the Account.ID field from a salesforce page into the value to filter. How would that look in the code you attached? I half a33ed this and got a pfilter error on my visual force page. I don't know what string to put in the code. When my guys are in…
-
this is amazing work man. I really appreciate the detail you went through. I can't mark it as the answer to my questin, but it really is awesome. I've never used the flex table.
-
I'm always up for learning something new. I'd love to sync up and see what you put together there!
-
well, I didn't think it would be heavy lifting is why ? Our Operating guy wanted it, so I thought, "how hard can it be"
-
So with the following beast mode it doesn't exactly work in the Summary b/c this is a Period over Time Card I won't have the dates for last year. What I need to do, and can't wrap my brain around is how to say; When the Route Date = this year and month, then give me the Lifts from this same month Last Year concat( 'Current…
-
I should also say I was able to get this to work, but I can't seem to get it to work on the summary line and show results from April 2018. It just says, "NO" for me case when year(`route date`) = year(current_date()) - 1 and month(current_date()) = month(`route date`) then SUM(`Lifts`) ELSE 'NO' END ,
-
great idea thank you
-
Not helpful Jarvis. I don't want to pay for Pro Serv. It's not in the Knowledge base. This seems like something that someone else could have done already I was hoping the Dojo would help me.
-
Yeah I read that but I can't figure out how to get it working based on that explanation
-
Is there any way you can share with me the url you used in the salesforce Iframe? (remove any sensitive data and replace with generic terms) I can't figure out how to pass the data in the URL.... this is all I'm able to get working: <apex:page standardController="Account"> <iframe…
-
post the correct script and I'll accept it as the answer. Brilliant man
-
wow, just wow man
-
Got an error: "Cannot read property 'drivers' of undefined"
-
Here's my final working script. Next I need to figure out how to get it to output to a table, but for now this works and hopefully will help someone else var res = httprequest.post('https://us3.api.samsara.com/v1/fleet/drivers?access_token=xxxxxxxx','{\"groupId\": xxxx}'); DOMO.log('res: ' + res); var data =…
-
I'm also wondering if this documentation I found is affecting the token? $ curl -i -X POST -d "{\"groupId\": 3167}" "https://us3.api.samsara.com/v1/fleet/locations?access_token=xxxxx
-
No, that's not it because I changed it to a get that doesn't require a specific ID and I still get the 'res' error var res = httprequest.get('https://api.samsara.com/v1/fleet/drivers/inactive' + metadata.account.apikey); DOMO.log('res: ' + res);
-
Any idea why it might be saying "invalid token" Pretty sure the token is right because I c&p'd the API Key from the site
-
I do have a drivers qry too. I had hoped I could just pull back all the data and ETL it in Domo. Wishful thinking https://api.samsara.com/v1/fleet/drivers @Valiant wrote:You'll probably also need to identify a specifc driver id from the looks of that script. I'm thinking you'll probably have to call the drivers api to get…
-
well now we're going beyond my scope. ugh.
-
You rock man, I'm getting closer. But I got an error...I know I have the right api token in the API Key field
-
I already know the query I want to post too: https://api.samsara.com/v1/fleet/drivers/{driver_id}/hos_daily_logs and that's all I want to do
-
Thank you. It's good to know I'm on the right track. Like I stated, the documentation for Samsara says all I need is a basic authentication script. What is confusing to me is where to put it? I dropped it in, clicked run script but then get this error?
-
Additionally, I have created a visual force page, but need to understand where to put the filters so the account id from the salesforce page is pulled into the Domo card filter
-
Duh, used group by function.
-
here's how I did something similar: Made a beast mode: concat(`Date`, ' ') Concat your date field Drop it in the filter and select the slider to appear as a filter Dates are text and appear on card
-
I noticed there isn't a ton (easily found) info on the different Regex to use to trim off data. My use case was I had a file using Zip codes. Some of the Zip codes in the .xls have 92056-1234. Well, when you try to join that data to Domo's Fips to Zips Dimension you have to get rid of the dash and everything after it. The…
-
They changed it to be Plters now and not Analyzer. On the filter you created there should be a trash can (delete) you just click and that gets rid of the filter. If you no longer want the filter, then you just click the Page Options Wrench and click "Turn off Page Filters" hope that helps
-
if you want to discard the weekends you can do this too: case when DAYOFWEEK(`Call Date and Time`) in (1,7) then 'Weekend' else 'Weekday' end
-
thanks I actually did exactly that : WHEN Sum(`Returns`+ `In Yard` ) - Sum(`Committed` + `Unuseable`) < 0 THEN CONCAT('<div style="background-color:#fcbcb7; width: 100%; height:100%; margin:-20px; padding:20px"><a href="#">', Round(Sum(`Returns`+ `In Yard` ) - Sum(`Committed` + `Unuseable`)), '</a></div>')
-
This is great! I just used it and added a Sum statement to it CASE WHEN Sum(`Returns`+ `In Yard` ) - Sum(`Committed` + `Unuseable`) > 0 THEN CONCAT('<div style="background-color:#bbe491; width: 100%; height:100%; margin:-20px; padding:20px"><a href="#">', Sum(`Returns`+ `In Yard` ) - Sum(`Committed` + `Unuseable`),…