Sweep_The_Leg Member

@jaeW_at_Onyx I never converted it to magic 2.0, and even then, no one ended up using it anyway. kind of disappointing, but oh well :)

@nicangelica sorry i missed your reply. I'm not getting notifications when someone tags me. I managed to solve this with a number of MySQL and ETL's, but my solution takes hours to run. ending result was about 32M rows.

Totally missed that. was set to left only. Thanks!

the dataset does have ~5m rows, but i'd say this all started about 2-3 months ago. we've been using this data set for a few years, obviously its grown with transactional volume, but the cards themselves are quite simple: Current Quarter, date (not date-time), currency, filters by employee names, etc. It does have a lot of…

managed to figure it out with some joins on the dates that also brough forward the previous values. I tried ever variation i could find with PREV, and @prevValue, etc but nothing would work. all I got were errors. Any idea what version of MySQL DOMO is using? 

using MySql I was able to get to your test average of 16 for Q1 (assuming all end dates were Q1 2019). Only downside is you lose the ability to drill down to the raw data through the card. Thoughts?

Understood. testing something now, be back in a few ?

Greetings, few questions to get started: Is your Velocity calculated via a beastmode? Would you be calculating the Quarterly Average based on the current quarter we're in or are you wanting to see Averages by Quarter? I'm assuming you have some kind of date field as to when the work was completed whcih then determines your…

nope. double checked, but no permissions at all, PDP, etc. and the change in ownership was from one admin to another. 

might need an extra case statement? case when month = '2' then ((case when month = 2 then 'amount' else 0 end)-(case when month = '1' then 'amount else 0 end)) else 0 end let me know ?

Greetings, Would you default range be something like last 365 days? I have a Comparision card that while set at current year, only goes back to April 2018 and forward (set for Year over Year). 

see attached power point, i got to your 11.8. you'll have to sneek in a date operation. 

what about two groupings in the ETL? group 1 group by date, invoice, SUM of Sold Price Group 2 (grouping off of group 1) group by Date, average of Sum of Sold Price. 

gotcha, you're grouping by Date and Invoice. Sorry i missed that. I would recocommend the other suggestion about going through an ETL. 

Do you snapshot it on the same schedule, i.e. "every sunday night" kind of set up?

Good morning, I believe you could do a standard bar chart. the Y axis would be your date field, and the X, your Sold Price. Then chage the Claculation to Average. It will probably try to SUM or Count it at first. Is that what you're looking for?

actully, I as well have a weekly forecast that's done through a MS Sharepoint form, similar to a survey. whenever someone makes a mistake, we ask they resubmit their entry. I then filter out the original submission with the use of a MIN/MAX grouping in an ETL, which recognizes the first of the two time stamps and excludes…

I've had a similar delimia, and couldn't figure it out either. I've used the RANK function in an ETL, but the problem is it would flag all the 2's with the same ranking. if each entry has a time stamp, then say MIN of rank, which at least sections out your 2's, and then MIN of time stamp. there's also a lot more…

in your example for February, do you exclude all the 2's or just one of them?

that's how I was able to do it MySql. SELECT `Customer Name`, GROUP_CONCAT(`Customer States`) AS 'States' FROM `mb_test_Customer` group by `Customer Name`

yep, every card i open. 

Thanks for the info. I tried all kinds of variations and even MySQL but just can't get it to work. Anything with a time stamp after 5:00PM in my records gets converted to the next day. I'll try a beastmode and see if I can trim it down there. Idealy I always like to do as much as I can in the underlying query. Thanks again!

Like this? AcmeColoardoAcmeIdahoAcmeCaliforniaAcmeNew MexicoAcmeNew York result AcmeColoardo,Idaho,California,New Mexico,New York,

try this: SELECT `Customer Name`, GROUP_CONCAT(`Customer States`) AS 'States' FROM `mb_test_Customer` group by `Customer Name`

The message came from the connector. I tried the various changes you mentioned, but no success. I'm trying it now in MySQL. the function GROUPBY_CONCAT seems to exist because it poopulates itself like a beastmode, but whenever I drop it in, i get: FUNCTION GROUPBY_CONCAT does not exist I'll keep at it, but thanks for the…

Looks like GROUP_CONCAT isn't a recognized function on NetSuite's version of SQL. Thoughts? SELECT A. TRACKING_ID, GROUP_CONCAT (b. REGIONS) as 'REGION' FROM TRACKING_REGIONS_MAP A left join REGIONS b on a. TRACKING_ID = b. REGIONS_ID GROUP BY A. TRACKING_ID All columns of the select list & order by should have set…

Interesting. I switched to the whisker and sent it to my end user. Thanks for the info!

Ok, i just tried DOES NOT CONTAIN and used two different criteria and it worked. I switched it to CONTAINS and now i'm back to zero results. Suggestions?

There's something else going on here. when I trim down my input to <5K rows, the filters work fine with multiple conditions. Any one experiencing issues with datasets with 500K+ rows?

And i'm probably needing an OR clause. Some fields are ABC, others are DEF. Obvious workaround is creating two filters, one for each, but I was hoping to get around that. In my real dataset, I have 18 individual instances, that would group into 5 categories. I just didn't want to have to make 18 filters.