Hello,
please i need help.
How can I create a view or slices that show me data records in similar solution as in SQL?
"SELECT DISPOSITIVO, MAX(DATA) AS DATAMAX
FORM MOV
GROUP BY DISPOSITIVO"
Thank you
Grouping cannot be accomplished in Slices.
Table views and Deck views have aggregate functions (a.k.a Grouping functions) that can be used in the view itself to apply visual Grouping to your data. These aggregates could Sum, Average, Count, etc…and yes MAX is one of the functions. See image below.
If you have some other usage for the MAX values, please explain your need and we can help find a way to accomplish it in AppSheet.
What is the data type of “IDDISPOSITIVO”?
I see now, I thought you were showing some psuedo-data.
You want to Group By one column but show the MAX of another column.
No, this is not possible in AppSheet with out-of-the-box capabilities.
If you could describe how you would use this, there might be another approach that would allow you to achieve the same goal.
Ok, got it. Try this expression below. I have not tested it. Let me know if you have trouble.
IN([ID], LIST(MAXROW(FILTER(“MOVIMENTI”, [IDDISPOSITIVO] = [_THISROW].[IDDISPOSITIVO]), “Data”)))
Yes, sorry. I forgot MAXROW provides filtering capabilities. The expression should be like this:
IN([ID], LIST(MAXROW(“MOVIMENTI”, “Data”, [IDDISPOSITIVO] = [_THISROW].[IDDISPOSITIVO])))
Perfect. It works very well. Thank you very much for your help.
Great. Now I will try study your expression.