Canary Community
Search
How to enable Javascript
Sign Up
Login
Welcome to the Community!
Search the community
Feedback
Forum
Knowledge Base
Explore & Learn
Roadmap & Releases
Home
Latest Posts
Re: Min/Max/Avg of selected section in trend chart (like we can do with delta)
@Steve Mason Thanks and done! https://helpcenter.canarylabs.com/t/p8y8x9a
James Wise
Top Contributor
wise_james
1 mth ago
Questions & Answers
Reported - view
5
Add cursor option for min/max/avg like we have for delta
The delta cursor mode is great. It would be nice if there was a way to do the same for min/max/avg. Our current workaround is using cursor mode = zoom and then clicking statistics after zooming…
James Wise
Top Contributor
wise_james
1 mth ago
15
5
Axiom
Min/Max/Avg of selected section in trend chart (like we can do with delta)
The delta cursor mode is great. Is there a way to do the same for min/max/avg? I guess one option is using cursor mode = zoom and then clicking statistics after zooming but I wanted to see if there…
James Wise
Top Contributor
wise_james
1 mth ago
2
replies
21
Questions & Answers
Answered
Answered
Total line for asset template (or for a grid using an asset type)
We used asset template and grid controls to show information for multiple assets individually and this works well. Is there a way to have a total of a column at the bottom?…
James Wise
Top Contributor
wise_james
2 mths ago
18
Questions & Answers
Re: How to set a list box to a certain selected item
@Ken Wyant Thank you! Exactly what I was looking for and worked fine.
James Wise
Top Contributor
wise_james
2 mths ago
Questions & Answers
Reported - view
How to set a list box to a certain selected item
Let's say I have a list box (ListBox1) with 2 values (Test1 and Test2) with multi-select off. It is currently showing "Test2". I know how to know what it is set to and use that elsewhere in scripting.…
James Wise
Top Contributor
wise_james
2 mths ago
2
replies
26
Questions & Answers
Answered
Answered
3
Calculation option to evaluate the calculation as of a specific date/time
We can select an asset and see the current results of the calculation but it could be helpful if there was a way to also select a date and time and see what the current calculation definition would…
James Wise
Top Contributor
wise_james
2 mths ago
15
3
Calculations & Events
4
Events Table control option to filter on property value
We have an event setup for the beginning and ending of every stop that occurs. That event is setup with a property for the stop reason. It would be nice if the events table control in Axiom had an…
James Wise
Top Contributor
wise_james
2 mths ago
26
4
Axiom
Re: Add a current time synch into the DATETIME Picker object in AXIOM
Perhaps a solution that would work for you would be to add a button control to the Axiom application with this script: public void Button1_OnClick(object sender,…
James Wise
Top Contributor
wise_james
3 mths ago
Axiom
Reported - view
Re: Flexibility in date format in Date Time Picker
Correct syntax to account for local time zone seems to work when I use this: ValueBox2.AggregateStartTime=DateTimePicker1.DateTime.ToLocalTime().ToString();
James Wise
Top Contributor
wise_james
4 mths ago
1
Axiom
Reported - view
Re: Goal: Axiom dashboard with expected quantity for week to date or other time periods
FYI: Kind of complicated but I think we got it. If anyone else has a similar need and wants to discuss, just let me know. Thanks @Steve Mason for your help!
James Wise
Top Contributor
wise_james
4 mths ago
Questions & Answers
Reported - view
Goal: Axiom dashboard with expected quantity for week to date or other time periods
What do we have: A tag that tells us when an operator is logged on or not A tag that tells us what material the machine is running at that time A file with ideal rate per material A calculation I…
James Wise
Top Contributor
wise_james
updated
4 mths ago
2
replies
46
Questions & Answers
2
Events Table Control - Option for duration column to not include milliseconds
In the Events Table control in Axiom when we include the duration column, it includes milliseconds. It would be nice if we had formatting options where we could just have hh:mm:…
James Wise
Top Contributor
wise_james
6 mths ago
20
2
Axiom
Field labels in Canary Excel Add-In difficult to read with "Dark Gray" office theme
This might be more of an MS Office issue than it is Canary where Excel doesn't use the write label text color to play nicely with the Dark Gray office theme but I noticed it looked like this (white…
James Wise
Top Contributor
wise_james
9 mths ago
1
reply
44
Bugs or Issues
Re: Connecting Canary to Power BI (version 22)
Would it be possible to get something like this written up for using Events from Canary in Power BI? I have a specific use case and have the data but am having issues transforming it.
James Wise
Top Contributor
wise_james
10 mths ago
Using Canary's APIs
Reported - view
Scripting value box property changes with an asset template
I have some controls at the top where users can select a date and shift. I have scripting on the controls to update the aggregateinterval and aggregatestarttime on some value boxes.…
James Wise
Top Contributor
wise_james
11 mths ago
2
replies
96
Questions & Answers
Re: How To Read & Write ValueBox Values To/From Script
I know you said ValueBox but in case it would help, I think this is the syntax for Text Boxes: TextBox2.Text=TextBox1.Text; I'm not sure on ValueBoxes right off.…
James Wise
Top Contributor
wise_james
11 mths ago
Questions & Answers
Reported - view
Re: Cross Reference Table to turn operator id number into name
@Steve Mason Thank's Steve, I have something setup for this now. I think there could be room for improvement but good for now and will see how it goes.
James Wise
Top Contributor
wise_james
11 mths ago
Questions & Answers
Reported - view
Re: Cross Reference Table to turn operator id number into name
@Steve Mason let's not worry about maintaining. Any thoughts on how I could join the data to have a tag that will give me the operator name based on the operator number and a lookup?
James Wise
Top Contributor
wise_james
11 mths ago
Questions & Answers
Reported - view
Re: Cross Reference Table to turn operator id number into name
@Steve Mason Yes, I was thinking I might do that. Not sure about the join though or keeping it maintained
James Wise
Top Contributor
wise_james
11 mths ago
Questions & Answers
Reported - view
Cross Reference Table to turn operator id number into name
We have a tag with the numeric employee number of the operator on the machine. We have a simple table (e.g. Excel file) with columns for that number and the employee name.…
James Wise
Top Contributor
wise_james
11 mths ago
6
replies
44
Questions & Answers
Answered
Answered
Removing commas from string values shown as numbers
I have a tag that is setup as a string but in Events in Canary shown in Axiom using an event table control, it is shown with commas. Is there a way to setup my event property calculation or…
James Wise
Top Contributor
wise_james
11 mths ago
1
reply
36
Questions & Answers
Re: Font is different on identical value box
@Steve Mason Am I correct to assume this also applies to bar charts where below for example, 2/26 and 2/28 are "dimmed" compared to 2/27 because all values for 2/27 are good but there are some "bad"…
James Wise
Top Contributor
wise_james
1 yr ago
Questions & Answers
Reported - view
Re: Axiom Script - Finding the Value of a Tag at a Given Time Using the DateTimePicker
@fxbaggio I might misunderstand the question but I would say you can find it as a control option for applications in Axiom through a web browser.
James Wise
Top Contributor
wise_james
1 yr ago
Axiom Showcase
Reported - view
Re: Scatter Plot Control (version 22)
I'm not very knowledgeable with scatter plots. Is there a good example you could give of this being used and how it could benefit customers? I've mentioned this new control to people but I haven't…
James Wise
Top Contributor
wise_james
1 yr ago
Applications
Reported - view
1
2
3
Next
Top Contributor
James Wise
wise_james
South Carolina
75
40
0
Joined: Fri Apr 02 18:46:56 UTC 2021
Follow
Home
Feedback
Issues and Bug Report
Bugs or Issues
Product Ideas and Feature Requests
Data Logging
Virtual Views
Calculations & Events
Axiom
Data Connectivity
Excel Add-in
Forum
Latest News
Axiom Showcase
Questions & Answers
Knowledge Base
Version 23
Getting Started
System Admin Duties
Client Tools
Version 22
Getting Started
System Admin Duties
Client Tools
Version 21
Getting Started
System Admin Duties
Client Tools
Explore & Learn
Upcoming Events
In-Person Events
Coaching Sessions & Webinars
On Demand Learning
RFP Common Responses
Canary Academy
Previous Coaching Sessions
Project Boot Camp
Roadmap & Releases
Roadmap
Canary System Release Notes
Ignition Module Release Notes
Distributor Release Links
View all topics
Support Center
Open a Support Ticket
View Support Ticket Status