Fadem Member

@user001426 Thank you that was helpful! I ended up scheduling a report from my dashboard and that seems to send the image of the dashboard which is pretty neat.

@MarkSnodgrass Thank you so much! That was helpful.

I am extracting the words PTO from a long line of code. with the below beast mode: case when Right(`Entry Store`,5) = 'PTO"}' then 'PTO' end that cleans the PTO code however, when I try using the same beast mode approach as above and add more lines for other codes such as hourly I am getting a syntax error.

@GrantSmith Thank you!

@GrantSmith No, because the link asks for a login info. Would it work regardless? Thank you!!!

@mhouston My dataflow was over a million rows and by only filtering on only unique values, I was able to fix that issue. Thank you so much! @Ashleigh Thank you so much! I actually prefer to always use HTML tables but didn't know that the Mega and Pivot Tables were limiting.

@Godiepi Works! Thank you!

@MarkSnodgrass Thank you!!!

@GrantSmith Sounds great! Thank you!

Thank you guys!!!! @GrantSmith t The error I am seeing is syntax error. @MarkSnodgrass It works great! I appreciate the help!

You're awesome! Thank you!

@GrantSmith I actually have another Beast Mode that is validated in the Cards but not the ETL: My error message says function sum requires an aggregation context. Use group by action. Beast Mode: (Sum(`Amount` + `Employer_Taxes` + `Fringes`) - Sum(Case when Case when SUBSTRING(`Expense_Account`,4,2)>=75 then 'Indirect'…

@GrantSmith I was not getting an error message however, it worked after I expanded the formula editor! Thank you!

@Ashleigh Thank you! You're awesome!

@GrantSmith you're the best!

Hi @GrantSmith The sum is working now. For the department I am looking to select only certain department numbers adding those values together. Thank you!

@GrantSmith Thank you for your continues help it was a filter issue.

@MarkSnodgrass Thank you looks like it was a filter issue.

@GrantSmith I am expecting to at least get the 7 matching rows in all the other joins. I don't know why it's giving me all nulls.

Hi @GrantSmith, I am using magic ETL 1 and getting null columns on either of the two datasets I am using depending on join type when I do a left join the right data set is null and vice versa but when I do a full outer join my smaller data columns are returning null. The only join that's working is the inner join but that…

@GrantSmith You're Awesome! Thank you.

@GrantSmith Thank you so much!!! I am assuming you have magic ETL 2 because I don't see any tile that would let me use the following expression.

Yes, I have tried opening a new ETL with a different data source and pretty much got the same inconsistent results for the same input. Thank you so much Mark!