JosephGalvin
Data Storage
Joined 4 years ago
User Profile
User Widgets
Contributions
Build function on custom table not working.
I have attempted, in the data source section of an elasticube/dashboard to build with changes only on a custom table (green). After 8 hours, the custom table continues to show "unbuilt changes" and at various intervals a separate table (brown) shows no data. Rather "query error" noting no such table. The table name has parts of the new custom table name, however, includes additional "A"s in the name. The formula does not have these additional "A"s. Is there an exact source to find the correct way to build with changes only for a custom table? Being informed it is in a sisense video has not been successful to locate the appropriate steps. Thank you.1.2KViews0likes0Comments"Where" Function
Can the "where" function be used in a lookup formula to limit the rows looked at to only result in values that are not null or only a specific value or partial value? I am attempting to use a lookup formula, where the value being used to look up appears more than once in the table. I am expecting to capture the resulting value only if the resulting value is not null. Thank you.2.5KViews0likes3CommentsLookup Limited to Rows without a Null Value
Is there a method or formula to use a lookup, but only obtain the first instance that has a real value, and not a null (n/a) value? In addition, is there an explanation manual available of formulas which a person with no IT skills can use to understand how to fix formulas?946Views0likes0CommentsLookup Formulas referencing one table
Lookup([RaaS_CurrentStaffingReport 1],[Last Hire Date],[Sisense Employee Number],[Employee Number]) Is it possible to use a lookup formula to find and show data within the same table? If not, what would the correct formula be? The above shows no data. There is source data. Thank you922Views0likes0CommentsFormula not producing correct results
I am attempting to replace a value of N/A with another field in a table. I continue to receive the value of "N/A" which is in the "Working Title" field with the formula below. Is this the appropriate formula? The actual value that appears in the working title field is "N/A". The value is blank in the source software. Thank you. I have tried "is null" and other long if formulas. case when [Working Title]=tostring('N/A') Then [Job] end1.2KViews0likes1Comment