topic Find max count using class function in App Development

Find max count using class function

Anonymous — Fri, 27 Apr 2018 14:56:57 GMT

I have a bar graph where my dimension is the following to make 30 min time buckets create_time

class(create_time,60*30)

My measure is

count(id)

Which will give me the totals for each time bucket and it works.

Now I want to display the highest total using the KPI chart type and for the life of me can't figure out the formula I need.

sunny_talwar — Fri, 27 Apr 2018 15:34:03 GMT

I suggest creating this in the script

LOAD class(create_time,60*30) as create_time_class

and then this

Max(Aggr(Count(id), create_time_class))

Anonymous — Fri, 27 Apr 2018 16:43:37 GMT

We're hoping to avoid that and use class as its more flexible and we could adjust the size of the buckets with out re-loading the data.

sunny_talwar — Fri, 27 Apr 2018 16:55:43 GMT

Would you be able to share a sample to play around with?

Anonymous — Fri, 27 Apr 2018 18:33:30 GMT

I'm new to this. It's an internal application and I'm unsure of other ways to share a sample.

sunny_talwar — Fri, 27 Apr 2018 21:03:55 GMT

Mock up data which is close to your real scenario

Anonymous — Fri, 27 Apr 2018 21:18:06 GMT

Oh. Very simply broken down the following table has create time in seconds.

ID,CREATE_TIME
1,0

1,60

2,1800

3,3600

4,3601

5,3602

It should results in a graph that has 2 in the first column, 1 in the second and 3 in the third.

The KPI should display the maximum count for those buckets in this case 3.