Forum Discussion

Zen's avatar
Zen
Regular Visitor
8 years ago

Graph With Dates

Hello everyone,   I am a new BI user and I have having trouble with a graph.   I have a datasheet with four columns.   Each column is named Letter 1, Letter 2, Letter 3 and Letter 4.   In eac...
Rfranca's avatar
Rfranca
Resolver IV
8 years ago

Hi, Zen
Share the link where I can download your data file to help with the solution.

 

  • Zen's avatar
    Zen
    Regular Visitor
    8 years ago

    Hello Rfranca,

     

    I can't share the excel because it includes private data but i have prepared a mini example. https://files.fm/u/nvnb8bgz

     

    Please note that the real excel has a lot more columns and more data. Also (in case it makes any difference) there are cells that are empty.

     

    I need a graph to show how many Letter's 1, 2, 3, 4 were sent for each day (in specific date may be none, in another a couple of 1's and a couple of 2's in other 3' only and so on) and if possible total Letters 1,2,3 and 4 per month.

     

    I appreciate your time and hope you are able to help with this.

  • Zen's avatar
    Zen
    Regular Visitor
    8 years ago

    Hello Rfranca,

     

    I can't share the excel because it includes private data but i have prepared a mini example. https://files.fm/u/nvnb8bgz

     

    Please note that the real excel has a lot more columns and more data. Also (in case it makes any difference) there are cells that are empty.

     

    I need a graph to show how many Letter's 1, 2, 3, 4 were sent for each day (in specific date may be none, in another a couple of 1's and a couple of 2's in other 3' only and so on) and if possible total Letters 1,2,3 and 4 per month.

     

    I appreciate your time and hope you are able to help with this.