Forum Discussion

mtrevisiol's avatar
mtrevisiol
Helper V
5 years ago
Solved

Display continuous line in area chart

Hi everyone. I've got this area chart: On the X axis I put the calendary date, that is connected to all tables. The orange measure represents the total sales per month for the selected item ...
Need Help
Tips and Tricks
Tutorial Requests
  • mtrevisiol's avatar
    mtrevisiol
    5 years ago

    I managed to do it by using the field 'Date' instead of 'Date hierarchy' as x axis, setting 'continuous' type as parameter.

selimovd's avatar
selimovd
Most Valuable Professional
5 years ago

Hey mtrevisiol ,

 

you can use a cumulative function like DATESBETWEEN to get values for each day.

 

If you need any help please let me know.
If I answered your question I would be happy if you could mark my post as a solution ✔️ and give it a thumbs up 👍
 
Best regards
Denis
 
  • mtrevisiol's avatar
    mtrevisiol
    Helper V
    5 years ago

    selimovd thank you for the answer, could you explain more in detail how DATESBETWEEN can be useful for my purpose? Thanks.