Forum Discussion
Utilization/ Occupancy (percentage over time) for different charging stations
Lets say, I have data with different charge stations used for last 60 days with start time and end time. I also created two calculated tables "DimDate" with dates, week, day and another table "time" which has two columns "time start" and "time end" to make 1 hour time interval each row. How to proceed with these to find utilization of different stations (percentage over time). Kindly help!
4 Replies
FreemanZSuper User
hi Anonymous
it would be easier for all, if you could also post some sample data.
For instance, it is the dataset (sample). The charge port id column has same id several times used in last 60 days. I want to find the occupancy (percentage over time) where y axis will show percentage of occupancy and x axis different charge ids in the line chart.
I have created "time" table which shows all time hourly intervals
Another table "CharginDataReshaped" was created which contains rows for each charge Id & hourly interval during which that charge id is active. When I create a measure called
Occupancy = DISTINCTCOUNT(CharginDataReshaped[ChargePoint ID]). The line chart gives me a nice curve with %occupancy, time but no information when I choose charge id (it shows 100% occupancy for any id). How can I change it so I get different percentage of occupancy for different charge ids- FreemanZ
hi Anonymous
try to bring more context, e.g. is %occupancy a measure? You mentioned three tables, how are they related?