topic Re: Group by in Search the Community

Group by

uday0994 — Wed, 14 Jul 2021 09:18:05 GMT

Below is the Example data.

Table1:

Table2:

Load

sum(d) as d,

avg(e) as e,

avg(f) as f,

count(distinct (g)) as g

resident Table1

groupby a,b,c;

drop Table Table1;

Now, I want direct field g also into the dashboard without aggregation. so when i add g into table2 and write g in group by, the d,e,f values are changing due to newly added field in group by. when i take g into seperate new table and left join with Table2, it is working for 1000 lines ,but when we go for full reload, it keeps on loading and after 4-6 hours it is failing. I have tried applymap also. Could anyone please explain me on how to achieve this.

Re: Group by

Gysbert_Wassenaar — Wed, 14 Jul 2021 10:43:13 GMT

Sounds like there are multiple g values per a-b-c combination then. So which of these multiple values of g should be used? FirstValue(g), LastValue(g), Maxstring(g), Minstring(g) ? Perhaps you can give us an example of what you're trying to achieve.

Re: Group by

uday0994 — Wed, 14 Jul 2021 12:25:14 GMT

g is a dimension. I need g field directly without applying any aggregation and also the field which we have used count(distinct(g))

Re: Group by

uday0994 — Mon, 19 Jul 2021 05:54:59 GMT

in the above aggregations only average and count of g values are changing in the front end when we write g in groupby. The sum agg values are working fine.