Count of Store based on dates

[sunil-kumar5]

Hello Everyone,

I have Three Tables tables User Master,Store and Store activity.

User Master -  UserID, Name, joining date etc means all employee related information.

Store -  UserID, StoreID, Store created Date, store code etc

Store Activity- Store ID, UserID, ActivityPerformDate, ResponseID, etc

So , I have to create a count in a table where total activity count should come basis on date range , suppose user select the date range of last ten days through filter. Now Activity count should show for last ten days where new store is created only in last ten days (Store created date can be used to check this)

Not sure if I was able to make you understand but looking for your responses.

Thanks

[abhijitnalekar]

Hi @sunil-kumar5 ,

Is it possible to share the data?

[sunil-kumar5]

Hi,

Actually I am not supposed to share the data, just wanted to check whatever the user selected in date range, the newly added store activity count should present the data based on user date selection.

Thanks