Pull Data From One Column Based On Condition From a Different Column
I've been at this for a while, Magic ETL, Analyzer, Google, nothing seems to answer the following (maybe it's because I'm new)
I can't seem to find a means to pull data from a numerical column based on the condition of a categorical column without aggregating as a sum. Could anyone help me with this without changing the values from the numerical column?
My table is like the following:
|Column A||Column B||Date|
And I want to turn it into the following:
I'm trying to use the advanced comparative gauge tool in the Analyzer.
Any tips or ideas, I am all ears *ahem* ...eyes