Issue with using calculated field in "Values" section with Pivot Table
Hi all,
Up until recently, I was able to use calculated fields in the pivot table in order to display a text value:
However, when attempting to do this on new cards, it will only let me use COUNT. Below is a different card/dataset, but in theory, shouldn't it be functioning the same way?
I've tried adding it as a row first, then moving it to the values section, hoping that would "trick" it, but I don't understand why the "Values" section is forcing an aggregation of COUNT recently, whereas in the past, I've been able to create numerous cards without this aggregation type.
Any help would be greatly appreciated!
Answers
-
Are you sure this isn't caused by the data you are using and the fields that are presented in rows and columns?
** Was this post helpful? Click Agree or Like below. **
** Did this solve your problem? Accept it as a solution! **1 -
Thanks for the suggestion! I added in a date (similar to the first example) and that worked! I'm not sure why it doesn't work without it, but this should suffice.
0 -
It looks like all those conditions point to
parent_entity_title
. What's the point in the CASE statement? I think you want what you had before but remove the ELSE clause.** Was this post helpful? Click Agree or Like below. **
** Did this solve your problem? Accept it as a solution! **0 -
Good point on removing the ELSE clause.
The initial goal was just to have the $ amount of specific parent_entity_titles and then the corresponding title next to them (without the date). I still can't get it to work with just the parent_entity_title, but having the date_added field included is fine, it just means I won't be able to use color rules.
0
Categories
- All Categories
- 1.8K Product Ideas
- 1.8K Ideas Exchange
- 1.5K Connect
- 1.2K Connectors
- 300 Workbench
- 6 Cloud Amplifier
- 9 Federated
- 2.9K Transform
- 100 SQL DataFlows
- 622 Datasets
- 2.2K Magic ETL
- 3.9K Visualize
- 2.5K Charting
- 744 Beast Mode
- 58 App Studio
- 41 Variables
- 686 Automate
- 176 Apps
- 453 APIs & Domo Developer
- 47 Workflows
- 10 DomoAI
- 36 Predict
- 15 Jupyter Workspaces
- 21 R & Python Tiles
- 395 Distribute
- 113 Domo Everywhere
- 276 Scheduled Reports
- 6 Software Integrations
- 125 Manage
- 122 Governance & Security
- 8 Domo Community Gallery
- 38 Product Releases
- 10 Domo University
- 5.4K Community Forums
- 40 Getting Started
- 30 Community Member Introductions
- 108 Community Announcements
- 4.8K Archive