Schedule view

Frequent Visitor
11044 Views
Moderator boefraty
Moderator

Re: Schedule view

Hi @numbersei

Sorry for delay in reponse. Do you still need help to your project? 

To your question datetime_start is a typo in code. Luckily it was ignored by ggplot because aes is replaced. 

Moderator boefraty
Moderator

Re: Schedule view

Hi @C_Houghton

 

You certainly can use ggplot functionality to get the required feature. 

BTW,  @fathomson implmented R Custom Visual on the basis of this show case. 

It is still available here

 

As a quick and dirty "hack" to your problem you may try to add two zero-length resources at the beginning and the end of the day. 

 

 

C_Houghton Frequent Visitor
Frequent Visitor

Re: Schedule view

Thanks for your reply! That would be absolutely perfect, but i'm getting errors:

 

Feedback Type:
Frown (Error)

Timestamp:
2017-10-23T07:56:28.6198256Z

Local Time:
2017-10-23T08:56:28.6198256+01:00

Product Version:
2.47.4766.801 (PBIDesktop) (x64)

Release:
June 2017

IE Version:
11.608.15063.0

OS Version:
Microsoft Windows NT 10.0.15063.0 (x64 en-GB)

CLR Version:
4.6.2. or later [Release Number = 460798]

Workbook Package Info:
1* - en-US, Query Groups: 0, fastCombine: Disabled, runBackgroundAnalysis: True.

Peak Working Set:
386 MB

Private Memory:
271 MB

Peak Virtual Memory:
33.8 GB

Error Message:
R script error.
Loading required package: ggplot2
Loading required package: grid
Loading required package: gridExtra
Warning message:
package 'gridExtra' was built under R version 3.4.2
Loading required package: wesanderson
Warning message:
package 'wesanderson' was built under R version 3.4.2
Loading required package: RColorBrewer
Loading required package: dplyr
Warning messages:
1: In library(package, lib.loc = lib.loc, character.only = TRUE, logical.return = TRUE, :
there is no package called 'dplyr'
2: In libraryRequireInstall("dplyr") :
*** The package: 'dplyr' was not installed ***
Error in `levels<-`(`*tmp*`, value = if (nl == nL) as.character(labels) else paste0(labels, :
factor level [2] is duplicated
Calls: sortDataset -> factor
Execution halted


User ID:
db15c5fa-a129-4ae0-ba08-f5149b97bbcb

Session ID:
89517680-55f3-4784-b47f-0655edbd950b

Telemetry Enabled:
True

Model Default Mode:
Import

Snapshot Trace Logs:
C:\Users\ch1\AppData\Local\Microsoft\Power BI Desktop\FrownSnapShot293130851.zip

Performance Trace Logs:
C:\Users\ch1\AppData\Local\Microsoft\Power BI Desktop\PerformanceTraces.zip

Enabled Preview Features:
PBI_Snowflake
PBI_shapeMapVisualEnabled
PBI_EnableReportTheme
PBI_allowBiDiCrossFilterInDirectQuery
PBI_pivotTableVisualEnabled
PBI_numericSlicerEnabled
PBI_daxTemplatesEnabled
PBI_relativeDateSlicer
CustomConnectors

Disabled Preview Features:
PBI_SpanishLinguisticsEnabled
PBI_PbiServiceLiveConnect

Disabled DirectQuery Options:
PBI_DirectQuery_Unrestricted

Cloud:
GlobalCloud

Time:
Mon Oct 23 2017 08:55:49 GMT+0100 (GMT Summer Time)

Client Error Code:
ServiceErrorToClientError

Error Details:
R script error.
Loading required package: ggplot2
Loading required package: grid
Loading required package: gridExtra
Warning message:
package 'gridExtra' was built under R version 3.4.2
Loading required package: wesanderson
Warning message:
package 'wesanderson' was built under R version 3.4.2
Loading required package: RColorBrewer
Loading required package: dplyr
Warning messages:
1: In library(package, lib.loc = lib.loc, character.only = TRUE, logical.return = TRUE, :
there is no package called 'dplyr'
2: In libraryRequireInstall("dplyr") :
*** The package: 'dplyr' was not installed ***
Error in `levels<-`(`*tmp*`, value = if (nl == nL) as.character(labels) else paste0(labels, :
factor level [2] is duplicated
Calls: sortDataset -> factor
Execution halted


Stack Trace:
Microsoft.PowerBI.ExploreServiceCommon.ScriptHandlerException: R script error.
Loading required package: ggplot2
Loading required package: grid
Loading required package: gridExtra
Warning message:
package 'gridExtra' was built under R version 3.4.2
Loading required package: wesanderson
Warning message:
package 'wesanderson' was built under R version 3.4.2
Loading required package: RColorBrewer
Loading required package: dplyr
Warning messages:
1: In library(package, lib.loc = lib.loc, character.only = TRUE, logical.return = TRUE, :
there is no package called 'dplyr'
2: In libraryRequireInstall("dplyr") :
*** The package: 'dplyr' was not installed ***
Error in `levels<-`(`*tmp*`, value = if (nl == nL) as.character(labels) else paste0(labels, :
factor level [2] is duplicated
Calls: sortDataset -> factor
Execution halted

 

Any insights off the bat? Or I can follow it up with the creator.

 

Thanks again

Moderator boefraty
Moderator

Re: Schedule view

Hi @C_Houghton

 

*** The package: 'dplyr' was not installed *** 

 

Try to install it manually from RStudio

 

> install.packages("dplyr") 

 

C_Houghton Frequent Visitor
Frequent Visitor

Re: Schedule view

Hi there,

 

I installed that package - looks slightly better:

 

Error Details:

R script error.

Loading required package: ggplot2

Loading required package: grid

Loading required package: gridExtra

Warning message:

package 'gridExtra' was built under R version 3.4.2

Loading required package: wesanderson

Warning message:

package 'wesanderson' was built under R version 3.4.2

Loading required package: RColorBrewer

Loading required package: dplyr

 

Attaching package: 'dplyr'

 

The following object is masked from 'package:gridExtra':

 

    combine

 

The following objects are masked from 'package:stats':

 

    filter, lag

 

The following objects are masked from 'package:base':

 

    intersect, setdiff, setequal, union

 

Error in `levels<-`(`*tmp*`, value = if (nl == nL) as.character(labels) else paste0(labels,  :

  factor level [2] is duplicated

Calls: sortDataset -> factor

Execution halted 

Moderator boefraty
Moderator

Re: Schedule view

Hi, 

Make sure Dates are not hierarchies and no summary applied on other fields. 

You welcome to send me the PBIX and I'll have a look . 

boefraty @  microsoft  .  com