Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi guys.
I build these two tables and I want to integrate the values, by month, from the second table into the first table, using something like the last expression (in red, not working).
Var 1(a date field) has a much lower count than Var 2 (a string field with full month names).
Is this possible? Could anyone suggest a working formula?
Thank you very much for your time.
Kind regards,
Nuno
Var1 -> | Jul-2013 | Aug-2013 | Sep-2013 | Oct-2013 | Nov-2013 | Dec-2013 | Jan-2014 | Feb-2014 | Mar-2014 | Apr-2014 | May-2014 | Jun-2014 |
Expression 1 | 123 | 248 | 217 | 32 | 4 | 4 | 3 | 5 | 6 | 9 | 7 | 6 |
Expression 2 | 0 | 60 | 23 | 1 | 0 | 0 | 0 | 0 | 0 | 1 | 0 | 0 |
Expression 3 | 0 | 4 | 0 | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 |
Expression 4 | 3 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 |
=count(total if(left(Var2,3)=month(avg(Var1)), Id)) | - | - | - | - | - | - | - | - | - | - | - | - |
left(Var2,3) -> | Jan | Feb | Mar | Apr | May | Jun | Jul | Aug | Sep | Oct | Nov | Dec |
= count(Var2) | 2289 | 2103 | 2642 | 2390 | 2162 | 2227 | 2176 | 2336 | 2662 | 2123 | 1877 | 1499 |
Please read this document:
Preparing examples for Upload - Reduction and Data Scrambling