Okay
  Public Ticket #1807508
Field descriptions in WpCharts
Closed

Comments

  • cjm007 started the conversation

    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


  •  471
    Isidora replied

    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: FAQFacebookTwitterFront-end and back-end demoDocs

    Amelia: FAQFacebookTwitter |  Amelia demo sites | Docs

    You can try our wpDataTables add-ons before purchase on these sandbox sites:

    Powerful FiltersGravity Forms Integration for wpDataTablesFormidable Forms Integration for wpDataTables