Hi there, I currently have a graph with 1 X-Axis value. The field is called SignupDate.
Right now I apply a filter onto the graph to show customers who are VIPs signed up.
I’m looking to enhance this by showing all sign ups vs vip sign ups.
Orange lines would be VIP sign ups, which is always a subset of total signups.
My current data is structured as followed.
Customer SignupDate IsVip
John 2023/08/16 true
Jeff 2023/08/16 false
Hello @boss, are you able to respond to @ErikG’s request with some information about the problems you are facing? To me it seems like you would need a function to calculate the total Signups by Date along with the total signups where VIP is true. In that case, you could probably accomplish this with 2 calculated fields. For your x-axis, add your SignupDate field. Then, in your values you can use these:
allSignUps = ifelse(isNotNull({SignupDate}), 1, 0)
vipSignUps = ifelse({IsVip} = True, 1, 0)
Since your visual will be ordered by date, there would not be any need to add further grouping then you would just sum these fields in the field well. If it does give you issues with the display, sumOver can be utilized to ensure it would match with each date field. That would look something like this:
sumOver({allSignUps}, [{SignupDate}], PRE_AGG)
I will mark this as a solution but if you have follow-up questions or you were looking for a different solution please let me know.