As per my requirement i need to generate a report for last 30 days with of number of users for different types for action for each day.I didn’t go for cardinality since it was supported only for time-series quires, but using this i would have to make individual calls for each action. Instead i used group by(on user identity and action with granularity as one day) query and aggregate on count. This result was parsed and got the no of users for each action for each day. But over time this query became really heavy and the queries started timing out.
So i switched back to cardinality and timeseries query,but the count i receive now is different and the deviation is approximately 30-40%. Is there anything i need to do to tweak the accuracy of cardinality. Please help on this.