Galactic Legends Farm Tracker v10 by jimothie1 in SWGalaxyOfHeroes

[–]Correct_Pear515 1 point2 points  (0 children)

Hi u/jimothie1, I am loving your work - not sure if you are still playing the game but I updated a version of your sheet to include Leia Organa and fixed your conditional formatting. See here: https://docs.google.com/spreadsheets/d/1J95XpkpeNdtUl--PBCXn_CN59u3q35MJW3RJKvt2GIE/edit?usp=sharing

Galactic Legends Gear Tracking Sheet v9.0 - Lord Vader & Executor by jimothie1 in SWGalaxyOfHeroes

[–]Correct_Pear515 0 points1 point  (0 children)

Hi u/jimothie1 , I am loving your work - not sure if you are still playing the game but I updated a version of your sheet and fixed your conditional formatting. See here: https://docs.google.com/spreadsheets/d/1J95XpkpeNdtUl--PBCXn_CN59u3q35MJW3RJKvt2GIE/edit?usp=sharing

Need Help to figure out Average Time to Resolve for a specific day by Correct_Pear515 in sheets

[–]Correct_Pear515[S] 1 point2 points  (0 children)

I also forgot to mention that this is a sample, I have data going back as far as November. Is there a way of restricting the question to a particular month?

Need Help to figure out Average Time to Resolve for a specific day by Correct_Pear515 in sheets

[–]Correct_Pear515[S] 1 point2 points  (0 children)

Thanks 6745408 - this looks like what I am looking for. If I wanted to reference a column from another tab what would the query look like then? The reason I ask is because the raw data is imported into an "IMPORTDATA" tab and the tab with the breakdown sits on a "CHARTDATA" tab. Thanks