Dashboard setup

[GFC]

Hello

I would like to know if the ES chart can be resized and colored to make it personalized and more aesthetic in the dashboard.

I would also like to know how to make a bar dashboard where the bars are categories and these are divided into other categories. Likewise, I know that I can use the stack bar type, but my report is Non Elasticsearch because the information is taken from an analytic.

Something like that:

Thanks in advance 

[rushikeshvartak]

You can use elastic search report and stack bar to achieve your requirements 

[GFC]

Stack bar doesn't have ES option

I am not clear how to set the Dashboard Query because the query we use is:

select count(username), HR source,  Customproperty_status from users group by HR source, Customproperty_status

Results example:

Amount of user    HR Source      Customproperty_status
10                              Source1              Active
20                             Source1              Inactive
15                              Source2              Active

5                                Source2              Terminated

[rushikeshvartak]

Query select (select count(*) from campaign where campaign_type=2 and status=7) as totalCount, 'User Manager' as xAxisPoint, 'Expired' as objectType from dual union
select (select count(*) from campaign where campaign_type=2 and status=6) as totalCount, 'User Manager' as xAxisPoint, 'Discontinued' as objectType from dual union
select (select count(*) from campaign where campaign_type=2 and status in (1,5)) as totalCount, 'User Manager' as xAxisPoint, 'In Progress' as objectType from dual union
select (select count(*) from campaign where campaign_type=2 and status=2) as totalCount, 'User Manager' as xAxisPoint, 'Completed' as objectType from dual union
select (select count(*) from campaign where campaign_type=2 and status=8) as totalCount, 'User Manager' as xAxisPoint, 'Launching' as objectType from dual union
select (select count(*) from campaign where campaign_type=2 and status=4) as totalCount, 'User Manager' as xAxisPoint, 'Preview' as objectType from dual union
select (select count(*) from campaign where campaign_type=1 and status=7) as totalCount, 'Entitlement Owner' as xAxisPoint, 'Expired' as objectType from dual union
select (select count(*) from campaign where campaign_type=1 and status=6) as totalCount, 'Entitlement Owner' as xAxisPoint, 'Discontinued' as objectType from dual union
select (select count(*) from campaign where campaign_type=1 and status in (1,5)) as totalCount, 'Entitlement Owner' as xAxisPoint, 'In Progress' as objectType from dual union
select (select count(*) from campaign where campaign_type=1 and status=2) as totalCount, 'Entitlement Owner' as xAxisPoint, 'Completed' as objectType from dual union
select (select count(*) from campaign where campaign_type=1 and status=8) as totalCount, 'Entitlement Owner' as xAxisPoint, 'Launching' as objectType from dual union
select (select count(*) from campaign where campaign_type=1 and status=4) as totalCount, 'Entitlement Owner' as xAxisPoint, 'Preview' as objectType from dual union
select (select count(*) from campaign where campaign_type=5 and status=7) as totalCount, 'Role Owner' as xAxisPoint, 'Expired' as objectType from dual union
select (select count(*) from campaign where campaign_type=5 and status=6) as totalCount, 'Role Owner' as xAxisPoint, 'Discontinued' as objectType from dual union
select (select count(*) from campaign where campaign_type=5 and status in (1,5)) as totalCount, 'Role Owner' as xAxisPoint, 'In Progress' as objectType from dual union
select (select count(*) from campaign where campaign_type=5 and status=2) as totalCount, 'Role Owner' as xAxisPoint, 'Completed' as objectType from dual union
select (select count(*) from campaign where campaign_type=5 and status=8) as totalCount, 'Role Owner' as xAxisPoint, 'Launching' as objectType from dual union
select (select count(*) from campaign where campaign_type=5 and status=4) as totalCount, 'Role Owner' as xAxisPoint, 'Preview' as objectType from dual union
select (select count(*) from campaign where campaign_type=6 and status=7) as totalCount, 'Service Account' as xAxisPoint, 'Expired' as objectType from dual union
select (select count(*) from campaign where campaign_type=6 and status=6) as totalCount, 'Service Account' as xAxisPoint, 'Discontinued' as objectType from dual union
select (select count(*) from campaign where campaign_type=6 and status in (1,5)) as totalCount, 'Service Account' as xAxisPoint, 'In Progress' as objectType from dual union
select (select count(*) from campaign where campaign_type=6 and status=2) as totalCount, 'Service Account' as xAxisPoint, 'Completed' as objectType from dual union
select (select count(*) from campaign where campaign_type=6 and status=8) as totalCount, 'Service Account' as xAxisPoint, 'Launching' as objectType from dual union
select (select count(*) from campaign where campaign_type=6 and status=4) as totalCount, 'Service Account' as xAxisPoint, 'Preview' as objectType from dual

[GFC]

Hi @rushikeshvartak 

That Query without the "Query Select" at the beginning was used in the Dashboard Query field when creating the stack bar chart in Dashboards?

[rushikeshvartak]

Yes

[GFC]

Thanks @rushikeshvartak 

It makes a lot of sense. I am using the data from the users table

Are you using the Stack Bar Chart type? I have tried but it does not complete the Chart Properties with {}

select (select count(*) from users where customproperty#="HRSOURCENAME1" and CUSTOMPROPERTY#="Terminated") as totalCount, 'HRSOURCENAME1' as xAxisPoint, 'Terminated' as objectType from dual union
select (select count(*) from users where customproperty#="HRSOURCENAME1" and CUSTOMPROPERTY#="Active") as totalCount, 'HRSOURCENAME1' as xAxisPoint, 'Active' as objectType from dual union
select (select count(*) from users where customproperty#="HRSOURCENAME2" and CUSTOMPROPERTY#="Terminated") as totalCount, 'HRSOURCENAME2' as xAxisPoint, 'Terminated' as objectType from dual union
select (select count(*) from users where customproperty#="HRSOURCENAME2" and CUSTOMPROPERTY#="Active") as totalCount, 'HRSOURCENAME2' as xAxisPoint, 'Active' as objectType from dual union

Note:

# of the CP's are changed to the proper number

The HRSOURCENAME is changed to the specific name

[rushikeshvartak]

chart properties keep {} then run dashboard refresh job it will come automatically

[GFC]

Thanks @rushikeshvartak , I have run the Job, but it has not completed, so the graph is still not displayed.

[Dhruv_S]

Hi @GFC 

1. Please refer to the below documentation for creating dashboards as per the requirement.

Working with Dashboards (saviyntcloud.com)

2. Please validate your query is correct or not and see if it is giving results as expected in data analyzer.

3. Please share complete query and dashboard configuration screenshots so that we can replicate at our end.

Regards,

Dhruv Sharma