jrtomici ⚪️

@GrantSmith I got it now. Thanks for the concise explanation!

@GrantSmith Ok, this has been great help and I understand the logic. I did all the steps but I'm hung up on the end, how do I find the sum?

@GrantSmith Hi, thanks for the in depth answer. Could you elaborate on what you mean by a Calendar data set? Also maybe could you provide a pseudo ETL to help me visualize the dataflow?

@huanlin Sorry--my table's first column is just the name of the row in the original data. It's the column whose duplicates I want removed, and to do this, I sorted by the COUNT of that column.

@huanlin In the analyzer I sorted by the first column and that worked for me.

@MarkSnodgrass follow up question: I have two cards now, each checkbox filters that filter by the new columns made in Magic ETL since both these columns can have multiple values. However, when one of these filters is used, all the checkbox options in the other filter card disappear. How can I allow both filter cards to be…

That makes a lot of sense, thank you so much. Only issue is now, if multiple filters are selected, there can be repeat rows in the table. So if the user wants a table that displays only rows that support desktop or mobile, if both those filters are selected, any row that has both desktop and mobile will now appear twice.…

Thanks for the response Mark. This filter would need to be a card used for salespeople to filter the table and create customized tables. Say a client wanted to know which packages (rows) support mobile devices. The salesperson would use the checkbox selector card to select "Mobile" and the table would display only relevant…

Hi Mark, Thanks for the answer. This card is part of a dashboard that will be accessed by various salespersons. These salespersons are not familiar with SQL and need an intuitive interface for filtering the data. The list of zip codes is not static either, the list will change depending on who is using the dashboard and…