count values in timeseries list - Mendix Forum

count values in timeseries list

0

hello everyone,

I have a microflow which is doing a RESTcall and returns a time series list for the attribute  XY of an entity.

The attribute XY can only have the values 1,2 or 3.

I know want to count the number of each value and display that next to the timeseries in a pie chart.

Can somebody tell me how to do that?

 

best regards!

asked
2 answers
0

Hey Thorsten,

thank you for your help!
 

But is it possible to use the same microflow which returns the list for the ‘time series widget’ ?
Or do I have to create a new microflow?

 

best regards

answered
0

Since your attribute can only have 3 distinct values, an easy solution would be to first filter for each value, then count. Filtering a list can be done by using the microflow activity “List operation” with operation “Filter” which will return a list filtered by an attribute value (e.g. all records where xy=1). Do this three times to get all sub-lists for xy = 1, 2 and 3. Then you can use the microflow activity “Aggregate list” with Function “Count” (for each sublist you will have to do one count). 

answered