We see many questions per day on calculations. While we provide support in this community, you might be able to get unstuck even faster using our new Generative BI features that are in public preview.
The following are two areas we often see calculation questions on the community as well as example prompts for each case to help you understand what you could try out in your own data. There is always the community to turn back to if you still aren’t able to get the calculation you are looking for.
1) Data cleaning calculations
Community questions with example prompts below:
- Timestamp To String
- “convert timestamp to string removing the hh:mm:ss”
- Convert numbers based on some criteria and then sum them
- “create a calculation that changes the time spent on tickets so that the following are true
- If the ticket is duplicated, take the lower of the two.
- If the ticket is not duplicated but has more than 12 hours, then convert that number to 5 hours.
- If the ticket is not duplicated and does not have more than 12 hours using the hours reported.”
- Simple IfElse For Value >0
- “i want the field to say “Good” if Sales is non-zero"
- How can I change period to format date?
- “change date formatting from yyyymm to dd/MM/yyyy”
2) Date calculations
Community questions with example prompts below:
- Calculated
- “find the date using arrival timestamp that is closest to today’s date”
- Last event/ date calculations — break down into multiple steps
- You might need to break down into multiple steps.
- “Get the current date” then name something like current-date
- “Get the latest date of event date” then name something like last-event-date
- “Get the number of days between current-date and last-event-date”
- You might need to break down into multiple steps.
- YoY Change up to current month
- “create a calculated field that outputs if the past data is more than a year from the current month using arrival_timestamp”
- How to arrive trailing 4 weeks data
- “for each sales person what is the trailing 4 week revenue”