Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Using a formula
SUM(
Aggr(COUNT({$<id_monitoring={'4_1'}>}DISTINCT Timestamp_of_filling), id_period,id_target,id_user,id_shop, Date)
)
I get needed numbers how many times 4_1 was filled during each day, in each shop, by each user.
Using a formula
SUM(
Rangemin(
Rangemax(
Aggr(COUNT({$<id_monitoring={'4_1'}>}DISTINCT Timestamp_of_filling), id_period,id_target,id_user,id_shop, Date)
,
0)
,
Rangemax(
Aggr(COUNT({$<id_monitoring={'4_2'}>}DISTINCT Timestamp_of_filling), id_period,id_target,id_user,id_shop, Date)
,
0)
)
)
I get the minor number of filling 4_1 and 4_2.
But how can I get the minimum number of filling many monitorings: 4_1, 4_2, 4_3, ..... 4_n on each day, in each shop, by each user using more suitable formula?
Maybe by using id_monitoring as an advanced aggregation (aggr() function) dimension?
But if I put as en expression such a code:
MIN(Aggr(COUNT(DISTINCT Timestamp_of_filling),id_user,id_shop, Date, id_monitoring))
is Straight Table with Dimensions: id_period,id_target
I will get the smallest number of filling any monitoring during any day in the period.
This result is still not good. I need the minor number of filling any monitoring during each day in the period.
And next to sum up this the smallest numbers from each day - one number from each day in the period.
Thanks for response, but I still need help.