![]() |
How do i use XY Line graph in Ireport? |
[Edit] |
Answer
Main DB Query :
SELECT
users_vs_msg."coalesce" AS year_month,
users_vs_msg."messages_sent" AS msg_sent,
users_vs_msg."users_registered" AS users_registered
FROM
"public"."users_vs_msg" users_vs_msg
Fields that i get from it are
$F{year_month},
$F{msg_sent},
$F{users_registered }
Pie CHART
Dbl click chart > "chart tab" > edit chart properties> tab "chart data"> tab "Details">
Key Expression : $F{year_month}
Value expression : $F{msg_sent}
Label Expression : $F{year_month}
Bar-chart
Dbl click chart > "chart tab" > edit chart properties> tab "chart data"> tab "Details"> Category series
Add a category …with these values
Series Expression : $F{year_month}
Category expression : $F{year_month}
Value Expression : $F{msg_sent}
Label: empty
First answer by ID2523226485. Last edit by ID2523226485. Question popularity: 14 [recommend question]





