Advance Capstone : 2.5 need help

Community Support
1

I tried to add below attributes in the sensor table but I’m still struggling to bring down the runtime of .viz.createDashboard

 

system"l ",getenv[`AX_WORKSPACE],"/AdvancedCapstone.Setup/dbmaint.q" setattrcol[`:.;`sensor;`lapId;`g] setattrcol[`:.;`sensor;`sensorId;`g]

 

c | t f a -----------| ----- date | d sensorId | s g time | t lapId | j g units | s sensorValue| f session | s

Please help.

2

  

3

You might be better off with a p attribute

c | t f a -----------| ----- date | d sensorId | s p time | t lapId | j units | s sensorValue| f session | s

4

Thank you so much for the help, it worked.

quizItem success description error ------------------------------------------------------------------------------------------------------------------------------------------------------------------ exercise2.1 Pass “check if race day in process” “” exercise2.1 Pass “have correct schema” “” exercise2.2 Pass “check if lap table in process” “” exercise2.2 Pass “only contains data for 2nd Jan 2020” “” exercise2.2 Pass “contain all columns for 2nd Jan 2020” “” exercise2.3 Pass “not allowed to use select keyword” “” exercise2.3 Pass “return correct values for temp” “” exercise2.3 Pass “return correct values for wind” “” exercise2.3 Pass “return correct values for all” “” exercise2.4 Pass “when given the wrong option return error "<mysensor> is not a valid option for mysensor - valid options include temptyrewindall"” “” exercise2.5 Pass “func should return same result as before” “” exercise2.5 Pass “.viz.createDashboard should run in half the time”