-
Data Connector: Microsoft SharePoint Account
I'm trying to use the "Microsoft Sharepoint Account" connector to attach to an .XLSX file on our SharePoint site. The user credentials for the connector has read+write access to the site/file in question. However, the DOMO connect will not connect and I'm given a very generic error "Domo is ready, but the associated…
-
Re: microsoft sharepoint data connector
I'm trying to use the "Microsoft Sharepoint Account" connector to attach to an .XLSX file on our SharePoint site. The user credentials for the connector has read+write access to the site/file in question. However, the DOMO connect will not connect and I'm given a very generic error "Domo is ready, but the associated…
-
can i use the between operator in a case statement in a beastmode
I'm trying to write a CASE() statement in BeastMode that is similare to using the BETWEEN operator in SQL. I've tried this but BM will not validate. ( CASE when `FieldValue` <= -16 then 'Bad' when `FieldValue` > 0 then 'OK' when `FieldValue` between -1 and -15 then 'Good' else 'Ugly' end ) I've also tried this way. BM will…
-
How can I display data up to the last completed month
While at #DP18 I learned that for the sake of the "Corporate Executives" there is the ability to only display data thru the previous completed month rather than up to date. For example, my executive only wants to see, by default, revenue $ for January & February since thoses months are completed. March information would…
-
Beast Mode Case Statement Help
For some reason this CASE statement will not validate. I have all the required parts. `PayTotal` and `PayTargetWeek` are both number values and I want this field to return a character string. case when (sum(`PayTotal`) / `PayTargetWeek`) <= -.05 then 'Under Target' when (sum(`PayTotal`) / `PayTargetWeek`) >= -.049 and <=…