Skip to Content Skip to Menu

[SOLVED] Plotalot and Community builder

  • nant
  • nant
  • OFFLINE
  • Posts: 12339
  • Thanks: 1467
  • Karma: 877
10 years 6 months ago #244453 by nant
Replied by nant on topic Plotalot and Community builder

imaaxx wrote: OK i think i might be getting closer now, here is what i have created:

Code:
SELECT COUNT(*) FROM `#__comprofiler` WHERE `cb_monday`='YES' UNION SELECT COUNT(*) FROM `#__comprofiler` WHERE `cb_tuesday`='YES' UNION SELECT COUNT(*) FROM `#__comprofiler` WHERE `cb_wednesday`='YES' UNION SELECT COUNT(*) FROM `#__comprofiler` WHERE `cb_thursday`='YES' UNION SELECT COUNT(*) FROM `#__comprofiler` WHERE `cb_friday`='YES' UNION SELECT COUNT(*) FROM `#__comprofiler` WHERE `cb_saturday`='YES' UNION SELECT COUNT(*) FROM `#__comprofiler` WHERE `cb_sunday`='YES'

And im not getting any SQL errors at this time, i only get this error:

Plotalot error: This chart requires 2 columns

and for the life of me i cant figure out what to do to get this working.

Thanks for all your help so far.

Alan


Try this:
Code:
SELECT 'Monday', COUNT(*) FROM `#__comprofiler` WHERE `cb_monday`='YES' UNION SELECT 'Tuesday', COUNT(*) FROM `#__comprofiler` WHERE `cb_tuesday`='YES' UNION SELECT 'Wednesday', COUNT(*) FROM `#__comprofiler` WHERE `cb_wednesday`='YES' UNION SELECT 'Thursday', COUNT(*) FROM `#__comprofiler` WHERE `cb_thursday`='YES' UNION SELECT 'Friday', COUNT(*) FROM `#__comprofiler` WHERE `cb_friday`='YES' UNION SELECT 'Saturday', COUNT(*) FROM `#__comprofiler` WHERE `cb_saturday`='YES' UNION SELECT 'Sunday', COUNT(*) FROM `#__comprofiler` WHERE `cb_sunday`='YES'
--
Nick (nant)
Community Builder Team Member
Before posting on forums: Read FAQ thoroughly + Read our Tutorials + Search the forums
For more add-ons and support: Upgrade your membership
Links: Community Builder - Languages - Adv/Pro/Dev membership - CBSubs Paid Subscriptions - GPL Templates - Hosting

Visit my CB Profile - Send me a Private Message (PM)
The following user(s) said Thank You: imaaxx

Please Log in or Create an account to join the conversation.

  • imaaxx
  • imaaxx
  • OFFLINE
  • Posts: 126
  • Thanks: 11
  • Karma: 2
10 years 6 months ago #244454 by imaaxx
Replied by imaaxx on topic Plotalot and Community builder
Sweet that did it, you ROCK! thanks for the awesome support!

Now to play with the new toy!

Best Regards
Alan

Please Log in or Create an account to join the conversation.

  • imaaxx
  • imaaxx
  • OFFLINE
  • Posts: 126
  • Thanks: 11
  • Karma: 2
10 years 6 months ago #244455 by imaaxx
Replied by imaaxx on topic Plotalot and Community builder
OK one last thing we wanted to try with this component,
Code:
SELECT 'Earliest Start Time Weekdays', COUNT(*) FROM `#__comprofiler` WHERE `cb_earlieststarttimeweekdays`='YES'

However this field is not a Yes/NO option it is a "Select List" with several numeric options like 6:00, 7:00, 8:00 and 9:00. So what should i add instead of the "YES"

Thanks
Alan

Please Log in or Create an account to join the conversation.

  • imaaxx
  • imaaxx
  • OFFLINE
  • Posts: 126
  • Thanks: 11
  • Karma: 2
10 years 6 months ago #244471 by imaaxx
Replied by imaaxx on topic Plotalot and Community builder
OK i figured it out now, You can mark this one solved.

Thanks again for all your help!

Alan
The following user(s) said Thank You: nant

Please Log in or Create an account to join the conversation.

Moderators: beat, nant, krileon
Powered by Kunena Forum