projects count stats are incorrect

[divine-comedian]

Testing the Projects Count feature on https://stats.giveth.io/ appear to be incorrect.

Checking the count of projects we can see on the dapp it says we have 2812 listed project - but on the analytics dashboard it says we have 2914 - which one is correct? They should be the same number...

We should also add an option to "exclude externally imported projects" this would be a checkbox that would exclude projects we've imported from another app such as The Giving Block, Change.org or Endaoment.

When the box is checked we should then exclude those projects and show only Giveth projects that have been created directly on our platform

[ae2079]

@divine-comedian
As I should spend all of my capacity on the Qacc project, I can not do this issue in the next 6 weeks, so I unassigned this issue from myself

[RamRamez]

@Reshzera could you please take this issue?
cc @jainkrati

[Reshzera]

@RamRamez Sure

[RamRamez]

@Reshzera investigated and noticed that on all projects page we fetch only active projects but on analytics dashboard we fetch them all.
@divine-comedian is it ok to change the analytics dashboard to show only active projects?

[divine-comedian]

Got it, so the projects count in analytics is counting deactivated and cancelled projects..

let's go ahead and make your suggested changes @RamRamez - and rename the query header text to "Active Projects Count"

[RamRamez]

@Reshzera I've commented on your PR, it needs a tiny change, please fix it, also in analytics-dashboard please change the title of "Projects Count" to "Active Projects Count"

[divine-comedian]

@Reshzera what is the update on this issue?

[Reshzera]

@divine-comedian I didn't have seen this comment, I'm sorry. I'll fix it

[maryjaf]

@LatifatAbdullahi Can you please pick this up?

[LatifatAbdullahi]

Test Udpdate

Stage

This works as expected on Stage

The title has also been updated to Active Project Counts