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

v-hjannapu's avatar
v-hjannapu
Community Support
9 months ago

Hi tl1234,

I would also take a moment to thank Shubham_rai955 , Praful_Potphode , wardy912 , MFelix for actively participating in the community forum and for the solutions you’ve been sharing in the community forum. Your contributions make a real difference.
 

I wanted to check if you had the opportunity to review the information provided. Please feel free to contact us if you have any further questions.

Regards,
Community Support Team.