Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Dear sirs
I administer a parking lot, and I wish to measure the max/min usage pr. day/hour etc.
For now I have constructed a table that counts how many cars have parked in a certain time interval (15 mins)
the formula for this is sum(count) and Period is the dimension
So - I can measure the no of cars parked on any given time.
Now i wish to create a chart that shows (with the date as the X-axis)
- average no of parked cars in every 15 min interval throuhout the day
- max of parked cars during the day (pr. 15 min interval)
- min of parked cars during the day
I have some trouble contruction the formulas for this. Can anyone throw a lifeline?
Thanks in advance.
Jesper
- average no of parked cars in every 15 min interval throuhout the day
- max of parked cars during the day (pr. 15 min interval)
- min of parked cars during the day
For this have dimension as period.
Expression;
1. Sum(Count)/ Sum(total Count)
2. Max(Count)
3. Min(Count)
You need to create a separate chart for each expression.
Thanks, I was hoping to have all expressions in the same chart.
One solution could be to calculate the max/min values in the script, I would prefer to have en expression based calcualtion though.
Jesper
No need to calculate Min/max values in the script. if we do this then reload time of script to be high.
can you please share some sample data
sure