emendoza

Comments

Have you tried splitting out the conversion and then extraction of the dates in different transforms? That might help pinpoint if it's a functional issue or if it's order of operations.

in Extracting time from datetime stamp Comment by emendoza November 2018
What do you mean by "creating 10 individual data poinst in ETL process manually"? As I understand your process, you have two different datasets (Survey Monkey datasets) that you append them together in an ETL so that you can have a single reporting source. What additional data/details are you adding on manually and why? If…

in How to compile Client Survey More Effectively? Comment by emendoza August 2018
Hello, Thank you for providing that screenshot! I see my mistake now. Try changing the 'OR's into 'AND's in the query I provided earlier and see if that works. Enoc Mendoza **Say “Thanks” by clicking the “heart” in the post that helped you. **Please mark the post that solves your problem by clicking on "Accept as Solution"

in How can I replace the empty values from one column with the unique value from a different column? Comment by emendoza January 2018
Hello, If I understand correctly, essentially you want to check to see if "Updated Budget" is either ' ' empty or NULL, if so, use the current "Estimated Budget", but if is not NULL or empty, then use the "Updated Budget" is that correct? In this case, I'd use something like this: SELECT (CASE WHEN (`Updated Budget` IS NOT…

in How can I replace the empty values from one column with the unique value from a different column? Comment by emendoza December 2017
Hello, If you want to add multiple series to a chart, the series colum itself must be aggregated in some way (COUNT, AVG, SUM, etc..), otherwise it will not allow for more series to be added. In your case, it looks like to accomplish this you'll need to bucket your data into different beast mode calculations for each of…

in Multiple Series for Symbol + Grouped Bar Comment by emendoza December 2017

emendoza Member

Comments