cbishop Member

Comments

  • What I received from Support: The Domo Metrics DataSets have been deprecated. They have been replaced by the DomoStats Connector. You can find it in the Appstore, and bring in the same reports, and more, than the old Domo Metrics.
  • I'm experiencing this error: Access to the path 'C:\ProgramData\Domo\Workbench\Pipeline\PipelineSegments.store' is denied. However the subfolder .\Workbench\Pipeline *does not* exist. I am using Windows Authentication and my account *does* have rights to the .accdb file location. I'm using impersonation on the job as well…
  • The case provided did help however, it wasn't the exact solution i was looking for. I ended up going with the below statement for my exact need. (CASE when `Date` <= LAST_DAY(DATE_SUB(CURRENT_DATE(),interval 1 month)) then 'Include' else 'Exclude' end )
  • By the time I opened this thread, SUM(`PayTotal`) was just a troubleshooting-itteration of the case() statement I was trying to make work. I took your suggestion and modified it slightly to: case when `PayTotal` / `PayTargetWeek` <= -.05 then 'Under Target' when `PayTotal` / `PayTargetWeek` > -.05 and `PayTotal` /…
  • I also tried writing it this way but again...it will *not* resolve/validate. case when (sum(`PayTotal`) / (CASE when `PayTargetWeek` = 0 then 1 end)) <= -.05 then 'Under Target' when (sum(`PayTotal`) / (CASE when `PayTargetWeek` = 0 then 1 end)) >= -.049 and <= .05 then 'On Target' when (sum(`PayTotal`) / (CASE when…
  • Thanks for the quick response...however, this will still *not* resolve. CASE when `PayTargetWeek` = 0 then 1 ELSE case when (sum(`PayTotal`) / `PayTargetWeek`) <= -.05 then 'Under Target' when (sum(`PayTotal`) / `PayTargetWeek`) >= -.049 and <= .05 then 'On Target' when (sum(`PayTotal`) / `PayTargetWeek`) >= .051 then…
  • I am having a similar issue. I want to filter rows *only* when their value is specific (Labor). I have used "Labor", 'Labor', and Labor and each itteration nets 0 records. Please advise.