Analysis on data
Options
- Subscribe to RSS Feed
- Mark Topic as New
- Mark Topic as Read
- Float this Topic for Current User
- Printer Friendly Page
AS
8 - Asteroid
‎03-08-2022
10:51 PM
- Mark as New
- Subscribe to RSS Feed
- Permalink
Hi all,
I to analysis this data. Which activity support best in all the column. I'm thinking to use Formula tab but not sure cross tab or Summarize activity can help? I'm confused.
Account | Catergory2 | Name | Dec | Nov | Oct | Average of all months | Deviation from the Average | Delta from nov to dec | Delta from oct to nov |
10 | General | Software | 351.66 | ||||||
10 | General | Password | 239.53 | 214 | 207.9 | ||||
10 | General | UK | 168 | 16 | 171.9 | ||||
10 | Admin | Systems | 152 | 153 | 155 | ||||
10 | Admin | AA | 77 | 212 | |||||
10 | Admin | BB | 282 |
Labels:
2 REPLIES 2
22 - Nova
‎03-09-2022
01:45 AM
- Mark as New
- Subscribe to RSS Feed
- Permalink
Hi @AS
Here is how you can do it. Hope this works for you.
Workflow:
Not sure whats the calculation for Deviation from the Average
Hope this helps : )
‎03-09-2022
02:58 AM
- Mark as New
- Subscribe to RSS Feed
- Permalink
Thanks this helps a bit. 😊
