JasonKerr Member

Comments

  • @DavidChurchman You're correct about the structure of my data the with one slight qualification, which I think is causing the error here. My data is structured so that the "Actuals" and "Goal" are in different columns, however, the Goal is consistent for every observation, whereas the Actuals need to be summed. Ex) ID…
    in Pivot Table Coloring Comment by JasonKerr August 15
  • @DavidChurchman Sorry, quick follow-up here. Is there anyway to get the Total Row to show the total while still utilizing this solution? Because the CONCAT function changes the data type to character, it is not currently summing the total correctly to display at the bottom. Any workaround there?
    in Pivot Table Coloring Comment by JasonKerr August 14
  • @DavidChurchman Thanks for the suggestion! Unfortunately, the first one is not going to work for the stakeholders, but option b is a nice workaround in lieu of being able to color code the column. (I hadn't realized you could use symbols in a table) It would be nice if Domo could make coloring like this available in Pivot…
    in Pivot Table Coloring Comment by JasonKerr August 14
  • @ArborRose As stated in the question, this does not solve my problem. "Apply to Full Row" does not appear to work on Pivot Tables.
    in Pivot Table Coloring Comment by JasonKerr August 12
  • HTML is not supported in Pivot Tables, correct? How can this be accomplished in a Pivot Table?
    in Color Rules Help Comment by JasonKerr August 12
  • Is there any follow-up on this? Why doesn't the "Apply to Row or Column" select work in a pivot table? How can this be solved?
    in Beast Mode row highlight Comment by JasonKerr August 12
  • @MichelleH This wouldn't work in a pivot table, right? Adding any new "value" fields will have them show up in each segmentation of the table. I am only looking to add one row at the bottom of the table with a total of the values in the columns.
    in Pivot Table Grand Total Comment by JasonKerr August 8
  • This would be a great feature to fix. Forcing an ETL for something as simple as populating NULL dates with 0 is very inefficient and frustrating to users.
    in Have a row displayed with 0/NULL when filtering by date when there's no data Comment by JasonKerr March 15
  • Hi @DashboardDude, First of all, that video was very impressive, I'll definitely be checking out your content in the future! Unfortunately, I had already considered this as a solution, but the reason it doesn't work for my purposes is that the static constant in "Company A Count" that is created in the ETL is not affected…
    in Waterfall/Retention Ratio in Beast Mode Comment by JasonKerr November 2022
  • @DashboardDude. I appreciate you pointing out that mistake, that was not what was in the beast mode, but just a mistake when typing it into my question. My case statement was: CASE WHEN `Interview Round` = ‘First Round’ THEN 1 WHEN `Interview Round` = ‘Second Round’ THEN SUM(CASE WHEN `Interview Round` = ‘Second Round’…
    in Waterfall/Retention Ratio in Beast Mode Comment by JasonKerr November 2022
Default Avatar