I’m trying to produce a line chart that has multiple values… one calculated field for each year but I want just the month on the x axis so the lines stack essentially. I was able to do this using the extract function but then i’m left with numbers on the x axis. Is there another way around this?
This is what I have and what I don’t want
Hi @dspringer,
Could you share what you created for the extract function..did you setup to extract your month’s (and if so, are those the numbers you’re receiving on the x-axis? If that’s the case, you could then try setting up an additional calculated field that utilizes the switch function, that way you can present the Month in text instead of a number.
extract(‘MM’, DepletionMonthDate)
and yes the numbers are on the x axis.
also if i were to use the switch or ifelse route, how do you preserve the order of the months?
I think I figured it out. I used switch and then sorted the x axis off the extract field.
1 Like
Hi @dspringer,
Sounds great, let us know if you have any additional questions!