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.
-
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…
-
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"
-
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…
-
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…
