Rank: Newbie
Groups: Registered
Joined: 2/21/2018(UTC) Posts: 2  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
|
|
|
|
|
|
Rank: Administration
Groups: Administrators
Joined: 12/20/2013(UTC) Posts: 1,209  Thanks: 14 times
Was thanked: 206 time(s) in 199 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
|
 1 user thanked epf for this useful post.
|
|
|
|
Rank: Newbie
Groups: Registered
Joined: 2/19/2018(UTC) Posts: 0  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
|
|
|
|
|
|
Rank: Administration
Groups: Administrators
Joined: 12/20/2013(UTC) Posts: 1,209 Thanks: 14 times
Was thanked: 206 time(s) in 199 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.
|
1 user thanked epf for this useful post.
|
|
|
|
Rank: Newbie
Groups: Registered
Joined: 2/19/2018(UTC) Posts: 0 Location: TRIPOLI Thanks: 3 times
|
Can we hide some values from filters without removing them from enumerated list to prevent having multi data source?
|
|
|
|
|
|
Rank: Newbie
Groups: Registered
Joined: 2/19/2018(UTC) Posts: 0 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 ?
|
|
|
|
|
|
Rank: Administration
Groups: Administrators
Joined: 12/20/2013(UTC) Posts: 1,209 Thanks: 14 times
Was thanked: 206 time(s) in 199 post(s)
|
Good remark, we will check this and see if it can be enhanced in the 4.0
|
1 user thanked epf for this useful post.
|
|
|
|
Rank: Administration
Groups: Administrators
Joined: 12/20/2013(UTC) Posts: 1,209 Thanks: 14 times
Was thanked: 206 time(s) in 199 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
|
|
|
|
|
|
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.
