Setting a minimum number of rows when grouping, combined with time slicer

[mrtn]

Hi!

I have grouped data, and want to plot the average for each group. For a given group, I do not want to plot the average if the number of rows is less than a given value, say 100. 

In addition, I want to use a time slicer, such that the user is able to update the plot for a given time range.  Using summarizecolumns() hence does not work, as it outputs a static table. 

My data has three columns, 1) Timestamp 2) Value 3) Group. The number of groups is high, such that manual operations should be avoided. 

Any ideas?

[v-juanli-msft]

Hi @mrtn

Let me confirm your requirements:

For example:

For group a, it's "value" field has 40 rows (less than 100), so we don't plot the average of group a.

Right?

Best Regards

Maggie

[mrtn]

Hi again, 

I think the issue could be resolved by changing the ouput of the summarizecolumns columns command to be a non-static table. I believe this could have other uses as well. 

@v-juanli-msft 

Regards, 

Morten 

[mrtn]

@v-juanli-msft, you are correct.

I do not want to plot the averages when the number of rows is less than say 100, as I think the estimates will be too noisy. I may want to use the same logic when plotting standard deviations or other statistical measures.