Comments
-
@DavidChurchman this is a great idea, thank you. I believe with these two approaches, the idea can be accomplished!
-
@DavidChurchman thank you for the input, that suggestion might well be what is done. But it is not quite what I had in mind. Here's a full mock up. So you can see that there will be one input data set with different sections. The challenge is to be able to carve out a subsection of each section and then calculate percent…
-
@Ashleigh thank you for the input. I think this definitely helps, but I'm not sure how I could apply different filters to the rows that are calculated in the Fixed aggregate and the rows that are calculated in another aggregate. The fixed function seems to let you calculate aggregates from two different fields on the same…
-
Thank you @ColemenWilson
-
Thank you Mark! I appreciate the response.
-
@MattBell, thanks for the input. I'm not familiar with using views, so I was curious if they would be a performance boost compared to ETLs. My understanding is that the view would be processed as needed, meaning the joins would occur on the fly when the dashboard is viewed. So I was wondering if that processing time, when…
-
@GrantSmith thank you!
-
Hi @RobSomers and @GrantSmith , thank you for the feedback. I'll investigate these options. Curious, have either of you used data fusion? Would it fit this use case?
-
@MichelleH that is a good idea. I'll have to explore that possibility. After reading the documentation, I'm wondering if data fusion is an option.
-
Hi @MichelleH , thank you for the information. I'm combining about 17 data sets that have 1 million rows each. My thought is that Magic ETL 2 fits the use case most.