Hi everyone,
We are trying to figure out how to put the date of two separate data values next to each other, but have no lucks so far.
Here is how our widget looked like:
And this is the result:
As you can see. the all of the 2019 data (Blue) are on top, and the 2020 data (Orange) are on the bottom. What should we do in order to have our results look like this:
Jan 2019 - Blue
Jan 2020 - Orange
Feb 2019 - Blue
Feb 2020 - Orange
We appreciate for all your helps. Thank you in advance!
Tom Nguyen
Hi Tom,
Try using Calendar Month, the numeric value, or Calendar Month Sort instead of the Date field at the Month level. The Date data type fields are really good for some of the functional date math features, but for grouping by time periods across other type periods without do a separate value formula for each period, the non-Date data types are a little more friendly.
That works for me. Hopefully the users will like it. Thank you very much Chris!