Hello,
I have a several (20) stations. Each stations reports its status every hour (string value OK or "ERROR"). - so, it´s 1:M relations - 1 stations, many status records.
To get data to one table I made relationship table (right join).
I am trying to make an Insights summary where would be a day, station number/percentage of OK statuses in a field and then percentage/number of ERROR statuses in another.
And then I would need to filter only those stations with number of errors higher then 20% per day.
The problems are:
1) The problem is that Calculation does not contains function for COUNT calculation of string field. So cannot add these filed to Summary table. The Summary table create a Count field, but it´s just one filed which do table in format:
Day, Station ID, Value, Count
Monday, 111 OK 22
Monday 111 ERROR 2
And not table like
Day, Station ID, Count category OK, Count category ERROR
Monday, 111 22 2
With which further calculations of percentage per day per status could be done.
2) The stacked bar chart does not subdivide data per day - so if I have data for month (30 days) the stacked bar chart summarize all data and there is no way how to filter stations with number of errors higher then 20% per day.
Does anyone face the similar problem, or is there different attitude which would solve this? If so, any idea is welcome.
Thank you.
