Forum Discussion

Tomcat3's avatar
Tomcat3
Icon for Helper I rankHelper I
4 years ago
Solved

Smart Narrative date formatting options - no YYYY format

Using Smart Narrative with data range of 20 years. With auto-generated date fields, there is no YYYY (year only) option. I can live with the closest option of YYYY-MM but my client does not like it....
Need Help
  • Tomcat3's avatar
    Tomcat3
    4 years ago

    Let me know if I am in the correct location described in your solution. 

    The column is a true Date field with YYYY formatting. This is how I see the column in Desktop, but it does not carry forward to the Narrative control.

     

    Please clarify "....If your first row date is 15/05/2022  type in the Fomat boc 2022 (yyyy)..."

     

  • Tomcat3's avatar
    Tomcat3
    4 years ago

    Not a solution, rather an acknowledgement the desired formatting is not available in Smart Narrative. We are re-factoring the design. We were aggregating at the yearly level as a rapid prototype. However, using Dataflows with Enhanced Compute Engine if very efficient and the added granularity (monthly) improves results in the related Key Influencer viz.

     

speedramps's avatar
speedramps
Icon for Super User rankSuper User
4 years ago

Thanks Tomcat3 for the better explanation.

 

Sorry, I dont use Smart Narrative.

 

Can you overtype the result with YYYY like you can on the Format menu ?

 

Or could you add a YYYY measure and use that instead

Like in this example  https://www.youtube.com/watch?v=ZaZyR3-1ru4

 

Sorry I cant help more with this. If you dont get an answer then try asking a new question on the forum with the better description.  Sorry I misunderstood first time round. My bad !  ☹️