logo
Welcome Guest! To enable all features please Login or Register.

Notification

Icon
Error

Options
Go to last post Go to first unread
elvinmejoe  
#1 Posted : Wednesday, February 21, 2018 3:17:19 PM(UTC)
elvinmejoe

Rank: Newbie

Groups: Registered
Joined: 2/21/2018(UTC)
Posts: 2
India
Location: Chennai

Thanks: 2 times
Can any one of you let me know how to create a basic pie chart using seal. I have created a data source using my test data which is in an excel.I created a model as well. What i don't understand is how to create a dashboard with a pie chart in it. Can anyone help with this.

Thanks,
Elvin
epf  
#2 Posted : Wednesday, February 21, 2018 3:23:04 PM(UTC)
epf

Rank: Administration

Groups: Administrators
Joined: 12/20/2013(UTC)
Posts: 476
Switzerland

Thanks: 7 times
Was thanked: 68 time(s) in 66 post(s)
It is very simple:
In your model,
Select the Row or Column element that will be the Axis, then expand the Chart Properties and set 'Serie Definition' to Axis
Then select the serie element in Data, and configure the chart properties to NVD3Chart and Pie Serie
thanks 1 user thanked epf for this useful post.
elvinmejoe on 2/22/2018(UTC)
antounjreij  
#3 Posted : Thursday, February 22, 2018 8:12:49 AM(UTC)
antounjreij

Rank: Newbie

Groups: Registered
Joined: 2/19/2018(UTC)
Posts: 0
Lebanon
Location: TRIPOLI

Thanks: 3 times
Can we import new nvd3chart to use since there are few in the system

Edited by user Thursday, February 22, 2018 8:13:42 AM(UTC)  | Reason: Not specified

epf  
#4 Posted : Thursday, February 22, 2018 11:08:15 AM(UTC)
epf

Rank: Administration

Groups: Administrators
Joined: 12/20/2013(UTC)
Posts: 476
Switzerland

Thanks: 7 times
Was thanked: 68 time(s) in 66 post(s)
Actually the 4.0 is on the way, a beta will be available soon,
In addition to NVD3, it will integrate also https://plot.ly/ and http://www.chartjs.org/
Plus full responsiveness reports based on bootstrap.
thanks 1 user thanked epf for this useful post.
antounjreij on 2/22/2018(UTC)
antounjreij  
#5 Posted : Thursday, April 12, 2018 11:23:31 AM(UTC)
antounjreij

Rank: Newbie

Groups: Registered
Joined: 2/19/2018(UTC)
Posts: 0
Lebanon
Location: TRIPOLI

Thanks: 3 times
Can we hide some values from filters without removing them from enumerated list to prevent having multi data source?
antounjreij  
#6 Posted : Thursday, April 12, 2018 1:23:40 PM(UTC)
antounjreij

Rank: Newbie

Groups: Registered
Joined: 2/19/2018(UTC)
Posts: 0
Lebanon
Location: TRIPOLI

Thanks: 3 times
enumerated list is created only for non null values , if the column contain null values so will be missing data when executing report when selecting all non null values .there is a way to show blank cell ?
epf  
#7 Posted : Thursday, April 12, 2018 8:50:58 PM(UTC)
epf

Rank: Administration

Groups: Administrators
Joined: 12/20/2013(UTC)
Posts: 476
Switzerland

Thanks: 7 times
Was thanked: 68 time(s) in 66 post(s)
Good remark, we will check this and see if it can be enhanced in the 4.0
thanks 1 user thanked epf for this useful post.
antounjreij on 4/16/2018(UTC)
epf  
#8 Posted : Tuesday, April 17, 2018 2:09:20 PM(UTC)
epf

Rank: Administration

Groups: Administrators
Joined: 12/20/2013(UTC)
Posts: 476
Switzerland

Thanks: 7 times
Was thanked: 68 time(s) in 66 post(s)
I made a quick test and the trick is the following:
In your table column source, assign a value to NULL values using SQL function of your database engine:
isnull for MSSQLServer
nvl for Oracle

for example, MyTable.Mycolumn becomes isnull(MyTable.Mycolumn, '-')

then creates your enum from this definition and you will be able to select restriction on '-' and to display then in the table.
e.g. for my Enum definition

Code:
select distinct isnull(MyTable.Mycolumn, '-')
FROM MyTable 
ORDER BY 1
Users browsing this topic
Guest (2)
Forum Jump  
You cannot post new topics in this forum.
You cannot reply to topics in this forum.
You cannot delete your posts in this forum.
You cannot edit your posts in this forum.
You cannot create polls in this forum.
You cannot vote in polls in this forum.

Powered by YAF 2.0.0 | YAF © 2003-2018, Yet Another Forum.NET
This page was generated in 0.102 seconds.