Confiforms Table View Merger to display max value

[Deleted user]

With Table view Merger, I am able to get the total count of elements, using the expression ([count]).

Now I am trying to get the MAXIMUM value instead. 

So far I've seen the MAX function, but it only takes 2 elements and I can't see a way to apply this function to the entire group. 

Thanks in advance

[Alex Medved _ConfiForms_ · Accepted solution]

Hi

You are saying you want to display "MAXIMUM" value... sort it by this field and get the "view" to return only the 1 row.. which will be your maximum value for the field

MAX function you are referring to is not relevant here as it is applied on the row, not across the rows. And of course you can have more arguments.. actually more functions embedded if you want to have more arguments

MAX(val1, MAX(val2, val2))

But again, this is for formulas that are calculated per row / record

Alex

[Deleted user]

Sorry if I sort by fieldY, and LIMIT to 1, the thing is that I get the maximun value of every row. 

I would like to group by fieldX, add 'maximum' column and then show the maximum value of fieldY of those entries who have same fieldX.

I hope it is more clear now..

[Alex Medved _ConfiForms_]

Not sure I totally get the data model, but a simple TableView like this seems to return exactly what you need

With TableView configuration like this

Alex

[Deleted user]

Awesome! I just forgot to remove the Tableview merger. No need for sure

[Katerina Kovriga _Stiltsoft_]

Hi @[deleted] ,

We can suggest trying our Table Filter and Charts for Confluence app and its Table Filter macro.

The app works with manually created tables and is compatible with the ConfiForm tables.

Wrap your table in the Table Filter macro body and choose the column where your want to search for the maximum value:

Hope this may help your case.

[Deleted user]

Sorry, I have no chance to use your plugin. Surely it does what I need