Forum Discussion

figo12's avatar
figo12
Helper 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
Super 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
Helper 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
    Super User
    9 years ago

    Hi figo12,

     

    You would then need to create 2 calculated measures, one for the Accumlated Sales and another for the Monthly Average.

     

    For the Monthly Average calculation you would need to decide if you need it calculated for each individual month, or just the average over the date range selected.

     

    In my opnion I would do the average based on what was selected. This is so that the range can be dynamic in nature, so that if a person selects 1 month, 2 months or even 2 weeks it will always show that as dynamic?

  • GilbertQ's avatar
    GilbertQ
    Super 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.

  • figo12's avatar
    figo12
    Helper I
    9 years ago

    Thanks GilbertQ what I am trying to achieve is the following:

     

    a. I would like to create a Monthly KPI Gauge Chart, Chart should change the monthly average amount when dashboard is filtered between different dates.

     

    b.  The goal on such chart would be to show the accumulated sales amount vs the monthly average on a certain period of time (showed as an average per month), or if it is not possible, just to show the monthly average and on another chart I would show the accumulated sales amount for the dates period.

     

    Thanks again!