Forum Discussion
Daily Average Over Multiple Years
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
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
Hi tl1234,
Glad to hear that you were able to find a solution and get it working.Thank you for sharing what you did, it will surely help others facing the same issue.Please feel free to reach out if you need any help in the future.
Regards,
Community Support Team.
