![]() They operate on the table you see in the view much like those from spreadsheet calculators. Want to total across the row or column, rank a dimension, or pick out a single value? Then you need a Table Calculation! But how? Table Calculation Basics Table calculations should feel familiar. All the data in the data table and available for use in any type Table Calculations – When, Where and How ![]() They may sound like different problems but the solutions are very similar and require joining base data with a date scaffold or to a copy Sets and Set Action Use Casesĭo you use sets? If not why not? Sets are not like Groups or Filters: Sets categorize your entire data set into 2 segments – Records are either "In" or "Out" based on the value of a single dimension. Occupancy and Turnover Rates and Lost customers We see a lot of questions on the Forums on calculating occupancy and turnover rates or scheduling meeting rooms and identifying lost customers. A good Use Cases – Occupancy, Turnover, Lost Customer and Schedule Availability Analysis ![]() Recently, we've seen many questions on the Forums on Grand Totals and Sub-Totals – how they are calculated, when to use them or another approach to get totals, how to sub-total some – but not all of the measures – what to do when they return an unexpected result.
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |