Data not visible for 2017

[dolly777]

Hi All,

Current year data not visible in my dash board could you Please suggest?

Please find screen shot.

[#2]

Hi Nirmala

Do you have any data in your application for 2017?

What does your expressions look like? (Might be hard coded to 2016?)

Please provide a bit more information regarding your error / problem.

Kind Regards

[#3]

Hi Nirmala

Does you data for 2017 dates if so it might show

[Anonymous]

Hi,

Check the data format for those with 2017, the year to be 2017, if you are loading from xls or different source than 2016.

Check first if you have in the fact tables values, maybe a field that connects table is not correct set.

Best regards,

Cosmina

[dolly777]

Hi Jandre,

Please find Expression 4 chart

first chart exp is

=SUM(

  {<

  %measures={'overall_capex','overall_pure','overall_e_catalogue','overall_no_po','overall_nb_orders_rto'},

  %selection_type={'selective'},

  %year={'$(=MAX(%year))'}

  >}values

)/1000000

--------------------------------------------

=SUM(

  {<

  %measures={'overall_capex','overall_pure','overall_e_catalogue','overall_nb_orders_rto','overall_no_po'},

  %selection_type={'selective'},

  %year={'$(=MAX(%year))'}

  >}values

)/SUM(TOTAL

  {<

  %measures={'overall_capex','overall_pure','overall_e_catalogue','overall_nb_orders_rto','overall_no_po'},

  %selection_type={'selective'},

  %year={'$(=MAX(%year))'}

  >}values

)

[#6]

Hi Nirmala

Please make sure this returns 2017 : =MAX(%year)).

Might be a date issue or some data isnt in the database yet.

Kind Regards

[dsharmaqv]

please attach your sample app. if data is present for 2017 then problem with the expression only.