ConfiForm calculating within a table (and then displaying it as a diagram)

[Maximilian Herbert]

Hey there,

so this question is very specific - I will try to describe as closely as I can.

Form1 (Customer)

Form2 (Information about Hardware needs [Time, CPU, RAM, Storage])

Form1 has a Smart Multi Row pointing at Form2

In the end I bring them together via TableMerger

So it looks like this:

Customer1 | 06.02.2024| 5 CPUs | 12GB RAM | 500GB Storage

Customer1 | 05.05.2024| 10CPUs | 24GB RAM | 1000GB Storage

Customer 2 | 06.02.2024| 50CPUs | 10GB RAM| 200GB Storage

I want to display that in a Diagram (using the TabletoDiagram Macro)

Now my question is:

Is there a way to do calculations within the Table. I want to show the HWneeds cumulated so in 06.02.2024 it would be 55CPUs and in 05.05.2024 it would be 65 CPUs and not 10. So the numbers get summed up to a date. 

Greetz Max

[Alex Medved _ConfiForms_]

Hi @Maximilian Herbert 

How do you have your TableViewMerger configured at the moment? What fields are used as a grouping key?

Alex

[Maximilian Herbert]

Right now the Table View Merger is just wrapped around my Tableview to Flatten the entries of the smart multi row field. Additionally I applied some filters to only show the rows I want.

The field "Kommuliert" was a first try to do some calcualtions... right now it does nothing

Within the Tableview there is a date field (covered) that I use to get the rows sorted by date. The 3 fields "BedarfAktuell" are the values I want to accumulate across time as described above (CPU, Storage, RAM) 

[Alex Medved _ConfiForms_]

Hard to read anything when the important things are sanitized, but it looks like you have ALL the fields to participate as a grouping key

See this page https://wiki.vertuna.com/display/CONFIFORMS/TableViewMerger+macro+to+help+us+to+count+registrations+by+user

In your earlier example, first 2 fields should be as is and the other 3 should be through the [entry.field_name] to make them to aggregate and not be the part of the grouping key

Alex