Hi!
I’m using QuickSight for the first time. My question is this: I have daily inventory balances. That is, day x the balance is 300, for example, and if day x+1 there was no entry or exit, the quantity is still 300. So the current balance is 300. I want to produce a table that shows the current balance on the selected date , without adding the sum. What is happening is that when you select a period, QuickSight sums up the daily balances. How to remove this aggregation or the relative dates filter to consider only the final day of the selection?
you can do a lastValue.
lastValue({inventory_balance},[ {date} ASC])
Thanks for answering. Your solution is good. However, the table will not display the date, but categories, through the date filter, will display the day’s balance. If the user selects a period, the table should display the last day of the relative dates. Attached, an image of how it is and how I would like it. The balance column is aggregating the sum of days, and the datetime column is the balance of the last day in which I applied the “periodToDateSum(balance, dtmovement, DAY)” function. However, this function only works for the current day. If I group by month, in the same way, there will be aggregation by sum.
Can you take the avg instead of a sum? The avg should only be one day right?