Good morning

Your viz looks really cool -  Thanks for sharing the images but you will always get a faster and more complete response by sharing the twbx workbook so we can see the data and what you are doing

I can see just the start of and LOD that finds the max of something

I think you are trying to find the location that corresponds to the max magnitude in the data by quarter

your lod needs to look by quarter by year and find the max - something like {fixed year(date),quarter(date):Max(Magnitude)}   - you may need to include event before the colon if that location by even is what you want)

then you need to compare the magnitude for each event by quarter to the max you just determined and if it matches then take the location -

          if  [magnitude] = [lod max] then [location] end

you may need to wrap that in an LOD

Since we don't have you book I could not test the formulas so yo may need to play with the syntax a bit

Jim

If this posts assists in resolving the question, please mark it helpful or as the 'correct answer' if it resolves the question. This will help other users find the same answer/resolution.  Thank you.

Hi

see the attached

this formula finds the max by year and quarter

this the locations (Place)

I don't know why you got null returns (you did not include the formula in the posted book) - the usual cause is a null in the data

in text chart form the return this

Jim

If this posts assists in resolving the question, please mark it helpful or as the 'correct answer' if it resolves the question. This will help other users find the same answer/resolution.  Thank you.

at this point I'm sure you will figure it out

Jim