Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
5 years ago

Dynamic filter for visual based on a measure

Hi all, I have electricity invoice data for number of buildings. I am filtering on building selection to show consumption for the last 13 months against the average of all buildings. The issue is ...
lbendlin's avatar
lbendlin
Icon for Super User rankSuper User
5 years ago

Think about what you mean when you say "average of all buildings" . You can approach this in many different ways

 

- Sum of invoice value across all buildings divided by number of invoices

- average of (average of invoice values for each building based on that building's invoice sum divided by this building's count of invoices)

- monthly averages across all buildings that have invoices for that month

 

etc etc.

 

Once you decided how to calculate it the actual implementation will be straightforward.

Anonymous's avatar
Anonymous
Not applicable
5 years ago

Thanks for the reply, but I dont think I have asked my quesiton properly. My average of buildings is monthly averages across all buildings that have invoices for that month. So there will always be a value for every month. The problem is more about the buildings that doesnt have the invoices yet. So basically this question is more about limiting the x axis by shifting the 13 months window based on the recieved invoices for a specific building. Then the average consumption should just be added on top of it.