Hello!
I’ve built a pivot table in QuickSight, in which I’m calculating the min, max, avarege and mean value for each of the prices (lease rate list price and offer price). For each of the prices I wanted to show a column with the date corresponding to that price value (as shown in the image). In other words, I want to show the date that corresponds to the value of the metric. If the same value exists several times, I want to select the most recent date.
Is it possible to do this using calculated fields? What is the solution? Can anyone help me?
Thank you.
Notes:
The price metrics were being calculated in a calculated field, so these values in the pivot table appear in the last 3 columns and I’m not able to show them as in the table in the image, i.e.: price | date | price | date | … because QuickSight always puts the columns with calculated fields at the end.
Please have a look into the Sample dashboard have created in Arena . 35341-Community-Support
First am calculating minimum sales for a product at the country level .
minOver(Sales,[Country,Product],PRE_AGG)
Second step am identifying the date on which the least sales happend
ifelse(Sales={Minimum-Sales-At-Country-Product},{Order Date},NULL)
Hi @Beatriz_Lobo,
Since we haven’t heard back, I’ll go ahead and close out this topic. However, if you have any additional questions, feel free to create a new post in the community and link this discussion for relevant information if needed.
