Forum Discussion

julsh's avatar
julsh
Frequent Visitor
8 years ago

Week over Week Change

  I am trying to compare the size of my Sales pipeline that is pulled from a live Sales Force Report query against the snapshots of Salesforce data I am pulling from in a different query.  At worst,...
Need Help
v-jiascu-msft's avatar
v-jiascu-msft
Microsoft Employee
8 years ago

Hi julsh,

 

I would suggest create a new date table that will contain week numbers. Then create several measures and bring the week and the measures in a visual. If you want a detailed solution, please share a dummy sample.

 

Best Regards,

Dale

  • julsh's avatar
    julsh
    Frequent Visitor
    8 years ago

    So I have one query that is collecting the data in red.  From a visual perspective, would like to add the blue "Live Data" to the same visual and then be able to calculate variance to a specified date of a previous report.  And the query with historical data will be pulling in new reports each week with the latest timestamped data.  I appreciate the help

     

    Report Date Product 1 Sales Pipeline  Product 2 Sales Pipeline  Total Pipeline  Variance To Current Product 1  Variance To Current Product 2  Variance To Current Product 2 
    2-Feb                                38,699,068                             158,017,993                             196,717,061                                                  (23,127)                                         (20,475,334)                                         (20,498,461)
    9-Feb                                38,699,068                             158,954,693                             197,653,761                                                  (23,127)                                         (21,412,034)                                         (21,435,161)
    16-Feb                                39,327,268                             158,757,853                             198,085,121                                               (651,327)                                         (21,215,194)                                         (21,866,521)
    23-Feb                                38,112,220                             159,010,328                             197,122,548                                                  563,721                                         (21,467,669)                                         (20,903,948)
    2-Mar                                38,058,220                             155,368,128                             193,426,348                                                  617,721                                         (17,825,469)                                         (17,207,748)
    9-Mar                                38,048,840                             139,675,646                             177,724,486                                                  627,101                                            (2,132,987)                                            (1,505,886)
    16-Mar                                38,521,980                             139,006,346                             177,528,326                                                  153,961                                            (1,463,687)                                            (1,309,726)
    Live Data                                38,675,941                             137,542,659                             176,218,600                                                             -                                                               -                                                               -