Forum Discussion

tl1234's avatar
tl1234
Helper I
9 months ago
Solved

Daily Average Over Multiple Years

Hello,   I've made the below visual which represents the total number people staying at our facility every day split up by year. What I need is a daily average across years (shown in red text in im...
Need Help
  • tl1234's avatar
    tl1234
    8 months ago

    Hello,

    Sorry again for the delay. Unfortunately these solutions did not work for what I wanted so I ended up doing it the way that would lose the metadata but kept the main numbers. So I ended up making a seperate query for each year grouped by the main categories we want, merging the queries together, then adding average columns. Not ideal but it worked. I'll just have to make separate visuals for the metadata.

    Thank-you,

    Tanya

MFelix's avatar
MFelix
Super User
9 months ago

Hi tl1234 ,

 

In this case you need to remove the year from the legend and then use the average in your line chart this will return what you need.

 

What is the measure you are using in the values?

  • tl1234's avatar
    tl1234
    Helper I
    9 months ago

    Hello Miguel,

    Thanks for getting back to me!

    I need to have the year in the legend to be able to get the separate columns for each year in the visual table.

    The values are a count of peoples' names who stayed with us on each day.

    I've added a couple snips below.

    Thank-you,

    Tanya