Forum Discussion

figo12's avatar
figo12
Icon for Helper I rankHelper I
9 years ago

Monthly Average from Daily Date Values

Hi, I am having trouble getting the monthly average from individual  date values, data is structured as follows:   Date  /  Sales Total 01/01/2017 / 2000 01/02/2017 / 1000 etc   I already trie...
Need Help
GilbertQ's avatar
GilbertQ
Icon for Super User rankSuper User
9 years ago

Hi figo12

 

If I understand you should be able to consolidate all your sheets into one dataset, which will then mean that you now have got one Date field in your data, in which you can then map to your Date Table.

 

In order to consolidate all the sheets, you would do this in the query editor, and possibly either use the Folder Source, or use the Append function to put them into one dataset?



figo12's avatar
figo12
Icon for Helper I rankHelper I
9 years ago

Hi GilbertQ yes sorry I already have that,  what I am looking is just a measure that will accomplish my goal, I already have a date value related to all tables, and created a month id for each date, there must be a way to achieve this on a measure.

 

It is the same data sheet, single excel file, it is just like 20 pages on same excel file.

 

 

  • GilbertQ's avatar
    GilbertQ
    Icon for Super User rankSuper User
    9 years ago

    Hi figo12

     

    If that is the case you can then simply use the measure I provided earlier?

     

    And then on your Axis put in your Month and on the Values put in the Calculated Measure. That will then give you the average for each month.

    • figo12's avatar
      figo12
      Icon for Helper I rankHelper I
      9 years ago

      Thanks GilbertQ that would work fine, but what I am trying to implement is the KPI Gauge chart (sorry for been such a difficult case).

      • GilbertQ's avatar
        GilbertQ
        Icon for Super User rankSuper User
        9 years ago

        hi figo12

         

        Ok so you are wanting to compare the daily value to the average?

         

        And then based on that have another calculation which you can show on a KPI Guage?

         

        And no problem, better to ask questions to find the result you are after.