Granularity is the extent to which a material or system is composed of distinguishable pieces or grains. It can either refer to the extent to which a larger entity is subdivided, or the extent to which groups of smaller indistinguishable entities have joined together to become larger distinguishable entities.
Questions tagged [granularity]
63 questions
-1
votes
1 answer
Tableau desktop average line granularity error
[14 day sales trend,split by student type][1]
I was trying to plot an average line for the sales over the past 14 days. I have used average line in analytics pane for the entire table. And I have made bar chart to stacked bar chart by splitting the…
-1
votes
1 answer
best practices for protecting a production database when using entity framework
I have been helping a small to medium sized business implement a new CRM using entity framework core for sql server. They are very protective over their sql database to the point where they refuse to grant permissions to most of the tables and only…
Paul
- 693
- 1
- 10
- 25
-1
votes
1 answer
SQL Query - Two Counts Different Granularity
so I have two tables;
When Joined together (OUTER JOIN on ID) it looks like this
Now, I want to create a Query which counts all events, and their corresponding Location. Given the above example, it should look like this;
The key thing is that…
Steve
- 77
- 1
- 11