Forum Discussion

CatheeCathee's avatar
CatheeCathee
Qrew Cadet
8 years ago

Hi! Can you help me? How Can I count the Text Data form another table????

I need to have monthly plan..

I have Yearly plan and in yearly plan I have 

YEARLPLAN

Company ABC - AA, BB and CC Group
Company CDE - CC,DD and EE Groups
Company EFG - EE,FF,GG Groups
Date of Visits-- April, may, June etc 2017 (this may vary)


All I need to do is make monthly plan

For Example
April 2007
Company only - "NUMBER OF GROUPS"

How can I do it?

Thanks for your help

50 Replies

Sort By
  • GauravSharma3's avatar
    GauravSharma3
    Qrew Commander
    8 years ago
    If you are using a summary report then, you can group your rows by year.
  • CatheeCathee's avatar
    CatheeCathee
    Qrew Cadet
    8 years ago
    thanks. but how can I make it that the company only will show.. not the groups
    • GauravSharma3's avatar
      GauravSharma3
      Qrew Commander
      8 years ago
      You have to choose company field here or if you are trying to filter the company then you can select the filter option.

      Can you please tell me the names of the fields or post a screenshot of report setting if possible?
    • CatheeCathee's avatar
      CatheeCathee
      Qrew Cadet
      8 years ago
      and when I tried to make summary report only 1 quarter will be summarized
  • CatheeCathee's avatar
    CatheeCathee
    Qrew Cadet
    8 years ago
    HI!



    How can I also write multiple dates.. for example for this company i WILL BE VISITING IT FOR 4 TIMES A YEAR
  • CatheeCathee's avatar
    CatheeCathee
    Qrew Cadet
    8 years ago
    in one company i might have 1-24 visit every year..

    for example form ABC Company... Ill visit them January, April, July and also October.. how can I input multiple dates so it can be summarized by monthly quarterly or yearly
    • CatheeCathee's avatar
      CatheeCathee
      Qrew Cadet
      8 years ago
      Yes I do have a table with visit frequency.. but I have different fields each visits and i can summarize on the field with 1 date
    • GauravSharma3's avatar
      GauravSharma3
      Qrew Commander
      8 years ago
      That's the main problem. You can only summarise with one field.

      It seems there is so much confusion here. If you can share your screen or take a call then, I am able to assist you better.
  • MCFNeil's avatar
    MCFNeil
    Qrew Captain
    8 years ago
    My 2 cents for this would be to make the "visits" a child table.  Then just have a "date" field, and you can have multiples, then build many different types of reports based on the date and grouped how you'd like.
  • CatheeDimayuga's avatar
    CatheeDimayuga
    Qrew Trainee
    8 years ago

    for example.. I have to visit 1 company with many groups...

    Group A- January , May, August and December

    Group B, Feb, april, July, Nov..


    and then many companies in a year.. around 100 companies

    • GauravSharma3's avatar
      GauravSharma3
      Qrew Commander
      8 years ago
      I assumed that you have created three tables:

      1. Companies
      2. Groups
      3. Visits 

      1 company has many Groups

      Company 1

      >Group 1
      >Group 2

      Company 2

      >Group1
      >Group 2
      >Group 3

      Then, you can create a visit where you can select the company and groups (it will be dependent on the company) and select a date of your visit.

      Thanks,
      Gaurav
    • CatheeDimayuga's avatar
      CatheeDimayuga
      Qrew Trainee
      8 years ago

      What time are you available Mr. Guarav?


      Best Regards,

      Catherine


    • CatheeDimayuga's avatar
      CatheeDimayuga
      Qrew Trainee
      8 years ago
      Yes I do have those tables how ever the 3rd one maybe the wrong structure