Join the discussions about products powered by Cognite Data Fusion. Click the + CREATE TOPIC button in the menu bar to start the conversation.
Recently active
Unable to view all the values in the source field drop down for a events page in CDF UI. In the image below , for the source field drop down,over the left side, i am not able to see all the values expected . It’s showing only few values.
Hi… Knowing that there are locations (or remote locations) with limited internet access, what would be the recommended internet/network bandwidth for 5 concurrent users in order to deploy CDF with a reasonable performance?Any experience on this matter?Thanks Gustavo
Hi, can we load public data from cdf into mySQL
I am the Head of the Services delivery team in Cognite. The team I lead develops and delivers domain use cases based in CDF to our customers in O&G, manufacturing and renewables. I am going to focus here on what are the consequences of corrosion of industrial assets on the economy and the environment, as recently covered in a series of publications (see references section). The economic and environmental cost of corrosion is a significant issue and is much more severe than one could think. While several calculations methods have been used in various studies it is generally accepted that the direct costs of corrosion to the economy are equivalent to roughly 3–4% of a country’s gross domestic product (GDP) [1,2]. The main cost impact is due to the replacement of corroded steel in failing infrastructures (roads, railways, etc.) industrial equipment and buildings. As well, it has been qualitatively estimated that between 25 and 33% of the annual steel production is destroyed once in se
Question from an end user:What is the best way to calculate the percentage of good values for a time series over a year using Cognite Charts? I have a list of PSVs in various units that I need to see if we have data availability of at least 95% in 2022.
Hi,Let’s I have below data model created in FDM and there are 2 types Device and Sensor. Device is referring to other type Sensor. Device - name:String - sensors:[Sensor] Sensor - name:String - timestamp: Timestamp - value: Float I have populated the data through transformation in this model. I wanted to check on how to get the latest timestamp and value for particular device and sensor through FDM GraphQL query.Example:Device : d1Sensor:name: s1timestamp: 2023-01-01 01:00value: 10.0 name: s1timestamp: 2023-01-02 01:00value: 20.0 name: s1timestamp: 2023-01-03 01:00value: 30.0 I am expecting to latest timestamp as 2023-01-03 01:00 and value as 30.0
Hey, while performing Incremental filter operation, I am not able to get the exact filters I have applied for in the RangeStart and RangeEnd. Can someone help me out.Thanks Sharath
As communicated in this post in December, Cognite Charts is now integrated as a part of fusion.cognite.com. We are planning to retire the stand-alone url charts.cogniteapp.com to have a uniform product experience and single login. Starting February 7th 2023 you will find a message if you access the stand-alone url with instructions on how to login to fusion.cognite.com. You fill find all your charts and data intact, and Charts working as you are used to. There will be a grace period for 2 weeks after February 7th giving room for users to still access their charts from the stand-alone url if you need support to login to fusion.cognite.com. For those of you who are linking to Charts in your third party applications, Microsoft Teams, etc., this will still function as expected. We will be working on an automatic redirect for coming releases, however still recommend you update the hyperlinks to point to your-organization-name.fusion.cognite.com already now. If you have questions on this, d
Hi,Cognite grafana plugin internally use synthetic timeseies api while passing query under “time series custom query” option. but synthetic timeseries api returns error while trying to retrieve data-point for string timeseries. please check out attached screenshot.
I’m creating a new chart “speed” by calculating the absolute values from “velocity” chart. This is one of the exersie from “Cognite Charts” training course. However, the values generated from the “Absolute value” are not correct, for example, in the screenshot below, the vlaue of “Velocity” is -1.5074… but the value of “Speed” is 97.3128 .. instead of 1.5074...
Is there a way to query FDM either using sdk or rest APIs? Is there any documentation or examples available?
Hi,I have data in raw table in this format:Table1:id p1 p2 p3 1 2.0 3.0 4.0 2 10.0 15.0 20.0 I wanted to transform this details into following format through transformation id property value 1 p1 2.0 1 p2 3.0 1 p3 4.0 2 p1 10.0 2 p2 15.0 2 p3 20.0 so I have written following transformation query:SELECT id, property, valueFROM `db1`.`Table1`UNPIVOT (value FOR property IN (p1, p2,p3)) UP This query works in SQL studio, but in COGNITE transformation UI , I see below error:Mismatched input 'FOR' expecting {')', ',', '-'}(line 3, pos 15) Can you please help to understand what is missing in this?
I have a set of work orders with the following schema along with sample data for two assets (10010234, 10010235){Equipment Work Order # Order Type Start Date Start Time End Date End Time Cost}10010234 110025063 Unplanned 7/6/2018 11:31:15 7/6/2018 23:00:00 35,600 10010234 110026082 Planned 8/25/2018 12:27:15 8/27/2018 23:44:00 37,180 10010234 110027101 Unplanned 12/8/2018 13:30:15 12/8/2018 17:00:00 26,580 10010234 110028120 Unplanned 1/27/2019 14:40:15 1/29/2019 1:45:00 38,900 10010235 110023050 Planned 3/1/2018 15:57:15 3/2/2018 3:02:00 25,000 10010235 110024617 Planned 6/14/2018 17:21:15 6/16/2018 4:30:00 30,000 10010235 110026184 Planned 9/27/2018 0:25:00 9/27/2018 6:09:00 24,600 10010235 110027751 Unplanned 1/10/2019 20:30:15 1/12/2019 7:59:00 35,600 Equipment is stored as assets and the work orders are stored a
I'm sorry, I'm new to cognite and don't quite understand the basics. FDM is one specific model with data? And if I need several models (I mean models filled with data) with the same schema, then I need to create several FDMs and then transform the data into them?
How can I execute two or more different queries extracting the data from the source and inserting the data in the same CDF RAW table?Currently only the last query available in the config.yaml file gets executed.
Do Cognite OData APIs also offer have cursor implementation like cursor capabilities on REST endpoints?
Hi! I would like to check if a time series stays within a region for more than a certain amount of time. Is this possible? This would be the equivalent of inverting the “Upper lower threshold” function. Also I would need a time limit for that. Perhaps it would be a simple yet powerful addition to the existing functionality: To be able to invert the monitoring task? Some of the monitoring tasks have a time aspect, and some do not.. perhaps all should have it? Regards
When working with CDF or Azure, sometimes I got some errors that were hard to figure out. Experience no doubt will help me figure them out faster, nonetheless this is an important part in enabling usability.
Is it possible to configure in Cognite tools (like CDF & Cognite Infield) to send an email with the information on the user (to designate admin(s)), when a user trying to access the tools is restricted access to those tools, for not being part of the right security groups? Question posted on behalf of Celanese user access administrator.
We are fetching quite a lot of data from CDF, both raw and aggregated, and we have experienced error messages from Postman and Java requests when the aggregated number of datapoints are exceeding the limit (10.000), but we have yet to experience this for the Cognite Python SDK for raw data (limit 100.000). Is there an error message implemented for this intention? From the code in the SDK in GitHub it appears that if the data is exceeding the limit then it would return an empty list, which is a very dangerous return setting. Best regardsOliver
Hey community we are trying to be more active in this cognite hub page and add content consistently from a month to month basis. This will include a series of articles on alerting and monitoring as well as plans regarding where AIR is going into the future.Why Alerting?Automated alerting is an essential part of monitoring. They allow you to spot issues with equipment groups, time series, data quality, pipelines etc.But alerts aren’t always as effective as they could be. In particular, real problems are often lost in a sea of noisy alarms. In short:Alert liberally meaning its ok to spam users rather than not alert at all Make sure that the user has the complete control of how and when they want to be alertedInherent challenges in AlertingSensitivity: Overly sensitive systems cause excessive false positive alerts, while less sensitive systems can miss issues and have false negatives. Determining the correct alerting threshold requires ongoing tuning and refinement. Fatigue: The common ap
I am attempting to run the python file associated with the Data Modeling hands-on lab (https://colab.research.google.com/drive/11NdrGUzFhbwsOlKqXVfYRqu9s1DzAw4b?usp=sharing). I am receiving the same error every time the ‘plot’ function is called: “TypeError: Cannot interpret '<attribute 'dtype' of 'numpy.generic' objects>' as a data type”. After some debugging, the data seems to be in a dataframe data type. I suspect there is some version discrepancy between numpy and pandas, has anyone else seen this error? Thank you, Adam
I faced some isuees regarding connection with Azure when working with CDF. I believe there is an area of opportunity there!
Hi, In my endeavor to make a percentwise threshold in Charts: I.e. how many percent of the last week was a time series above a certain value, I stumbled on what I think is a bug.I need to divide the time the timeseries is above a threshold by the total duration of the time window. I therefore tried the “constant value”-function, and set it to one. The default granularity is then at 7 days. I can change the granularity to 1 day as in the screenshot below: However, when I change the granularity below this. Eg. 1 hour, I get the following warning: Ideally I want it to 1m or something like that, so that I have sufficient granularity to measure percentage above threshold over the course of a day.Any suggestions as to how I can fix this, or an alternative way to reach my goal?Thank you
@Savieth Aceros and @Gina Esperanza Jimenez Morales - hope you find the learning paths helpful! Are you taking part in a bootcamp as well?