Rank: Newbie
Groups: Registered
Joined: 8/13/2018(UTC) Posts: 6  Location: Ankara Thanks: 2 times
|
Hi,
We've started to use SealReport with PostgreSQL.
We are stuck at displaying total price per month.
For example we have sales table.
Structure:
sale
id int,
...
sale_ts timestamp,
price double precision
Trying to do, total price per month
In model we are casting date_part('month',sale_ts) with custom sql.
Example chart:
Month Sum(price)
1 10776,53
2 13421,65
...
If I use enum, it uses enum for order too. And this is same if I use join on database
Month Sum(price)
February 13421,65
January 10776,53
...
What I want to see
Month Sum(price)
January 10776,53
February 13421,65
...
So I just want to split display values and order values.
I would be happy if someone help me.
|
|
|
|
|
|
Rank: Administration
Groups: Administrators
Joined: 12/20/2013(UTC) Posts: 1,209  Thanks: 14 times
Was thanked: 206 time(s) in 199 post(s)
|
This is a classic issue.
You have an option to sort the enum by yourself....
Select your enum and set 'Use defined position to sort in reports' to true.
Set your enum as not dynamic.
Then edit your enum values list and sort it with the Ip and Bottow Arrows.
Good luck.
|
 1 user thanked epf for this useful post.
|
|
|
|
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.
