if I sample my database it still works but my data isn't reliable at all, so yes, you solution doesn't work. Filter pane doesn't work for me, I have too many dashboards and more than 20 charts depending on which product we are using, and it doesn't even have authentication and any security implemented yet, so yes not reliable practical and safe. I can't use that.
I understand my requirements would make change your solution but I think it would help a lot of customers that want to follow the same path I am following.
Another important thing is, I work at small company and I have a small database to work with (In this example only 3MM documents indexed, and not even 1 year o data) and it doesn't work, imagine this solution in medium or large company, unusable. And it doesn't make any sense to make to scale my M20 to a M30 just to make my charts work, it get too expensive and it would make more sense to go to other solutions available on the market.
if I sample my database it still works but my data isn't reliable at all, so yes, you solution doesn't work. Filter pane doesn't work for me, I have too many dashboards and more than 20 charts depending on which product we are using, and it doesn't even have authentication and any security implemented yet, so yes not reliable practical and safe. I can't use that.
I understand my requirements would make change your solution but I think it would help a lot of customers that want to follow the same path I am following.
Another important thing is, I work at small company and I have a small database to work with (In this example only 3MM documents indexed, and not even 1 year o data) and it doesn't work, imagine this solution in medium or large company, unusable. And it doesn't make any sense to make to scale my M20 to a M30 just to make my charts work, it get too expensive and it would make more sense to go to other solutions available on the market.