I’m trying to sum rollups per item. Is that possible ?
In my relation column I have 3 items, 2 of whom are identical (Raindrops,Whiskers,Whiskers). Is it possible to sum per item ? i.e. summing Raindrops and summing Whiskers so that I have a column with only 2 values corresponding to (Raindrops,Whiskers) ?
There are a few different ways to do what youd like… first off, do you need to know how many items per month? In this case, it wouldnt just be the sum of items, but the sum of items per month. To do this, you could create a template column that joins the month and the item together into its own unique value (i.e. January-Whiskers) and then create a relation that relates that template column to itself using a multi-relation. You can then create a rollup that uses that multi-relation as the source, then sum. This will give you the sum of each item per month.
Thanks for your answer. In the end I made it work by using templates and by summing in a different table. Now I have another issue which I think is pretty simple to fix : for some reason my rollup field displays 0 in the app. Is that normal ?
It’s not obvious to me from watching that why it isn’t working as you expect.
It would be useful if you show in your video how each of the relevant columns and screen components are configured, rather than just pointing at them. Row owners would have been my first guess. Does anything change if you exit the app to the Glide dashboard and then open it again? Do you see the same thing in the published app?
If is it, then there is a good chance that is the source of your problem, as that plugin is known to be buggy - especially for non-US date formats/locales. This would also explain why it appears to work fine in the data editor, but not when you view the app.
I’d advise you to get rid of that. There is a much more reliable way to get a month name from a date, without using any plugins:
Create a text column (anywhere) and fill it with the names of the months of the year, Jan to Dec, one per row.
Create a math column using the following formula: Month(Date)-1, where Date is the column containing the date you need the month name for. This will give you a number between 0 and 11, representing the month index number of the date in question.
Now create a Single Value column. It should take “from start” the value of the math column, from the column that contains the names of the months.
Give that a try. I suspect it may solve your problem.