SELECT DATE_FORMAT(FROM_UNIXTIME(realdate),'%w') as Dagnr, DATE_FORMAT(FROM_UNIXTIME(realdate),"%a") as Dag,
COUNT(user_id) as Aantal FROM userrit where jaartal = '%VAR1%' and weeknr = '%VAR2%' group by Dagnr
This show per day the number of cycle events. The days however are "Sun, Mon, Tue, Wed etc.". I am Dutch, so I made some conditional formatting in the fields properties to show "Maa, Din, Woe, etc,..". Now when I create a wpChart it does not show my formatting value, but the original "Sun, Mon, Tue, Wed etc."".
That is default behavior of charts engine, because Conditional formatting is not applied in data in chart because chart take original data from table. You have to make another table where you will insert names of the day on language that you need (in data source that you use) and then make a chart. Like this it will be shown chart like you need.
Hi
I created a Datatable:
SELECT DATE_FORMAT(FROM_UNIXTIME(realdate),'%w') as Dagnr, DATE_FORMAT(FROM_UNIXTIME(realdate),"%a") as Dag,
COUNT(user_id) as Aantal
FROM userrit
where jaartal = '%VAR1%' and weeknr = '%VAR2%'
group by Dagnr
This show per day the number of cycle events. The days however are "Sun, Mon, Tue, Wed etc.". I am Dutch, so I made some conditional formatting in the fields properties to show "Maa, Din, Woe, etc,..". Now when I create a wpChart it does not show my formatting value, but the original "Sun, Mon, Tue, Wed etc."".
Is this a bug??
Best regards, Kees Bond
Hi Kees,
Thank you for your purchase.
That is default behavior of charts engine, because Conditional formatting is not applied in data in chart because chart take original data from table. You have to make another table where you will insert names of the day on language that you need (in data source that you use) and then make a chart. Like this it will be shown chart like you need.
Best regards.
Kind Regards,
Isidora Markovic
wpDataTables: FAQ | Facebook | Twitter | Front-end and back-end demo | Docs
Amelia: FAQ | Facebook | Twitter | Amelia demo sites | Docs
You can try our wpDataTables add-ons before purchase on these sandbox sites:
Powerful Filters | Gravity Forms Integration for wpDataTables | Formidable Forms Integration for wpDataTables