This is a migrated thread and some comments may be shown as answers.

Bar chart dynamic series

4 Answers 996 Views
Charts
This is a migrated thread and some comments may be shown as answers.
Aleksandr
Top achievements
Rank 1
Bronze
Bronze
Veteran
Aleksandr asked on 05 Apr 2018, 09:46 PM

Dear support team,

 

we have cut one of out legs trying to figure out how to have series dynamically. Could you please provided us an example using json below where Date is Y axis, Count is X axis, form name dynamic series (please see in attachment what we are going to make, attached example use static series unfortunately)

 

[{
"Date": "апр-17",
"Count": 1,
"Order": 0,
"FormName": "USMA004MAMultiJ"
},
{
"Date": "дек-17",
"Count": 2,
"Order": 993,
"FormName": "USOK001SacFox_pers_hist"
},
{
"Date": "дек-17",
"Count": 14,
"Order": 994,
"FormName": "USOK001SacFox_pers_hist_tech"
},
{
"Date": "дек-17",
"Count": 1,
"Order": 995,
"FormName": "USOK001SacFox_pers_hist_tech_renew"
},
{
"Date": "дек-17",
"Count": 1,
"Order": 996,
"FormName": "USOK001SenecaCayugaSecII"
},
{
"Date": "дек-17",
"Count": 11,
"Order": 997,
"FormName": "USOK004AbsenteeShawneeAuthorization"
},
{
"Date": "фев-18",
"Count": 12,
"Order": 1333,
"FormName": "USPA001PAKeyRenew"
},
{
"Date": "фев-18",
"Count": 2,
"Order": 1334,
"FormName": "USPA254MJ"
},
{
"Date": "фев-18",
"Count": 13,
"Order": 1335,
"FormName": "USRI004RI_v1"
},
{
"Date": "фев-18",
"Count": 2,
"Order": 1336,
"FormName": "USRI004RISupplement_v1"
},
{
"Date": "фев-18",
"Count": 14,
"Order": 1337,
"FormName": "USTX004AlabamaCoushattaPersonalApp"
},
{
"Date": "фев-18",
"Count": 1,
"Order": 1338,
"FormName": "USTX004AlabamaCoushattaRelease_v1"
},
{
"Date": "фев-18",
"Count": 1,
"Order": 1339,
"FormName": "USTXC001KickapooLicAp"
},
{
"Date": "фев-18",
"Count": 2,
"Order": 1340,
"FormName": "USTXC004TX_v1"
},
{
"Date": "фев-18",
"Count": 1,
"Order": 1341,
"FormName": "USVI004VirginIslandsPersonalHistory"
},
{
"Date": "фев-18",
"Count": 1,
"Order": 1342,
"FormName": "USWA004WACriminalSupp"
},
{
"Date": "фев-18",
"Count": 1,
"Order": 1343,
"FormName": "USWA004WAIndLicApp"
},
{
"Date": "фев-18",
"Count": 1,
"Order": 1344,
"FormName": "USWAC001ColvilleCasinoVendLicAp"
},
{
"Date": "мар-18",
"Count": 3,
"Order": 1425,
"FormName": "USSDC004OglalaRnwl_v1"
},
{
"Date": "мар-18",
"Count": 2,
"Order": 1426,
"FormName": "USSDC004SDRnwl_v1"
},
{
"Date": "мар-18",
"Count": 4,
"Order": 1427,
"FormName": "USTXC004AlabamaCoushatta_v1"
},
{
"Date": "мар-18",
"Count": 2,
"Order": 1428,
"FormName": "USWA004Muckleshoot_v1"
},
{
"Date": "мар-18",
"Count": 2,
"Order": 1429,
"FormName": "USWAC001PortGamble_renew"
},
{
"Date": "мар-18",
"Count": 2,
"Order": 1430,
"FormName": "USWAC004CowlitzRnwl_v1"
},
{
"Date": "мар-18",
"Count": 8,
"Order": 1431,
"FormName": "USWAC004ShoalwaterOwnership_v1"
},
{
"Date": "мар-18",
"Count": 1,
"Order": 1432,
"FormName": "USWAC004Skokomish_v1"
},
{
"Date": "мар-18",
"Count": 6,
"Order": 1433,
"FormName": "USWAC004Yakama_v1"
},
{
"Date": "мар-18",
"Count": 1,
"Order": 1434,
"FormName": "USWAC004YakamaCover_v1"
},
{
"Date": "мар-18",
"Count": 1,
"Order": 1435,
"FormName": "USWAC004YakamaFees_v1"
},
{
"Date": "мар-18",
"Count": 1,
"Order": 1436,
"FormName": "USWAC004YakamaInstructions_v1"
},
{
"Date": "мар-18",
"Count": 4,
"Order": 1437,
"FormName": "USWAC004YakamaStatement_v1"
},
{
"Date": "мар-18",
"Count": 2,
"Order": 1438,
"FormName": "USWIC004HoChunkAppendix9_v1"
},
{
"Date": "мар-18",
"Count": 1,
"Order": 1439,
"FormName": "USWIC004HoChunkInstructions_v1"
},
{
"Date": "мар-18",
"Count": 1,
"Order": 1440,
"FormName": "USWIC004SiletzUpdate_v1"
}]

 

 

 

4 Answers, 1 is accepted

Sort by
0
Aleksandr
Top achievements
Rank 1
Bronze
Bronze
Veteran
answered on 08 Apr 2018, 08:31 AM
nevermind, the good example was found, chart was created
0
Stefan
Telerik team
answered on 09 Apr 2018, 06:55 AM
Hello, Alex,

I'm glad to hear that the issue is resolved.

Could you please share the example that was used at the end as this will allow more people from the community to find it easier.

In general, this will require a specific logic which will determine which field will be responsible for the value and category axis;

https://dojo.telerik.com/iXuXAweH

Regards,
Stefan
Progress Telerik
Try our brand new, jQuery-free Angular components built from ground-up which deliver the business app essential building blocks - a grid component, data visualization (charts) and form elements.
0
Aleksandr
Top achievements
Rank 1
Bronze
Bronze
Veteran
answered on 09 Apr 2018, 07:15 AM

i used this example 

https://dojo.telerik.com/enUQACOK

it is 100% what i need. I have just added custom sorting to have the Y (Date) axis be sorted chronologically, because according to documentation default sorting does not work when you group the data

 

Thx Alex

 

0
Stefan
Telerik team
answered on 09 Apr 2018, 07:20 AM
Hello, Alex,

Thank you for sharing the example with the community it is highly appreciated.

I updated your Telerik points for sharing this with us.

Regards,
Stefan
Progress Telerik
Try our brand new, jQuery-free Angular components built from ground-up which deliver the business app essential building blocks - a grid component, data visualization (charts) and form elements.
Tags
Charts
Asked by
Aleksandr
Top achievements
Rank 1
Bronze
Bronze
Veteran
Answers by
Aleksandr
Top achievements
Rank 1
Bronze
Bronze
Veteran
Stefan
Telerik team
Share this question
or