Discussions

Expand all | Collapse all

mutiple choice with multiple selection, multiple X values in pie chart

  • 1.  mutiple choice with multiple selection, multiple X values in pie chart

    Posted 09-07-2018 02:41
    Hi all,

    I'm new in the platform and would like to explore several capabilities of this platform.

    Currently, I have issues in trying to manage the following issues:

    I want to be able to log multiple Serial Numbers of my battery used for an operation. (3 is used at 1 time) Hence, I could only create 3 different fields for [Battery S/N 1], [Battery S/N 2], [Battery S/N 3]

    hence in my multiple choice, there are several options.
    E.g
    001
    002
    003
    004
    005
    006
    007

    When I try to build up a pie chart, I could only choose the X- axis to either be [Battery S/N 1], [Battery S/N 2] or [Battery S/N 3]. I want to be able to build a pie chart which can evaluate the total number of hours used by each battery so I can have a clear understand which one would require maintenance, etc. 

    Additionally, I would want the system to prompt to my homepage whenever a Battery S/N reaches 50hours for example, how do I go about doing that?

    Would appreciate any help asap!

    Thanks.


  • 2.  RE: mutiple choice with multiple selection, multiple X values in pie chart

    Posted 09-07-2018 05:37
    You should have a table of Batterues
    You should have a table which records when the machine is used.
    Then the machine table needs to have a child table with the three battery Assignments used for that usage and you will lookup the hours used from the Parent Record.

    Then you can run all kinds of statistical reports.


  • 3.  RE: mutiple choice with multiple selection, multiple X values in pie chart

    Posted 09-07-2018 08:59
    Hi. Thanks for the clarifications! I've got it sorted out after reading your comment.

    Are there any ways I could set a notification to pop-up on my home screen?

    For example, if the batteries are used for a total of 30hours, a pop up appears on the home screen to notify me upon reaching the no. of hours required to send for maintenance. 

    Thanks!


  • 4.  RE: mutiple choice with multiple selection, multiple X values in pie chart

    Posted 09-07-2018 09:17
    No problem. Just make a report of batteries with excessive usage and put that report on your homepage.


  • 5.  RE: mutiple choice with multiple selection, multiple X values in pie chart

    Posted 09-07-2018 10:16
    How do i make a prompt/indication if the value goes above what i have set?


  • 6.  RE: mutiple choice with multiple selection, multiple X values in pie chart

    Posted 09-07-2018 10:47
    I've Made a simple formula to indicate certain texts,

    If([Total Flight Time]<=100, "Green", 

    If([Total Flight Time]<150,"Yellow","Red"))

    However, instead of just texts i want an image of [Red],[Green] & [Yellow]. Is that possible?

    Thanks.


  • 7.  RE: mutiple choice with multiple selection, multiple X values in pie chart

    Posted 09-07-2018 12:30
    I suggest using row colorization.

    https://help.quickbase.com/user-assis...


  • 8.  RE: mutiple choice with multiple selection, multiple X values in pie chart

    Posted 09-08-2018 08:11
    hi, how do u change between numeric(reference) and text(reference) without screwing up the existing relationship between the various sheets?


  • 9.  RE: mutiple choice with multiple selection, multiple X values in pie chart

    Posted 09-08-2018 09:39
    I suggest that you post this as a new question and explain your relationships and the field you want to change.