jmmc Member

@ColemenWilson - I will try this. It's actually what I thought of as I typed out the OP. Thanks, I'll follow up if it works!

@ColemenWilson , it is the plan right now, to group the values and de-dupe there, but that will lock us into a those set aggregation fields and prevent responsive filters. After hacking, I wasn't able to get the fixed function to work as we'd like.

Thank you @ArborRose and @MichelleH - I think the key here was knowing that each unaggregated column in a table will automatically be part of the group by behind the scenes if measures are given a calculation. Thank you!

@david_cunningham this is excatly what I was looking for, this is a very powerful feature. Thank you!

@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.