Post reply

How to get weekly and Monthly view from daily in sql server

  • May 17, 2022 at 8:49 am

    #4034163

    Hello All,

    I have a table like below.

    I need to get daily,weekly and monthly calls data from this.

    My out put would be like below

    Could any one please help what is the query to write here

     

     

    Attachments:
    You must be logged in to view attached files.

  • May 17, 2022 at 1:36 pm

    #4034310

    Please provide DDL (table definitions) & sample data as insert scripts as described in How to post code problems.

     

  • May 17, 2022 at 7:25 pm

    #4034503

    So please explain how the 1/1/2021 entry for sales of 100 gets knocked down to only 5 calls in the desired output.

    To @ratbak's point about providing DDL, please see the article at the first link in my signature line below.

    --Jeff Moden

    RBAR is pronounced "ree-bar" and is a "Modenism" for Row-By-Agonizing-Row.
    First step towards the paradigm shift of writing Set Based code:
    ________Stop thinking about what you want to do to a ROW... think, instead, of what you want to do to a COLUMN.

    Change is inevitable... Change for the better is not.

    Helpful Links:
    How to post code problems
    How to Post Performance Problems
    Create a Tally Function (fnTally)

  • May 17, 2022 at 7:57 pm

    #4034508

    What reporting tool are you using? How's your data structured?

    If you're querying against a data warehouse, I'd probably use Excel, because it provides a relatively simple UI. you can use PowerBI too... The only downside is that to do complex stuff, you have to learn DAX.

  • May 18, 2022 at 5:39 pm

    #4035133

    This can all be done in T-SQL pretty easily... we just need so reasonable data and task description to work with.

    --Jeff Moden

    RBAR is pronounced "ree-bar" and is a "Modenism" for Row-By-Agonizing-Row.
    First step towards the paradigm shift of writing Set Based code:
    ________Stop thinking about what you want to do to a ROW... think, instead, of what you want to do to a COLUMN.

    Change is inevitable... Change for the better is not.

    Helpful Links:
    How to post code problems
    How to Post Performance Problems
    Create a Tally Function (fnTally)

Viewing 5 posts - 1 through 4 (of 4 total)

You must be logged in to reply to this topic. Login to reply