Hello Pigment team,
I am trying to build a simple table that shows All-Time-High result based on the report.
As shown below, there are multiple segments (No Sales, Core I, Core II, etc) and each reached highest (i.e. max) in different period (highlighted in yellow.
Based on Period Type: Actual only, I would like to show 1) highest number for each segment and 2) highest date. I assume i need to create two different metrics and combine in a table. Is my approach right?
The table setting would be something like this:
(Please note, the values below will not match with the values above highlighted cells)
