meadow_ryan Member

just hitting preview gn_id is a number

looks like that worked...thanks

believe we got this fixed...thanks

getting the following now

=Profit is SUM(`Total Revenue` - ABS(`Total Cost`))

don't believe it ever will be, but when I add the beast mode function receive the following in the screenshot

entering as it looks in the attached screenshot and its not taking it?

I added the following to my card and the card doesn't display any data now `Total Revenue`/(sum(`Total Revenue`) over ())

how do you write the Output_dataset? thanks

yeah, that is what I'm trying to do is get a sum of that column of customer revenues so that I can get my percentage of revenue for each customer TotalRevenue/Sum of All Total Revenue's thanks

so my calculation, Total Revenue is calculiating the total revenue for each customer, but how do I total all the total revnue amounts up after that?

how do I calculate the CustomerTotalRevenue?

so I have the totals for each customer group together, I just then need another calculation for all of those totaled together....the attched screenshot shows what we did to get the total revenue for each customer, we then need all of those totaled together to get a grand total of total revenue

yes, if you could post a couple screenshots that would be great thank you

basically I need to be able to sum all the values in the total revenue column then be able to divide each on individually into that total

would I do the first calculation on the dataflow?

attached is the way I currently have it, I have an inner join between loads and dispatch, loads contains gn_id, dispatch contains the dispatchdate

so I added what you had suggested and my though was it would now in your example show the row for gn_id 1,111,111 with the max dispatchdate in this case being 5/28/19, correct?

probably would need to do it through ETL, as doing it on the card I could have a bunch of gn_id numbers which have mulitple records and would just want to pull the one with the max dispatchdate

thank you

makes sense, when I add the calculation to my card though am getting "an issue occurred during processing. We are unable to complete request at this time"

that worked...thanks for your help

I got if figured out....basically the whitespace was the whole problem...thanks for the extra set of eyes

but on my append rows preview my driver, tractor, and trailer all are on different rows if you look at the attachement

so I fixed that by adding a replace text as there must've been whitespace around my equipment type id

the only preview which shows anything is my first select columns, when I start filtering the rows by equipment_type_id = 'D' for driver, 'T' for Tractor and 'L' for Trailer nothing comes up

so I believe the card is correct now, problem I'm running into now is the data in this table has to be exported to a CSV, which is then dropping the leading zeroes.

at first glance it looks like there are just 3 rows which have bank_id's with less than 8 digits

so I changed the length to 9 but am seeing that all of the rows won't have a bank_id with 9 digits, ex. one of the id's is 123456 which is correct but the LPAD is adding 000 before it The rows which are 8 digits and are missing the leading zero are correct now

images attached...thanks again