Trimmed dimension on lined-chart

[#1]

Hi,

The chart above (taken from 'Whats New in Qv10.qvw') shows the accumulated sales accross dates.The dimmension's label is per trimmed to Month - MM-YYYY.

How is this done?!! No matter how deep i've looked i couldn't figure this out

[#2]

ok. I figured this out (has to do with the number format of the dimension)

Now came the following challenage. I would like to show the sales per hour whereas the dimension label wil show the day of the week.

Can this be done?

[sushil353]

if you have hours in your date field then u can eaisly do it...using Date funtion.

Date(date_field,'HH:MM')

HTH

Sushil

[#4]

Hi,

      Use this format in the Dimension

WeekDay(Dimension)

[#5]

Stil not working. I've attached an example.

[#6]

Hi ,

    Try to have Two Dimension in the Chart .

  1 .  Date(date_field,'HH:MM')  ( As Sushil Suggested )

  2. WeekDay(Dimension)

please let me know if your Requirement is met .

[#7]

Oh, I didn't you can have two cascading dimmension on same axis on line chart. How do you do that?