Hi,
My dataset has multiple rows a day for each entity. I would like to aggregate the entity spend by day and then calculate the average spend of a certain day in the month, the 1st day for example,
To do so I tried to create a calculated field that sums up the entity’s daily spend, meaning sum(spend,[entityid,truncDate(‘DD’,mydate))
But when i aggregate in the visualization choosing the average function, it seems to sum all the records instead of calculating the average.
Any thoughts
Thanks
Tal
Hi @tal
Based on your description what you did seems right and should work. Can you share the details of your calculated field and visualization so we can see what may be causing the problem and then comment?
Hi, i managed to calculate the needed average .
You can close this issue.
Thank you
1 Like