Incorta
Community
Learn
Docs
Support
How to enable Javascript
Login
Sign Up
Login
Search
Home
Latest Posts
Re: Label Names for Rolling Months
Thanks @Dylan Wan - I had a feeling that was the case, but wanted to check.
Michelle Fox
Incorta User
National Oilwell Varco
Michelle_Fox
3 mths ago
Questions & Answers
Reported - view
0
Label Names for Rolling Months
I have a business view with columns that aggregate monthly usage. This is a rolling aggregation. For example, the column label "Current Month" is the current month (i.e. September).…
Michelle Fox
Incorta User
National Oilwell Varco
Michelle_Fox
4 mths ago
5
replies
49
Questions & Answers
Re: New Formula - Convert String to Double
Great @Dustin Basil ! That worked.
Michelle Fox
Incorta User
National Oilwell Varco
Michelle_Fox
5 mths ago
Questions & Answers
Reported - view
0
New Formula - Convert String to Double
Hi everyone. I'm trying to create a basic New Formula in an insight where I take a double data type and multiply it by a string data type. Since this formula won't work,…
Michelle Fox
Incorta User
National Oilwell Varco
Michelle_Fox
5 mths ago
2
replies
22
Questions & Answers
Re: Set Alert When Data Changes
@Dan Brock I'm sure we could. That leads us down the path of creating new tables for all kinds of data changes though. I was hoping there was some functionality within formulas that would be able to…
Michelle Fox
Incorta User
National Oilwell Varco
Michelle_Fox
7 mths ago
Questions & Answers
Reported - view
Re: Set Alert When Data Changes
@Dan Brock I used those. My question really is: I can't figure out what condition/trigger I should set up so that I get an alert whenever an item/part number's cost changes.…
Michelle Fox
Incorta User
National Oilwell Varco
Michelle_Fox
7 mths ago
Questions & Answers
Reported - view
0
Set Alert When Data Changes
I'm trying to set up an alert that tells me when an item/part number's cost changes. I have the dashboard built, but I can't figure out how to set an alert on the dashboard.
Michelle Fox
Incorta User
National Oilwell Varco
Michelle_Fox
7 mths ago
5
replies
54
Questions & Answers
0
Sharing Notifications - Too Many Emails
Some users are part of multiple Groups. When a schema is shared across multiple Groups, these users receive duplicate (or more) emails with the same notification.…
Michelle Fox
Incorta User
National Oilwell Varco
Michelle_Fox
8 mths ago
1
reply
21
Questions & Answers
Re: Introducing Action on Insights Webinar Series: Technical Questions, Expert Answers.
I'd like to attend the webinar, but I don't have log in information.
Michelle Fox
Incorta User
National Oilwell Varco
Michelle_Fox
8 mths ago
Events
Reported - view
Re: Sorting by Formula Not Supported in Flat Tables
@Dan Brock Will do. Thanks!
Michelle Fox
Incorta User
National Oilwell Varco
Michelle_Fox
9 mths ago
Questions & Answers
Reported - view
Re: Sorting by Formula Not Supported in Flat Tables
I don't think I can create the formula in the base table because it is taking two columns from two different staging tables. I tried it and the result was all NULL values.
Michelle Fox
Incorta User
National Oilwell Varco
Michelle_Fox
9 mths ago
Questions & Answers
Reported - view
0
Sorting by Formula Not Supported in Flat Tables
When creating formulas directly in an insight, I cannot sort based upon the result. The error message reads, "Sorting by formula not supported in flat tables.…
Michelle Fox
Incorta User
National Oilwell Varco
Michelle_Fox
9 mths ago
5
replies
43
Questions & Answers
Re: Unable to filter on insights & dashboards
I have a formula built into a Business Schema. When I try to use it as an Applied Filter on a dashboard, I get this error:
Michelle Fox
Incorta User
National Oilwell Varco
Michelle_Fox
9 mths ago
Questions & Answers
Reported - view
Re: Subtotal and total not showing up for table insight
I figured it out. When using the aggregate insight, I have to go to the individual measures, select the upside down carrot, and choose "NONE" for the aggregation.
Michelle Fox
Incorta User
National Oilwell Varco
Michelle_Fox
9 mths ago
Questions & Answers
Reported - view
Re: "If" function in New Formula
@Dan Brock I used Anurag's formula. if( and (A=B, B=C, A=C), "TRUE", "FALSE") Where A= QTY_ORDERED / B= QTY_SHIPPED / C= QTY INVOICED The actual formula is: if( and (QTY_ORDERED = QTY_SHIPPED,…
Michelle Fox
Incorta User
National Oilwell Varco
Michelle_Fox
9 mths ago
Questions & Answers
Reported - view
Re: "If" function in New Formula
Thanks! Interesting results....when I put this as an Applied Filter at the dashboard level, it works when choosing "True", but when choosing "False", no results appear even though there are…
Michelle Fox
Incorta User
National Oilwell Varco
Michelle_Fox
9 mths ago
Questions & Answers
Reported - view
0
"If" function in New Formula
I'm trying to write a formula that looks at three columns. If all three columns equal each other, then I was a result of "True". If not, the result should be "False".…
Michelle Fox
Incorta User
National Oilwell Varco
Michelle_Fox
9 mths ago
6
replies
47
Questions & Answers
Re: Unable to filter on insights & dashboards
Thanks Dustin! I might have found a way to filter, but still want to talk in case I'm missing something. Talk to you tomorrow.
Michelle Fox
Incorta User
National Oilwell Varco
Michelle_Fox
9 mths ago
Questions & Answers
Reported - view
0
Unable to filter on insights & dashboards
Our business views have columns that are formulas. For example, in our Purchase Order business view, we have a column labeled "Outstanding Quantity". This is a formula taking the quantity ordered…
Michelle Fox
Incorta User
National Oilwell Varco
Michelle_Fox
9 mths ago
3
replies
42
Questions & Answers
Re: List of Business Schema details
Thanks Dan! I just realized one of my devs built a Business Schema insight that gives it all in a nice, pretty format.
Michelle Fox
Incorta User
National Oilwell Varco
Michelle_Fox
1 yr ago
Questions & Answers
Reported - view
0
List of Business Schema details
Does anyone have any recommendations for quickly pulling all of the columns and rows inside a business schema using the GUI? For example, I have a BS that has 27 views and approx 150 columns and I'd…
Michelle Fox
Incorta User
National Oilwell Varco
Michelle_Fox
1 yr ago
3
replies
47
Questions & Answers
Incorta User
Michelle Fox
Michelle_Fox
National Oilwell Varco
Product Owner - Supply Chain Systems
Houston, Texas
23
0
1
Follow
Login
Sign Up
Home
Community
Questions & Answers
Events
Knowledge Base
Product Announcements
Learn
Help Articles
Product Videos
Introduction to Incorta (17 Videos)
How To Videos
Tags
View all tags
Product Announcement
Incorta 4.9
is now Generally Available (GA)!!!